title: SSRS 2012 - Sending multiple values in parameter to main dataset
body: <p>I have a report that is up and running but I need to restrict the data on a parameter that takes multiple string-valued staff codes.</p>
  
  <ol>
  <li><p>I created a parameter called <strong>Practioner</strong> which is a text type, ticked on <strong>Allow Multiple values</strong> and also on <strong>Visible</strong>.</p></li>
  <li><p>In the <strong>available values</strong>, I made this code come from the field called <strong>mbillaty</strong> from the dataset3 under the <strong>Get values from a query</strong> option. I've checked data3 is fine in SQL server.</p></li>
  </ol>
  
  <p>3.Now, I've gone to my dataset1 where all the reporting data sits then put the parameter, with the name <strong>?</strong> and <strong>=Join(Parameters!Practitioner.Value,", ")</strong> for the parameter value. Then in the query, in the where clause, I've put:     <strong>......mbility in (?)</strong>
  What should this SSRS be interpreting as is : <strong>.......mbility in ('AAB','KKR','RDR')</strong>, if the user picked these three staffs.</p>
  
  <p>When I run the report, it definitley works when I check one of the practioners, but as soon as I more than one, the report wouldn't run. It does not return any error, but just the header shows, which I think means that no data is found.</p>
  
  <p>Experts, do you see where I've gone wrong with this?</p>
  
  <p>Thanks</p>