COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Free Tutorial in Indicators in SSRS 2008 R2
Part three of a four-part series of blogs

Indicators are one of the nicest new features of SSRS 2008 R2 (or SQL Server Reporting Services, to give the software its full name). This blog shows how to add indicators to a table, format them and set scaling correctly.

  1. Indicators in SQL Server in Reporting Services
  2. Creating Indicators
  3. Scaling of Indicators in Reporting Services (this blog)
  4. Formatting Indicators (Gauge Panels)

Posted by Andy Brown on 25 July 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.

Scaling of Indicators

If you've followed the previous parts of this blog, you'll have an indicator which isn't showing the right pictures.  This is because we need to change the indicator's scaling:

Changing an indicator properties

Right-click on the indicator itself (and not the box containing it) and choose to change its properties.


The first thing you'll see is the dialog box shown below:

Dialog box showing default scaling

When you click on the Values and States tab, this is what we see initially.

You now need to change the following things:

  1. Change the measurement units from Percentage to Numeric.
  2. Delete the second and fourth icon (since we only want to divide the films into 3 bands, not 5).
  3. Change the Start and End values for each of the remaining 3 indicators to divide the films up into 0-120 minutes, 120-180 minutes and 180+ minutes.
  4. Change the star colours from the wishy-washy yellow to an easier-to-see brown.
The steps to follow to change indicator behaviour

See above for the numbered steps

The effect of these changes should be as follows:

Indicators with reset scaling

We could do now with making the indicators bigger and making some other formatting changes.


As a final step, we'll format the indicators to look a bit better!

Note that if you have a grouped table and are using Percentage scaling, you can set the Synchronization scope to scale over a group, rather than over the entire report.

This blog has 0 threads Add post