Question on Subreport (Report Builder 5.52, Delphi 5, Sql Server 2000)

rbuser

I am working on a report which has several subreports. I print the sub
reports based on certain conditions. I basically set the visible property of
the subreport to false and I do not open the query components that are
hooked to this subreport and all that works fine.

However when I look under the covers using query profiler I am noticing
that even though I am not printing the sub report , Report builder is firing
the query that is attached to my subreport. How can I stop it from
executing? It is slowing down my report a lot.

Any help in this regard will be greatly appreciated.

Thanks
Sujas

nicocizik

Hi Sujas,

Sorry about the delay in my response. Simply setting the subreport's
visibility to False will not stop ReportBuilder from accessing the data for
that subreport. You might try temporarily disconnecting the datapipeline
connected to the subreport and setting the datapipeline's visibilty to false
when you do not want ReportBuilder to pull data from the database. Then
once you need the data, reconnect the pipeline and set it's visibility back
to true.

--