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.
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 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):
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!
Here we have set:
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:
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:
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:
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:
First select the range, then right-click to change its properties as shown here.
For the example above, we have used the following properties:
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.