users report is slow to open

rbuser

Hi, we have implemented an end user reporting system using report builder
10.02. Our client has created a large master to multi detail report
consisting of 12 queries and they are upset that the report takes about 10
seconds to open. I have had a look at the queries and they are not hard core
at all, altogether the queries should only take about half a second to run.
I've put some debug code in our server application and found that the client
application appears to be running about 80 dade queries against our database
when we run this one report. Does anyone know why so many queries are being
run? (perhaps a design flaw in the report)

Thanks,
Jacques

rbuser

Hi, just wanted to add more info to my problem. I have created a simple 2
query master detail report and I logged the dade queries that where
requested from my server and I see that both the queries in my report where
execute 4 times each. I've attached the sql log file. So is it possible i
have made a mistake somewhere when setting up the report builder components.

Regards,
Jacques

nardmoseley

- What DADE plug-in are you using?

- When a report is opened for editing, I do not think the dataset is
acivated. Or do you mean the report is opened for preview?

- Add RBuilder\Source to the Delphi library path and trace ppDBPipe.pas, the
method TppDBPipeline.OpenDataSet. That method calls DataSet.Open. I think
this can be called many times, but the DataSet.Open internally should not
have to re-submit the query to the database.