To enable social distancing we've completely remodelled our classroom training, launched a full range of live online courses and now provide online training-cum-consultancy.
Free tutorial - Gauges in SSRS Reporting Services
Part five of a six-part series of blogs

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.

  1. Free Tutorial on Reporting Services Gauges in SSRS
  2. Creating Gauges
  3. Gauge Layout and Positioning in Reporting Services
  4. The Pointer, Scale and Range
  5. Gauge Labels in Reporting Services (this blog)
  6. 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:

Example of gauge labels

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:

Menu to add label to gauge

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:

Label added to gauge

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:

Label Properties menu

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:

Label properties dialog box

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:

Choosing the label Text property

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:

Expression for label

The formula gives the length of a film as (eg) 120 minutes.

Note that a gauge can have more than one label.

This blog has 0 threads Add post