BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
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.
- Indicators in SQL Server in Reporting Services
- Creating Indicators
- Scaling of Indicators in Reporting Services
- 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:
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:
Right-click on an indicator and choose the option shown to change the gauge panel
You can then set - for example - the fill colour:
Here we are changing the background colour for the indicator's gauge panel to a bright - and regrettable - yellow
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.
- Indicators in SQL Server in Reporting Services
- Creating Indicators
- Scaling of Indicators in Reporting Services
- Formatting Indicators (Gauge Panels) (this blog)