Hello
Would someone please assist me in solving below issue:
On my SSRS 2008 report, I have a CheckList parameter that pulls the Distinct Year values from a dataset. I would like to Filter my other datasets based on the selected multivalued parameter, e.g. say the selection was 2002, 2005, 2008
I've completed my Dataset Filter as follows:
Expression: [Year]
Operator: In
Value: =Parameters!Year.Value
The datasets only return the FIRST selected year, thus 2002. Then I've tried to change the Value to: =Join(Parameters!Year.Value,",")
but it errors on datatype mismatching, e.g. integer vs string.
Is there a way around this?
Thanks.
Louis