Free Tutorial in Indicators in SSRS 2008 R2
Part four 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
  4. Formatting Indicators (Gauge Panels) (this blog)

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.

Formatting Indicators (Gauge Panels)

To understand how indicators work, you need to know that they sit on top of gauge panels:

Indicator and its gauge panel

Here:

 

The reason it's called a gauge panel and not an indicator panel is that an indicator in SSRS is actually a specific instance of the more general gauge (although whether this helps or not is a moot point).

To change the fill colour (for example) of the gauge panel on which an indicator sits:

Changing gauge panel properties

Right-click on an indicator and choose the option shown to change the gauge panel

You can then set - for example - the fill colour:

Changing gauge panel fill colour

Here we are changing the background colour for the indicator's gauge panel to a bright - and regrettable - yellow

 
The finished report

That's it! After setting borders and colours, you should have something similar to the following:

 

If you liked indicators, you might like also to read our blog on gauges in SSRS.

 

  1. Indicators in SQL Server in Reporting Services
  2. Creating Indicators
  3. Scaling of Indicators in Reporting Services
  4. Formatting Indicators (Gauge Panels) (this blog)
This blog has 0 threads Add post