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.