I've got a report that I'd like to include a multi-value parameter that will filter the dataset using multiple LIKE values. I've created the parameter called 'Year' and ticked the box 'Allow Multiple Values' and added a default list of years of '2016', '2015', and '2014'. The source table should be queried with these values on the column YEARS_STATUS which can contain values such as:
Therefore if the report user selects 2014 and 2015 I want the report to return all possible values similar to SQL using the LIKE operator,
I need this coded into an expression within the report level, not the SQL. So far I've gone into teh Dataset Properties pane and gone to Filters to try to Add one. I selected Expression of '[YEARS_STATUS]' with the Operator 'In' and the Value of '[@Year.IsMultiValue]', however I am getting the error "Cannot compare data of types System.string and System.boolean".
Can anyone advise how to correctly create a multi value LIKE expression?