Reviews
SQL Server Reporting ServicesReport Builder 2.0 - Add Gauges
Add gauges to display the data
Gauges 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.
SQL Server Reporting Services
- Leaning SQL Server 2008 Reporting Services
- Working with the Report Builder
- Report Builder 2.0 - User Interface Description
- Report Builder 2.0 - Data Regions
- Report Builder 2.0 - Matrix
- Report Builder 2.0 - List
- Report Builder 2.0 - Chart
- Report Builder 2.0 - Gauge
- Report Builder 2.0 - Subreports
- Report Builder 2.0 - Report Designer
- Report Builder 2.0 - Report Designer Pane
- Report Builder 2.0 - Server Status and Tools
- Report Builder 2.0 - Modifying a Basic Report
- Report Builder 2.0 - Imported MS Access Report
- Report Builder 2.0 - Creating Reports with Charts and Gauges
- Report Builder 2.0 - Create a Datasource
- Report Builder 2.0 - Dataset Based on Excel File
- Report Builder 2.0 - Format a Column
- Report Builder 2.0 - Create a Chart
- Report Builder 2.0 - Add Gauges
- Report Builder 2.0 - Add a Report Item
- Report Builder 2.0 - Add a Gauge to Display Average
- Report Builder 2.0 - Create a Bookmark







