Exforsys

Home arrow Reviews arrow SQL Server Reporting Services

Report Builder 2.0 - Add Gauges

Author: Packt Publishing     Published on: 10th Jun 2009

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:

Ads

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).

Ads

Observe that the gauge needle is pointing at the values in the Second_column.



 
This tutorial is part of a SQL Server Reporting Services tutorial series. Read it from the beginning and learn yourself.

SQL Server Reporting Services

 

Comments