Wednesday, March 7, 2012

Expand/Collapse all in drilldown report

Good morning folks,

I have created a drilldown report with two groups which when run displays the information in it's collapsed state.

Is there a way to add a button to expand all expandable rows in the report so that all information within both groups is displayed without having to expand each row one by one?

I have seen a couple of posts on the subject but when I follow the advice given it only seems to affect the Toggle Image - I still get the report in its collapsed state but the toggle image is displayed as - instead of +.

Thanks,

CPH

You can create a report parameter (bool) which indicates the toggle state. Now you can set your visibility depending on the toggle state and also the initial image state (option below the visibility option)|||

Thanks for your help JP, much appreciated.

For anyone else struggling with expand/toggle all there's a bit more clarification available in this thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=600583&SiteId=1

Failing that, drop me a line and I'll explain how I made it work in one of my reports.

Later dudes and dudettes,

CPH

No comments:

Post a Comment