Dynamically Loading SubReport Data in SSRS
This is in SSRS 2008.
I created a report with a table embedded in tablix, there is a sub report. There is a lot of information in this report (and I mean a lot - it takes over 45 seconds to load).
I don't want to show this, or rather, process / load data when the report is initially run. Note that I don't want to just not display it, because then all data is still being processed at the initial load time.
Instead, I want the subreport being processed (and the data deleted) individually when I show it (for example, by clicking the + sign to toggle it, or any other option, like clicking an image / link while in the same report). I also don't want to open the sub-report in another tab or something ...
Does anyone know a solution? Maybe there is an onLoad method, a dynamic slave or something like that?
I tried looking into the DataElementOutput attribute, but it's readOnly ... anything else?
a source to share
So, as it turned out, the problem was that I had a recount for every row in the parent report. So the subheading has been called many times ...
And according to MS, there is no way to dynamically handle individual subheadings. Had to solve this problem by splitting the subheading (at least the heavy details) into a separate page. :(
a source to share
Before going through a lot of hoops to implement a workaround, have you analyzed the query execution plan that supplies the data for the subplot? If you haven't, it's worth seeing if you can improve performance by adding a coverage index to help the query optimizer deliver data quickly.
Hope it helps,
Bill
a source to share