How to: Add a Gauge to a Report (Report Builder 2.0)

When you want to summarize data in a visual format, you can use a Gauge data region. After you add a Gauge data region to the design surface, you can drag report dataset fields to a drop zone on the gauge.

To add a gauge to your report

  1. Create a report or open an existing report.

  2. On the Insert tab, double-click Gauge. The Select Gauge Type dialog box opens.

  3. Select the type of gauge you want to add. Click OK.


    Unlike Chart, Gauge has only two gauges types: linear and radial. The available gauges in the Select a Gauge Type dialog box are templates for these two types of gauges. For this reason, you cannot change the gauge type after you add the gauge to your report. You must delete and re-add a gauge to change its type.

    If the report has no data source and dataset the Data Source Properties dialog box opens and takes you through the steps to create both. For more information see, How to: Create a Data Source Reference (Report Builder 2.0).

    If the report has a data source, but no dataset the Dataset Properties dialog box opens and takes you through the steps to create one. For more information, see How to: Create a Dataset (Report Builder 2.0).

  4. Click the gauge to display the drop-zone. By default, a gauge has one pointer corresponding to one value. You can add additional pointers.

  5. Add one field from the dataset to the data field drop-zone.

    Right-click the gauge scale, and select Scale Properties. Type a value for the Minimum and Maximum of the scale. For more information, see How to: Set a Minimum or Maximum on a Gauge (Report Builder 2.0).