Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data in rows to be displayed in column in report
Message
From
11/06/2003 11:23:24
 
 
To
11/06/2003 01:52:54
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00798765
Message ID:
00798962
Views:
28
You may want to try Grouping on Buyer+shipmentDate+Style+Colour, then create variables with a calculated value such as:

twenty_by_twenty iif(size='20X20',qty,0) and place the variables in the detail and of your report.

>Hi All,
>I am having a cursor with fields buyer,buyerorder,shipmentdate,style,artile,colour,fabriccode,size,quantity,average.
>Now, my data is something like this
>A, 123, 10/10/89, DISCO, DEC, BLUE, FAB1, 20X20, 50, 0.26
>A, 123, 10/10/89, DISCO, DEC, BLUE, FAB2, 20X20, 50, 0.56
>A, 123, 10/10/89, DISCO, DEC, BLUE, FAB3, 20X20, 50, 0.12
>A, 123, 10/10/89, DISCO, DEC, BLUE, FAB1, 50X30, 60, 0.10
>A, 123, 10/10/89, DISCO, DEC, BLUE, FAB3, 50X30, 60, 0.90
>A, 123, 10/11/89, DISCO, DEC, BLUE, FAB1, 20X20, 20, 0.26
>A, 123, 10/11/89, DISCO, DEC, BLUE, FAB2, 20X20, 20, 0.56
>A, 123, 10/11/89, DISCO, DEC, BLUE, FAB3, 20X20, 20, 0.12
>
>Now, I want output something like this ....
>
>Buyer :- A Buyerorder:-123 Shipmentdate:-10/10/89
>Style :- DISCO Colour :- Blue
>
>Size :- 20X20 50X30
>Quantity 50 60
>Fabric Code/Avg.
>FAB1 0.26 0.10
>FAB2 0.56
>FAB3 0.12 0.90
>
>Buyer :- A Buyerorder:-123 Shipmentdate:-10/11/89
>Style :- DISCO Colour :- Blue
>
>Size :- 20X20
>Quantity 20
>Fabric Code/Avg.
>FAB1 0.26
>FAB2 0.56
>FAB3 0.12
>
>
>Please help me in doing this........
>
>Thanks and regards
On a CLEAR day you can see forever.
Previous
Reply
Map
View

Click here to load this message in the networking platform