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 - 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:
Our example report
The shaded box at the top contains our group header. In this case the expression this contains is:
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:
The basic report, before we apply any outlining
Time now to apply some outlining!