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