Button to expand all in SSRS Report?

dkim18 used Ask the Experts™

I have a SSRS 2005 report with two Groupings, one department and one agegroup.

Initially, I see the department group and when I click department, it shows age group then I click the agegroup it shows the detail, employee names.

I want to create a button on top of the report and when I click this, I want to expand all groups.

Is it possible??
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Database Architect
Try to do your expand all by setting the toggle item to a level above the
parent group, or perhaps to the label at the top of the table.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial