I have a report where I want to exclude most of the rows based upon a field value. That part is not so hard. The value that I am filtering out is "OK". so in the end the report only displays rows that contain warnings. Typically only one or two rows out of 50-60.
I have been using the expression:
=IIF(Fields!ALERT_VALUE.Value = "OK", True, False) for the row.
Now we get to the tricky part. If there are no warnings then I just get an empty report. What I want to do is display a message that indicates that there are no warnings.
So, I created a new row and set this expression in the first column:
=IIF(Count(Fields!ALERT_VALUE.Value,"DataSet1")=0,"No Commitment Warnings", nothing)
And set visibility as:
But I get nothing.
I think I read somewhere that I an just hiding the rows and not removing them from the report so I guess that my message row is still seeing the hidden rows and that is whey it does not work.
But I swear I had it working this morning LOL!
So, is there a way to get what I am trying to do? Hide all the no warning rows and if there are no warning rows, show the message?