Set a Snapping Interval on a Gauge (Report Builder and SSRS)

A snapping interval defines the multiple to which values are rounded. By default, the gauge will point to the exact value of the field you have specified in the data pane. However, you may want to round the exact value up or down so that the pointer will snap to a preset interval. For example, if the value on your gauge is 34.2 and you specify a snapping interval of 5, the gauge pointer will point to 35. If the value on your gauge is 31.2 and you specify a snapping interval of 5, the gauge pointer will point to 30.

Note

You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.

To set a snapping interval on a gauge

Click anywhere on the numbers of the gauge to highlight the scale.

Open the Properties pane.

Note

If you do not see the Properties pane, click the View tab and then select the Properties checkbox.

In the Pointers property, click the (…) button. The Pointer Collection Editor opens.

Set the SnappingEnabled property to True.

Set the SnappingInterval to a value that represents the snapping interval. The pointer will be snapped to the nearest round multiple of the value that you have specified.