You'll have to create a cursor that has the data grouped together as you want it.
Cathy
>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