Search code examples
reporting-servicesssrs-2008

SSRS Conditional Formating Where There's NULL

I have a report with the number of attendees by month shown and rows grouped on an "Attended" or "Did Not Attend" Attendance_Indicator flag (this in itself is a sub-group of a higher level of grouping).

For legibility I wanted any row of Attended data with a coloured background (say LightGrey) and any other rows transparent.

I have highlighted the cells within the table at this grouping level and used the expression below:

=IIF(Fields!Attendance_Indicator.Value = "Attended","LightGrey","Transparent")

This partial works in that where the count of attendees is >0 the cells' background colour changes to grey. However, in cells where the count of attendees is 0 the background remains transparent.

Can anyone advise how I can get any cells, whatever the count value, on the Attended row to change background?

Solution

  • IsNothing is your friend here. You may need to fiddle with the logic for your colours (e.g. NOT IsNothing rather than IsNothing)... but you get the idea.

    =IIF(IsNothing(Fields!Attendance_Indicator.Value)  OR Fields!Attendance_Indicator.Value)  = "Attended","LightGrey","Transparent")