>how to create fast reports like this :
>
>this report takes long time if i have so many accounts (if i have 1000 accounts) to generate the report.
>
>
>
>Account : ABC
>-----------------------------------------------------------------------------------
> Dr.Date Dr.Vno Dr.Amount | Cr.Date Cr.Vno Cr.Amount
>-----------------------------------------------------------------------------------
> 01.04.2007 101 5000.00 | 05.04.2007 15 3000.00
> 01.04.2007 102 2000.00 | 05.04.2007 16 1000.00
> 01.04.2007 103 3000.00 | 05.04.2007 17 1000.00
> 03.04.2007 104 3000.00 |
> 04.04.2007 105 3000.00 |
> 05.04.2007 106 3000.00 |
>-----------------------------------------------------------------------------------
> Dr.Total 19000.00 | Cr.Total 5000.00
>-----------------------------------------------------------------------------------
>
>my ledger.dbf is :
>
>acname c(50)
>vno n(6)
>date d
>vtype c(1)
>amount n(12,2)
>
>in field "vtype" D=Dr C=Cr
>
>this are the records in my dbf (Example) :
>
>acname vno date vtype amount
>ABC 101 01.04.2007 D 5000.00
>ABC 102 01.04.2007 D 2000.00
>ABC 103 01.04.2007 D 3000.00
>ABC 104 03.04.2007 D 3000.00
>ABC 105 04.04.2007 D 3000.00
>ABC 15 05.04.2007 C 3000.00
>ABC 16 05.04.2007 C 1000.00
>ABC 17 05.04.2007 C 1000.00
>ABC 106 05.04.2007 D 3000.00
>
>
>
>
>warm regards,
>mk.
how do you want the report to behave if the account goes across another page ?
