Post reply

Expand/Collapse All

  • March 4, 2010 at 7:36 am

    #386434

    Hey all,

    I found an example online (http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/a6a26646-5439-4b31-803d-baf3e9fe0bd0) on how to do expand/collapse all, and I'm wondering if there isn't an easier way to do it? Basically, they have two buttons, expand/collapse, which simply calls the same report with a parameter for @DrillDown, one true, one false. So it basically re-re renders the report. It makes me re-enter my parameters (even though on the image properties action, I pass each parameter back in), which makes the query re-execute. This does not seem to be optimal.

    Are there any other ways to perform a simple expand/collapse all? Am I simply missing something here?

    Thanks

  • March 4, 2010 at 10:04 am

    #1128597

    Ok, using what I learned off that report … I did my own thing.

    Basically, I made a parameter called “Toggle” with two available values – Collapse / Expand. I then changed the group properties row visibility for each group to show visibility based on an expression, which is: =IIF(Parameters!Toggle.Value="Collapse", True, False)

    In smaller reports, with less parameters, the more ideal look would be to have text/image options on the report, but this worked just fine.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply