I am new to report writing and am trying to suppress rows that have zero data. I need to know how to write the conditional iif statement when I have multiple columns of data. Example

account number account description fy 2012 fy 2013 fy 2014 fy 2015

some accounts have zero numbers across the years and I don't want that row to show.

1 Answer 1


Here's how you hide How to: Hide an Item (Reporting Services)

Here's the expression

=IIF( Fields!yourField1.Value = 0  and Fields!yourField2.Value = 0 
  and Fields!yourField3.Value = 0  , True, False )

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.