IIF statement with AND operator

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!


=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