WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 525 reviews for our classroom and online training
Problems with Outlining in SSRS 2008 R2
Part two 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 (this blog)
  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.

Outlining in SSRS 2008 - Creating a Report

The first thing to do when creating an outlined report in Reporting Services 2008 is to create a normal report.  Here's the example we'll use:

Example of report in SSRS

Our example report

The shaded box at the top contains our group header.  In this case the expression this contains is:

The group header expression

The expression shows the value of each film certificate, using UK film certificate values

Without any extra outlining effects, this is what you should see when you preview this report:

Previewed report - vanilla version

The basic report, before we apply any outlining

Time now to apply some outlining!


This blog has 0 threads Add post