• Services
    • Roles
    • Business Intelligence
    • Migration, Implementation and Training
  • Blog
    • Archives
  • About
  • Partners
  • Contact

Call us toll free 0800 1800 900

Find us on Map
rt@cpa-it.com
Login

Login
White-Knuckle Consulting White-Knuckle Consulting
  • Services
    • Roles
    • Business Intelligence
    • Migration, Implementation and Training
  • Blog
    • Archives
  • About
  • Partners
  • Contact

Use multi-value parameter as a filter example #1

Sep 2, 2015 | BI |

There are a few ways to filter a dataset used in an SSRS report using a multi-value parameter. One approach is to pass the parameter value to the query used in the dataset to filter the dataset. This approach is explained in another post.

If the SSRS dataset is not based upon a query, but instead a stored procedure, passing the multi-valued parameter to the stored procedure is possible, but more tricky. To accomplish this, please refer to this associated post.

Yet another approach is to return all of the data from the query or stored procedure, but then filter the dataset or table with an SSRS based filter. This would seem straightforward, and it is, but you must reference the multi-valued parameter like the below to get it to work as expected.

Suppose you have a multi valued parameter, @ItemGroup.

  1. Right mouse click on either the dataset or tablix and choose properties.
  2. In the properties dialog box, select filters.
  3. Choose to add a filter.
  4. In the Expression drop down list, select the dataset field for which the multi-valued parameter should apply.
  5. Select “In” from the Operator drop down list.
  6. Type in the Value field the parameter name in brackets preceded by an @ symbol. For example [@ItemGroup].
  7. Press OK

SSRSMultiValueFilter

The dataset or tablix data will now be filtered to the values selected by the user.

Share

Leave a Reply

Your email is safe with us.
Cancel Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Contact Us

Let us know how we can help you, and we will get back to you asap!

Send Message

© 2022 · White-Knuckle Consulting, LLC

  • D365 for Finance and Operations / Dynamics AX consulting – White-Knuckle Consulting
  • About Us
  • Services
  • Blog
  • Contact
Prev Next