WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 519 reviews for our classroom and online training
Free tutorial - Gauges in SSRS Reporting Services
Part two 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 (this blog)
  3. Gauge Layout and Positioning in Reporting Services
  4. The Pointer, Scale and Range
  5. Gauge Labels in Reporting Services
  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.

Creating Gauges

The first thing to think about when creating a gauge is which type you want!

Types of Gauge: Radial and Linear

There are two types of gauge:

  • Radial gauges look like old-fashioned car speedometers; while
  • Linear gauges look like old-fashioned weighing-scale read-outs.
Radial gauge Linear gauge
Radial gauge example Example of linear gauge

 Creating a Gauge

To create a gauge, drag the relevant control into a report:

Dragging gauge onto report

Click on the Gauge report item and drag it onto your report.

You can now choose the type of gauge you want:

Choosing the type of gauge

For our example, we'll use the first type of linear gauge (although we'll subsequently make lots of amendments to it).


 Assigning Data to a Gauge 

Having created a gauge, you need to tell SSRS what it is measuring:

Assigning field to gauge

Click on the gauge, then choose which field it should represent.

You now have a gauge which doesn't look that impressive:

The gauge we start with

Initially, the scaling set means that we can't see anything

 Changing Gauge Scaling 

To get the gauge to measure the length of each film meaningfully, we need to change the scaling:

How to change scaling for gauge

To change the default scaling of a gauge:


You can now fill in options to tell SSRS how to scale film lengths:

Dialog box for gauge scaling

Here we've chosen to show a scale from 60 to 240 minutes, with 60 minute intervals.

The result is a gauge which finally shows something meaningful:

Report with scaling set

The gauge actually measures what it was supposed to now

The next step is to size and position the gauge and its contents, but to do this we need to learn a bit about gauge measurements. 

This blog has 0 threads Add post