Hee,

Would it be possible for you to create a cursor with all the information instead? I usually drive the reports with one file only.

>i wrote some set relation coding shown in below
>results are fine in my browse windows
>but when i output to report designer with data grouping : code
>it gives funny result.....
>the first group has all the detail data, why? and how to solve that problem ?
>
>USE code ORDER code
>USE detail ORDER code IN 0
>SET rela to code into detail
>SET SKIP TO detail
>BROWSE FIELDS code,desc nowait
>SELECT detail
>BROWSE FIELDS date,code,ref_no,qty,amount nowait && these ok
>
>*****output with data grouping result
>
>code : FNT/N
>desc : FINE WOOD LOCK WITHOUT HANDLE
>
>DATE CODE REF QTY AMOUNT
>03/19/09 FNT/N 12345 10 20.50
>03/10/09 FNT/N1 12042 5 15.70
>02/06/09 FNT/N2 12040 1 19.00
>------------------------------------------------------------
>code : FNT/N1
>desc : FINE WOOD LOCK WITH HANDLE
>
>DATE CODE REF QTY AMOUNT
>03/10/09 FNT/N1 12042 5 15.70
>------------------------------------------------------------
>code : FNT/N2
>desc : FINE WOOD LOCK WITH DOUBLE HANDLE
>
>DATE CODE REF QTY AMOUNT
>02/06/09 FNT/N2 12040 1 19.00
>------------------------------------------------------------