WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 520 reviews for our classroom and online training
Problems with Outlining in SSRS 2008 R2
Part one 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 (this blog)
  2. Outlining in SSRS 2008 - Creating a Report
  3. Outlining in SSRS 2008 R2 - Setting ToggleItems
  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.

Getting SSRS 2008 R2 Outlining to Work

In theory it should be fairly simple to create outlining in Reporting Services 2008 R2.  Initially you should see just the group headings:

Report with all sections collapsed

Initially all groups are collapsed

When you click on one of the + icons, SSRS should show the full section:

Report with expanded sections

Programming nirvana! But how to get this to work?

The answer is much harder than it should be!  You'll need to create a report, apply outlining and then change the report's static items, as described in the rest of this blog series of articles.

This blog has 0 threads Add post