title: ssrs multivalue parameter stored procedure
body: <p>I have a report im creating in SSRS (2008) and the data for the report is coming from a stored procedure in MS SQL.</p>
  
  <p>I want to have a multiple value parameter (done this a million time but not with a SP)</p>
  
  <p>I have created the parameter based on a query, ticked the allow multiple values and modified the SP to use the IN statement (so IN (@Param))</p>
  
  <p>It just wont work SQL Server profiler show this being passed</p>
  
  <pre><code>@RC=N'1,2'
  </code></pre>
  
  <p>If I choose one value, it works (returning the one value)</p>
  
  <p>I have seen posts about splitting joining and i've tried all these to no avail. </p>
  
  <p>Any ideas (surely its simple!!) Ideally id like to be able to return NULL too (or is that too much to ask? </p>
  
  <p>Thank you all</p>