regarding output format

[Former Member]

hi frends,

i have a report with this output format.

tonum item itemDesc quantity site

12 1 hhuuh 5 h001

12 2 fdefe 6 h001

14 1 fsdfsd 8 d001

14 2 efer 4 d001

16 1 efe 6 w001

16 2 feff 2 w001.

but now i want to diaplay the output like this

item itemDesc site1 site2 site3 site4

1 dfdf 5(q) 6(q) 8(q) 5(q)

2 ggff 5(q) 5(q) 5(q) 5(q)

3 fdfd 5(q) 5(q) 5(q) 5(q)

4 fdfd 5(q) 5(q)

this is the final output format i need.ie i need to creat a column for site .for that all the sites available for my delivery number that amny columns should b created.and for each site column i should disply the quantity available for each item number.i created site column but now i was stuck up with how to display quantity for the site column for each item available.pls help..

[Former Member]

Hi Rahul,

In the Site id column you displaying the Site name i.e. h001 or are you planning to display the quantity?

I assume you have a dynamic number of site ids. Easy way is to define columns for all the sites with their names in the heading. Then you can display the subsequent quantities for each of those sites.

Hope this helps

Best Regards.

[Former Member]

i want ot display under siteid column all the quantities each corresponding to the items available.ie for site1 i can display all the quantities for the items but for site2 i should display the quantity under the next column heading site2 for all the items.and this should b repaeted for all remaining site3,site4, and so on.how can i do this.

[Former Member]

Please check your other post for the same query..I have put forth my solution.