BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
SQL Server Reporting Services 2008 introduced gauges, in all their dazzling compexity. This free tutorial blog shows how to create gauges, format their pointers and scales, add labels and much else besides.
- Free Tutorial on Reporting Services Gauges in SSRS
- Creating Gauges
- Gauge Layout and Positioning in Reporting Services
- The Pointer, Scale and Range
- Gauge Labels in Reporting Services (this blog)
- Other Ideas for Gauges in Reporting Services
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.
Gauge Labels
You can add labels to gauges, as shown below, to make them look better:

Here each labels shows in text form what the gauge is measuring
There are two parts to adding labels: getting them to display the correct thing, and - more challengingly - getting them to appear in the right place!
Adding Labels
To add a label to a gauge, just right-click on it:

Right-click on a gauge and choose the menu option shown to add a label to it.
Changing the Position of Labels
The label will appear in the middle of the gauge. You can change its position either by clicking on it and dragging it, or by setting its properties:

You can drag a label around, or right-click on it to change its properties.
For our example, you can position the label by first changing its properties:

Right-click on a label to show its properties, as here.
You can then tell SSRS where the label should appear, relative to the gauge it sits in:

Here the label will appear 5% of the height of the gauge down from the top of it, and 20% of the width of the gauge in from the left. By setting the width of the label to 60% of the width of the gauge, it will appear centre justified on the gauge horizontally.
Changing the Text on Labels
You can use the Text: property shown above to get the label to show the item being measured:

Click on the function icon shown to change the text displayed on a label
You can then use the expression builder in the usual way to display the length of each film on the label:

The formula gives the length of a film as (eg) 120 minutes.
Note that a gauge can have more than one label.
- Free Tutorial on Reporting Services Gauges in SSRS
- Creating Gauges
- Gauge Layout and Positioning in Reporting Services
- The Pointer, Scale and Range
- Gauge Labels in Reporting Services (this blog)
- Other Ideas for Gauges in Reporting Services