Pro SQL Server 2012 Reporting Services

CHAPTER 6  BUILDING REPORTS

Next, click the Pointer Fill tab. Click the Expression button to the right of the secondary color, enter the
following expression, and click OK:

=IIF(Sum(Fields!Visit_Count.Value) / CountDistinct(DAY(Fields!ChargeServiceStartDate.Value) &
YEAR(Fields!ChargeServiceStartDate.Value)) < Variables!Threshold.Value, "Red", "Green")

The final view of the report in Figure 6-41 has the parameter value for ServiceYear of 2009 and 2010
selected. You can see that the threshold has been met for the year and month values selected. The
completed report with all the final touches can be seen in the Pro_SSRS project is called
EmployeeServiceCost_Variables.rdl.

Figure 6-41. Final view of the report with the gauge control