SSRS IIF Expression Question

Question

=IIF((Fields!Description.Value Like "*Youth") and (Fields!Value.Value = "Yes"), (Fields!Description.Value Like "*Youth"))

I'm trying to attempt to look for anything in the description *Youth and the value needs to equal YES so if those two meet up to be correct then display the correct name in the description field. if that makes any sense. I'm wondering if the IIF field is the correct expression that I need to do. or is there something else that I can do to write this correctly.

Thanks Suguha

Answer 1

Cool that works, this is the part of the job that I can't stand is right in SQL reports. This is not my expertise.

Answer 2

Hi @Suguha ，

As your described, the IIF Expression could meet your requirement.

=IIF((Fields!Description.Value Like "*Youth" and Fields!Value.Value = "Yes",Fields!Name.Value,nothing)  

You may replace 'nothing' with the value you want.

expression-examples-report-builder-and-ssrs

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October