Drill down with hide/unhide details - performance optimization
I'm using reporting services 2008R2. Within reporting services I hide/unhide the details section based on another control. Yet, when clicking on the control within some reports it takes a long time to refresh. I have the idea the underlying stored procedure is requeried. In what way can hide/unhide detail actions be made without requerying the total dataset? In other words, what type of configuration will deliver best performance?
September 25th, 2012 7:35pm
Hi Giovi2012, As per my understanding, when you click + sign to expand the drill-down report, it takes some time to display the data that retrieve from the query when the report initial run. In your description, you said that the time was used to rerun the total dataset, I am afraid you have something misunderstand on it. I have tested it on my test environment, if the data under that was hidden is very huge, it takes a long time to refresh. If the data that was hidden is small, it takes a little time to refresh. If the time was used to rerun the total dataset, the time should be the same no matter the data that be hidden is huge or small, didnt it? So the time was used to execute drill-down, its long or short base on the data that under the drill-down, we cannot change it. Hope this helps. Regards, Charlie Liao
September 27th, 2012 4:42am
Thank you charlie I will test this too. I think you are right, it will not requery but reprocess the report and as the layout changes, and when summarized values exist this might take some more time. I will leave this topic open eventually I will post a resolution
September 27th, 2012 2:20pm
I did some extra investigation lthough not being able to reach the original reports using a dummy report. Within these reports i also use hide/show parameters. These parameters seem to be very performance intensive on the rendering of the report while a group based toggle is fast. Somebody else noticed this?
October 1st, 2012 3:32pm