'How to use SSRS multiselect parameter to filter a multiselect data field?
I have a scenario where we have a multiselect field in our Dynamics CRM database and I need to create an SSRS report wiht a multiselect parameter that will pull any records that have any of the individual parameters chose in the SSRS report. So SSR parameter would use an OR clause to filter for any results that have any of the individual multiselect elements.
For example: SSRS multiselect parameter
| SSRS PARAMETER- MULTI SELECT |
|---|
| Apple |
| Banana |
| Orange |
| Mango |
A Dataset that looks like | Meal# | food| |:---- |:------:| |1 | Apple, Banana | |2 | Banana | |3 | Mango |
So if user selects Apple and Banana for the parameter, the result should be any meal that has either Apple OR Banana
| Meal# | food |
|---|---|
| 1 | Apple, Banana |
| 2 | Banana |
So if user selects Just Banana for the parameter, the result should be any meal that has banana
| Meal# | food |
|---|---|
| 1 | Apple, Banana |
| 2 | Banana |
I'm not sure how to implement this, I only have access to the SSRS report, I cannot access SQL db directly.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
