I find it much easier to use SQL Select to create a cursor with the relevant data, and let this cursor drive the report.
>Hi all
>I had 3 tables account.dbf,bill.dbf and ledger.dbf
>in my prg....
>
>USE account ORDER ac
>USE bill ORDER ac IN 0
>USE ledger ORDER ac IN 0
>SELECT account
>SET RELATION TO ac INTO bill,ac INTO ledger
>REPORT FORM test
>SET SKIP TO bill,ledger
>REPORT FORM TEST
>
>account a got 2 records in bill and 4 records in ledger
>account b got 2 records in bill and 1 record in ledger
>why some record missing in my muti detail band report ?
>
>account a
>bill date 02/02/14 amount 456.00
>bill date 03/03/14 amount 789.00
>bill date / / amount 0.00
>bill date / / amount 0.00
>ledger 01/01/14 desc xxxxxxxxxxxxxxxxx amount 1.00
>ledger 03/01/14 desc yyyyyyyyyyyyyyyyy amount 2.00
>***another 2 records missing
>
>account b
>bill date 01/01/14 amount 123.00
>bill date 02/01/14 amount 444.00
>ledger 02/01/14 desc zzzzzzzzzzzzzzz amount 1.00
>ledger / / desc amount 0.00
>***additional blank record in ledger
>
>please help me !