Filter Tablix with LIKE and OR

Question

With SSRS, I need to filter a tablix with a LIKE and an OR condition. For example:

WHERE MedCampaign LIKE AffCPD_1224* OR MedCampaign LIKE AffCPD_1225*

I tried the below suggestion I found, but this just returns the entire dataset. How should I go about this?

Also tried this suggestion:

Expression: iff(InStr(Fields!MedCampaign.Value, "AffCPD_1224") > 0 or InStr(Fields!MedCampaign.Value, "AffCPD_1225") > 0,1,0)

0

Again, returns ALL values.

Answer 1

Hi @Dom

I did a simple test and here is my source data.

Then I used this expression in Tablix filter:

=IIF(Fields!MedCampaign.Value like "AffCPD_1224*" OR Fields!MedCampaign.Value like "AffCPD_1225*",1,0)

Result:

Hope this helps you.

If the answer is useful, please click Accept Answer to let others with similar questions quickly find answers. If you have any questions, please feel free to let me know.

Best regards

Aniya