Tutorials Reporting ServicesGauges add visual features to enhance the aesthetic appearance as discussed earlier. However, whether gauges are more appealing than just data is a matter open for discussion. We will see how to add gauges here:
1. Click on the report to display the report handles. Right-click the last column and from the drop-down menu that gets displayed click on
Insert Column | Right.
This inserts an extra column on the right.
2. Click on Insert | Gauge and click on the Data cell of the new column you created.
The Select Gauge Type gets displayed.
3. Accept the default that shows up and click on the OK button. A gauge gets placed in the cell as shown:
The vertical side was extended to improve the display.
4. Double-click the gauge to display its configurable features as shown:
Let us say that this Gauge should represent the data in the second column of our report table.
5. Drag Second_ from Report Data and drop it on the location Drop Data fields here.
Alternatively you may also choose the drop-down from the data list icon that appears in that textbox when you hover over it.
6. Click on Home | Run to process and display the report.
The report gets displayed as shown (only part of it shown).
Observe that the gauge needle is pointing at the values in the Second_column.
