Pro SQL Server 2012 Reporting Services

CHAPTER 5  IMPLEMENTING DASHBOARD STYLE REPORT OBJECTS

Figure 5-19. Data Bar: Series Properties fill options

Once you have the expression editor open, enter the following expression and click OK:

=IIF(Parameters!ServiceMonth.Label <> "ALL",IIF(Fields!Visit_Count_By_State.Value > 75,
"Green", "Red"),IIF(Fields!Visit_Count_By_State.Value > 300, "Green", "Red"))

As shown in this expression, you can nest your conditional statements. Here we are checking to see
if the parameter label selected was not ALL. Then it checks for the Visit_Count_By_State to see if it is
more than 75 for the month selected. If it is, then make the Data Bar green and if not, make it red. The
outer IIF statement checks to see if the count is greater than 300 and sets the colors accordingly. Click
Preview to see your report in action, as shown in Figure 5-20.