CODEWITHSUNDEEP
reporting-servicesiif
B-Rad
B-Rad

Reputation: 1567

Nested SSRS IIF should work (I think) but doesn't

I believe this code should work but I keep getting #Error

=IIF(Fields!MonthMiddleDates8.Value <> "", "TRUE",
     IIF(Fields!MonthMiddleDates9.Value <> "", "TRUE", "FALSE"))

Upvotes: 1

Views: 23

Answers (1)

B-Rad
B-Rad

Reputation: 1567

Instead of using '<> "" ' use 'is nothing'. Works great now!

Upvotes: 1

Related Questions