SSRS report does not work with multiple parameters My data set has the following where clause:

WHERE a11.PDPOID LIKE '%' + @POID + '%'


My parameter @POID properties are set to single value.  The report works, but if I change the parameter properties to allow multiple values then I get an error:  


  Query execution failed for dataset 'DataSetDtRcvd'. incorrect syntax near ','.
You could achieve this by changing your dataset query to an expression and use the Join operator on the multi-valued parameter, for example, your expression would look like

= "Select * " &amp;
  "from table t " &amp;
  "where a11.PDPOID LIKE '%" &amp; Join(Parameters!TestParm.Label, "%' OR a11.PDPOID LIKE 
  '%") &amp; "%'"


Replace the Select * from table t with your query.