I am using QuickReport and Delphi 4 professional.
I have 2 Tquery's linked as Master /Detail.
The Master query has 3000 records.
The Detail Query has 11000 records.
For each Master Recored there is approx 6 to 12 Detail records.
Master SQL :
SELECT DISTINCT
LK.DOORID,LK.DFLOOR,LK.DLO
CATION,DR.
TRADE
FROM "c:\D2000\DR1234.dbf" DR
LEFT JOIN "c:\D2000\LK1234.dbf" LK
ON (LK.Doorid = DR.Doorid)
WHERE DR.FLAG = FALSE
ORDER BY DFLOOR,LK.DLOCATION
Detail SQL :
SELECT LK.DOORID,LK.PRODGROUP,LK.
HARDCODE,L
K.QTY,
(LK.COST *(1+(LK.MARKUP/100)) * (1 + cast(hw.gst as integer)) AS COST,
lk.qty*LK.COST*(1+(LK.MARK
UP/100))* (1 + cast(hw.gst as integer)) AS TOTAL,
HW.DESCRIP,
DR.DREMARKS
FROM "c:\D2000\LK1234.dbf" LK
LEFT JOIN "c:\D2000\DR1234.dbf" DR ON LK.Doorid = DR.Doorid
LEFT JOIN "c:\D2000\HW1234.dbf" HW ON LK.Hwid = HW.HWid
WHERE LK.Doorid = :Doorid
ORDER BY LK.PRODGROUP,LK.HARDCODE
I open the queries, and preview the report which is designed as a Master/Detail Report with the report datasource is the master query, and the detail data source is the detail query.
The report appears in the preview screen, and takes approx 10-20 secs per page. The report might be 300 pages.
Thats a cool 75 mins or so.
Is there any way i can speed up the generation and printing of this report please ?
Start Free Trial