Base a filter on a multi select report parameter

I defined a report parameter in which it is possible to select multiple values.
Now I want to use the selected values to filter the data displayed in the report. However, I do not know how to define the filter (note that I do not have a problem using a single value as a filter value).

Any help would be appreciated.

Best regards,

René-Michel Stierhout

Typically this should just work. Simply use e.g. Products.ProductName=@Parameter. This will match all selected product names then.

Are you seeing issues when proceeding this way?

It works! I do not know what I did wrong previously. Maybe I thought before it did not work because it did not report a value when I did not select a value at all in the report parameter.

1 Like