>I have a table that has four fileds Date, , Debit and credit. I am using reports (.FRX) to generate required output from the above table.
>
>In my table I first 50 entries for debits and than 50 entries for credit, thus the record total is 100.
>
>When I place debit and credit fields in detail band of my report file (.FRX) first 50 debit entries are displayed and after that 50 credit entries. So there is uncenessary wastage of stationary and the report runs long.
>
>I need that since debit and credit are two columns they should be placed side by side as far as possible. Is it possible ,If yes How? Dates of Debit & credit are different.
>
>
>Kinldy Guide


SELECT your key,date,debit and key,date,credit records for non-zero values into two cursors.
Using a loop for each key field, pull in key,date,debit into key,dated,debit, and on same record load key,date,credit into datec,credit.
Then you have a new cursor with key,dated,debit,datec,credit which can be reported on.