BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Outlining grouped data in Reporting Services 2008 should be straightforward: you just set the ToggleItem property of rows, and away you go! Unfortunately this owl can't get this to work - along with a lot of other people it seems - so we offer this solution.
Posted by Andy Brown on 17 May 2011
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Outlining in SSRS 2008 R2 - Setting ToggleItems
To get our outlining to work in our report (see previous step of this blog), we need to set the ToggleItem for selected rows in the report. The first thing is to find out what the toggle item is named. To do this, show the relevant text box's properties:
You can now change the name of this text box:
Now select the rows which you want to alternately hide or display:
You can now make these rows appear hidden initially:
And that, in theory, is that! Except that this is what you get:
Those spaces shouldn't be there!
To get round this you need to display the report's static items and change their properties - which really shouldn't be necessary - as described in this last part of this blog series.