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