title: SSRS Passing multi-select parameter to report
body: <p>I have this report which gets data from a storedprocedure.
  I need to pass CustomerIDs from a multi-select dropdown to my report.</p>
  
  <p>My storedprocedure looks like this :</p>
  
  <pre><code>@CustomerIds varchar(500)
  
  select *
    FROM [Application].[ApplicationVersion] APPVERS 
   WHERE APPVERS.CustomerId IN ( @CustomerIds )
  </code></pre>
  
  <ul>
  <li><p>On my report I have the parameter "CustomerIds", the data type is set to Integer (I tried it with "TEXT" but it didn't work either). The parameter is set to "Allow multiple values"</p></li>
  <li><p>On the report where my dataset is defined, I have the @CustomerIds defined as follows : "=SPLIT(JOIN(Parameters!CustomerIds.Value,","),",") " (I tried it with the SPLIT only, with the JOIN only and it didn't work)</p></li>
  </ul>
  
  <p>Can anyone help me?</p>