Help in Dynamic Report

[Former Member]

Hi,

My requirement is to display the standard report pc00_m99_cwtr which is displaying row wise should be displayed column wise.

For Example:

The present output is:

-

---

EmpNo Wagetype Amount

-

---

123 /101 1500.00

123 /102 1200.00

234 /103 1000.00

My Requirement is:

-

---

Empno /101 /102 /103

-

---

123 1500 1200

234 1000

I mean for some employee there wil be some wagetypes and for there wagetypes may be different, so how to display the amounts into corresponding wagetypes?

Regards,

Srinath

[Former Member]

Hi,

My requirement is to display the standard report pc00_m99_cwtr which is displaying row wise should be displayed column wise.

For Example:

The present output is:

-

---

EmpNo Wagetype Amount

-

---

123 /101 1500.00

123 /102 1200.00

234 /103 1000.00

My Requirement is:

-

---

Empno /101 /102 /103

-

---

123 1500 1200

234 1000

I mean for some employee there wil be some wagetypes and for there wagetypes may be different, so how to display the amounts into corresponding wagetypes?

Regards,

Srinath

[Former Member]

Hi Srinath,

For this there is no direct way wherein we can convert the vertical format to horizontal format.

This is one feasible option, according to me.

1. Create one another internal table (for horizontal format). It should have fields for all wage types.

(i.e. possible wage types being used in the configuration)

The field name can be WAGE_101 WAGE_102 and so on.

2. The field WAGE_101 is for purpose of containing amounts only for wage type 101... and so on for the rest of the fields.

3. Now we will have to write special logic wherein we loop at the vertical table,

and based upon the wage type and the FIELD NAME in the horizontal tab

(either we use IF condition for all wage types, or we can use field symbol for dynamic field name)

we can populate the values in the horizontal fields.

Its little tricky, but it can be done.

Regards,

Amit Mittal.