Include Indicators and Gauges in a Gauge Panel (Report Builder and SSRS)
The gauge panel is the top-level container that holds one or more gauges and indicators. Indicators can be embedded in gauges or placed next to them in the gauge panel.
If the indicator and gauge are adjacent in the gauge panel and show data from different fields, you might want to add labels to make it clear what data the gauge and indicator convey.
Gauge and indicator options can be set by using expressions. For more information, see Expressions (Report Builder and SSRS).
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 embed an indicator in a gauge
Open an existing report or create a new report that contains a table and matrix with the data you want to display. For more information, see Tables (Report Builder and SSRS) or Matrices (Report Builder and SSRS).
Insert a column in your table or matrix. For more information, see Insert or Delete a Column (Report Builder and SSRS).
On the Insert tab, in the Data Regions group, click Gauge, and then, and then click a cell in the new column. The Select Gauge Type dialog box appears.
Click Radial. The first radial gauge is selected.
Click OK.
Click the gauge. The Gauge Data pane opens.
In the Values area, in the (Unspecified) list box, click the field whose values you want to display in the gauge. Alternatively, drag the field to use from the report dataset.
Right-click the gauge, click Add Indicator, and then click Child. The Select Indicator Style dialog box opens.
In the Select Indicator Style dialog box, in the left pane, click the indicator type you want, and then click the indicator set.
Click OK.
Click the indicator. The Gauge Data pane opens.
In the Values area, in the (Unspecified) list box, click the field whose values you want to display as an indicator. Alternatively, drag the field to use from the report dataset.
The field can be the same or a different field from the one you use in the gauge.
Click OK.
To show an indicator and gauge side by side
Open an existing report or create a new report that contains a table and matrix with the data you want to display. For more information, see Tables (Report Builder and SSRS) or Matrices (Report Builder and SSRS).
Insert a column in your table or matrix. For more information, see Insert or Delete a Column (Report Builder and SSRS).
On the Insert tab, in the Data Regions group, click Gauge, and then click a cell in the column you inserted. The Select Gauge Type dialog appears.
Click Radial. The first radial gauge is selected.
Click OK.
Click the gauge. The Gauge Data pane opens.
In the Values area, in the (Unspecified) list box, click the field whose values you want to display in the gauge. Alternatively, drag the field to use from the report dataset.
Right-click the gauge, click Add Indicator, and then click Adjacent. The Select Indicator Style dialog box opens.
In the Select Indicator Style dialog box, in the left pane, click the indicator type you want, and then click the indicator set.
Click OK.
Click the indicator. The Gauge Data pane opens.
In the Values area, in the (Unspecified) list box, click the field whose values you want to display as an indicator. Alternatively, drag the field to use from the report dataset.
The field can be the same or a different field from the one you use in the gauge.
Click OK.
Right-click the gauge panel and click Add Label. A label is added to the gauge panel. Repeat one more time.
The gauge panel has two labels.
Drag each label to a location near the gauge or indicator.
Right-click the label near the gauge, click Label Properties,and type the text you want in the Text box.
Right-click the label near the indicator, click Label Properties,and type the text you want in the Text box.
Click OK.