Expand/Collapse all buttons in reports

Hello!

We just wonder if there is an easy way to incorporate "expand all-collapse all" options in the reports we chose to drill down.

Starting with a collapsed report is lovely but as the data get more it may be easier for some to see it all expanded.

Thanking you in advance,

Dimitris, Athens, GreeceThe closest you can get is to add a boolean report parameter and use that parameter in expressions to determine the initial state of all your expand/collapse items.

-- Robert|||

For the hopeful benefit of anyone else trying to get the InitialToggleState property to behave properly when setting it via an expression: From a posting by Chris Hays elsewhere, we learn that "The values aren't the strings 'Collapsed' and 'Expanded', they're True and False (Boolean)."

So, the conditional to set the InitialToggleState property won't look like this (for a String input parameter):

=IIF(Parameters!HideDetails.Value = "Yes", "Collapsed", "Expanded")

Rather, do it this way:

=IIF(Parameters!HideDetails.Value = "Yes", True, False)