Advertisement

02.16.2002 at 02:12AM PST, ID: 20267574
[x]
Attachment Details

QuickReport -  Large Master /Detail Report very slow

Asked by PhilatHome in Delphi Programming, Delphi Printing

Tags: detail, master, quickreport, report

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.DLOCATION,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,LK.QTY,
(LK.COST *(1+(LK.MARKUP/100)) * (1 + cast(hw.gst as integer)) AS COST,
lk.qty*LK.COST*(1+(LK.MARKUP/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
[+][-]02.18.2002 at 04:02PM PST, ID: 6809320

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Delphi Programming, Delphi Printing
Tags: detail, master, quickreport, report
Sign Up Now!
Solution Provided By: Phoenix_s
Participating Experts: 1
Solution Grade: A
 
 
[+][-]02.18.2002 at 07:22PM PST, ID: 6809610

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32