IIF statement with AND operator

Transact-SQL
1

I'm trying to do a report builder IIF AND expression as shown below but get "error" in the results.

=IIF(Fields!Type.Value = 54 and Fields!Status.Value = 5,"Yes", "No")

Thanks for any help!

2

try

=IIF(Fields!Type.Value = 54, "Yes", IIF(Fields!Type.Value = 5, "Yes", "No"))

better yet if you are getting your data from a sproc or a view do this in those artifacts using case statement

1 Like