From: Paul on
I have a report in tabular design, it has the header row and two details
rows. I embedded a subreport named "subreport_1" to the details row. In the
"subreport_1" it has two details rows with another subreport named
"subreport_2" embedded to it. All subreports are hidden and it can set to
visible with the click on a column cell. The problem is taken forever to
open the main report and I know the SSRS try to render the report and the
two subreports when first opening, Is there a way to stop the loading of the
subreports when opening the main report and the subreport will only be
loaded when user clicks on the cell for that subreport. Thanks. I am using
Sql 2005 SSRS.