Free tutorial - Gauges in SSRS Reporting Services
Part four 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 (this blog)
  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.

The Pointer, Scale and Range

A gauge contains 3 main parts:

The parts of a gauge

The 3 main parts of a gauge:

 

The rest of this page shows how you can make changes to each part of the gauge.

Changing the Scale

The easiest way to change the scale is to select it (using your left mouse button), then right-click on it (with the right mouse button):

Menu to change scale properties

Selecting the scale is the hard bit; once you've done this, it's easy to change its properties.

 

You now have a ridiculous level of control!

Dialog box showing gauge scale properties

Here we have set:

 
The final scale in our report

Scales often look better with only major tick marks, not minor, as here.

 

Changing the Pointer

You can change the properties of a gauge pointer by first clicking on it with the left mouse button to select it, then right-clicking on it:

Menu to change pointer properties

Click on the pointer first to select it, then right-click on it to display its properties.

 

Here are some example settings for the pointer properties: 

Pointer properties dialog box

Here we've chosen that the pointer should appear outside the scale, but that its distance from the scale should be 0% (it it should touch the scale).

The result of the properties shown above is a pointer which looks like this:

Final pointer in report

The pointer touches the scale but is outside it (we've also set the tick marks to be entirely inside the scale, and changed the colour of the pointer to green).

 

You can set the pointer shape to be a diamond, trapezoid or even pentagon.  A touch of overkill?

Changing the Range

As for the scale and pointer, you can change the properties of the range by first selecting it, then right-clicking on it:

The range properties menu

First select the range, then right-click to change its properties as shown here.

 

For the example above, we have used the following properties:

Range properties dialog box

Here the range goes from 180 minutes to 240 minutes, and appears inside the scale. We've also changed the colour to green using the Fill tab (not shown here).

Having set the scale, pointer and range, you might now consider adding labels to your gauge.

This blog has 0 threads Add post