I am newbie to the report designer. I am using SQL BI Development Studio 2008 R2 to design my report. I had created the dataset to query the result I wanted to show in the report except one thing. I could not figure how to use multivalue parameter to filter
the result based on the selected value the user choose. Below is the example of the query for the dataset.
SELECT * FROM myTable1 WHERE myFilter IN (@myParameter)
@myParameter can be any set of these: ('Value1','Value2','Value3','Value4') or ('ValueA','ValueB','ValueC') or ('ValueW','Value5','Value7')
If I set the @myParameter parameter to only have a single value for each label under Available Values, the report would execute just fine. So, my question is how do go about write each label to contain a set of the values I want in the expression
field. I tried to use concatenation and that didn't work.
Thank you in advance.
View Complete Post