Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Data in rows to be displayed in column in 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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement