Expression for Row Visibility when FALSE is “” or NOTHING? (SSRS)

0
votes

I have the following expression in a cell:

=IIF(last(Fields!OpenedEmail.Value) >= (DateAdd(DateInterval.Day, -30, Parameters!end_date.Value)), last(Fields!OpenedEmail.Value), "")

I’m having problems figuring out what expression I need to put into the Row Visibility to get the row to disappear if "" or NOTHING is used for FALSE. I’ve tried combinations of IIF, SWITCH, and ISNOTHING but no dice.

Thoughts?

1
reporting-services

1 Answers

0
votes

If you want to hide the row when the expression is blank, you would put the TRUE to hide the row where you currently have the blank:

=IIF(last(Fields!OpenedEmail.Value) >= (DateAdd(DateInterval.Day, -30, Parameters!end_date.Value)), False, True)