Tutorials Reporting ServicesIn this section you will add a single gauge in the same column as the others but outside the group, and set its value to represent the group average of the second column:
1. Click Insert | Gauge and drop it on the intersection of the last row. This row is outside the group and the column containing the gauge from the previous section.
The Select Gauge Type gets displayed.
2. Select the default Linear type (the first one).
The linear type gauge gets added to the report.
3. From the dataset, click on Second_ to add it to the gauge as shown:
4. Now the Linear Pointer gets the value [Sum (Second_)].
5. Right-click the Linear Pointer and choose to review the Pointer Properties...;. The Linear Pointer Properties window gets displayed as shown:
6. Click fx to open the Expression window and alter the value displayed to the following.
=Avg(Fields!Second_.Value)
7. Close the Expression window and close the Linear Pointer Properties window.
8. Run the report from Home | Run.
The report gets displayed as shown (only the relevant part is shown):
The linear gauge now displays the same average value as seen in the above screenshot. There is a row and a textbox that do not have any data shown in the above (row above and the textbox to the right of the average) and these may be prevented from showing up by using the hide property.
