Toggling reporting groups - expanding/hiding all

[Dan777]

In some of my reports, groups and items are intitally hidden, with a toggle (+ -) next to it so users can expand just what they want to look at. Of course, some users just want to expand everything and print it out. When a report has dozens of groups, it's a pretty tedious task to click each plus sign.

What I'd like to do is have a button on the interactive report like "Expand All", for when some groups are still hidden, then change to "Collapse All" when all groups are expanded.

Is that possible? I'm using SQL Reporting Services 2005.

Thanks Much!

 

[checkai]

Unsure if that is possible, however you could have a Parameter that would prompt Expand All? and then conditionally expand or collapse all of the levels.

 

[xlbo]

Not possible in the report

Parameter is the way to go

=iif(parameters!ParamName.value = "Visible" , FALSE, TRUE)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Dan777]

Guess that'll work. Thanks guys!