WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 482 reviews for our classroom and online training
Problems with Outlining in SSRS 2008 R2
Part three of a four-part series of blogs

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.

  1. Getting SSRS 2008 R2 Outlining to Work
  2. Outlining in SSRS 2008 - Creating a Report
  3. Outlining in SSRS 2008 R2 - Setting ToggleItems (this blog)
  4. Outlining in SSRS 2008 - The Extra Space Problem

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:

Right-clicking on text box at top of report

You can now change the name of this text box:

Changing name of text box

Now select the rows which you want to alternately hide or display:

Selecting multiple rows using mouse pointer

You can now make these rows appear hidden initially:

Setting the ToggleItem property for selected rows

And that, in theory, is that!  Except that this is what you get:

Outlining diagram with spaces where hidden rows should be

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.

This blog has 0 threads Add post