Home› General
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

RepordBuilder Drill down opens detail SQL many times

rbuserrbuser
edited November 2003 in General
Dear Digital Metaphors support team,



We have just run into serious problem. Looks like DrillDown feature opens
drill down sub reports too many times. According to you documentation we
expected that drill down master-detail reports do not open (i.e. do not
calculate) detail datasets until user presses drill down component. But it
seems not completely true.



Please find the example attached. It is completely based on your drill down
tutorial demo file.

All what we did was:

1) Replace table tblItem with SQL query

2) Connected this query to Dataset dsOrder to make master detail
relationship.

3) OnBefore event of this query shows debug message.



The report prints the same way but when we initially render the report it
shows the debug message many times (we suppose it MUST NOT show this message
at all i.e. do not open SQL since no data needed to print high level
report).

When we click on drill down component it shows the debug message many times
again (we suppose it must show this message ONE TIME i.e. open the SQL one
time)



The problem is that our detail SQL in the real application is VERY time
consuming. And we can not afford this behavior of the RB.



As you can see the PassSettings of all reports was set to psOnePass
according to the documentation.



You prompt answer is very much appreciated. This issue blocks our
development. Please provide your recommendations on workaround if this issue
it not going to be resolved soon.



Thanks.



SEnSE Ltd, Kharkov, Ukraine.



-----------------------------

System details:

RB ver 6.03

Windows 2000

Delphi 6

Comments

This discussion has been closed.