Drill down with hide/unhide details - performance optimization RRS feed

  • Question

  • 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?

    • Edited by giovi2012 Tuesday, September 25, 2012 11:31 PM
    Tuesday, September 25, 2012 11:31 PM

All replies

  • 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, didn’t it? So the time was used to execute drill-down, it’s long or short base on the data that under the drill-down, we cannot change it.

    Hope this helps.

    Charlie Liao

    Thursday, September 27, 2012 8:40 AM
  • 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

    Thursday, September 27, 2012 6:18 PM
  • 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?

    Monday, October 1, 2012 7:30 PM