Search code examples
sql-server-2008ssrs-2008reporting-services

hiding rows that contain no values

I would like to hide rows in my report that contain no values in a certain set of fields.

This question is helpful

How to filter rows with null values in any of its columns in SSRS

i do not understand how to check whether multiple fields are null.

currently, i am doing this:

enter image description here

and under the visibility:

enter image description here

and i typed this expression:

=iif(fields!Jan.Value
+fields!Feb.Value
+fields!Mar.Value
+fields!April.Value
+fields!May.Value
+fields!June.Value
+fields!July.Value
+Fields!Aug.Value
+Fields!Sept.Value
+Fields!Oct.Value
+Fields!Nov.Value
+Fields!Dec.Value="",TRUE,FALSE)

but i am getting this error:

enter image description here

how do i hide a row if the values are null or blank?

Solution

  • I know this solution may not be the best, but it works:

    =iif(fields!Jan.Value
    +fields!Feb.Value
    +fields!Mar.Value
    +fields!April.Value
    +fields!May.Value
    +fields!June.Value
    +fields!July.Value
    +Fields!Aug.Value
    +Fields!Sept.Value
    +Fields!Oct.Value
    +Fields!Nov.Value
    +Fields!Dec.Value=0,TRUE,FALSE)

    I realized since the fields are all int, i can just add them together and check whether they add up to 0.