Can you filter a Report Builder dataset or tablix with multiple values from a multi-value parameter?

[Anonymous]

I've seen a few posts about this, such as this one, but so far can't find any solution. I need to pass the values from multi-value parameters to datasets and/or tablix in Report Builder, but nothing works for multiple parameters. I read that the join function, combined with an "in" clause, built into a filter will work, but I can't get it to work. I can print that expression and it shows the multiple values, but the report comes back blank. It works fine when only one option is selected.

Is this a defect, or is there a way to do it?

[Anonymous]

If you created a multi-value parameter and want to use it to filter data as search condition, then please refer to the following steps per Wendy Fu of TechNet Community Support:

1. In design surface, right-click Datasets and click Add Dataset to create a dataset for the parameter.
2. Right-click Parameters and click Add Parameter in Report Data pane.
3. In Report Parameter Properties dialog box, set name and prompt to KPI_Name, check Allow multiple values check box.
4. Click Available Values in left pane, select Get values from a query, then select Dataset, Value field and Label field from drop down list.
5. Click OK.
6. Right-click dataset you used to retrieve data for the report to open Dataset Properties dialog box.
7. Click Filters in left pane, In Expression drop down list, select =Fields! KPI_Name.Value, set Operator to In. In Value text box, type the expression: [@KPI_Name], then click OK.

For more information about Adding a multi-value parameter to a Report, please refer to the following document:
http://msdn.microsoft.com/en-us/library/dn385719(v=sql.110).aspx

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

As tested, it seems to be a limitation currently.

You could submit an idea here.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.