title: SSRS 2012: Cannot add multi value parameter '?' for dataset XYZ because it is not supported by the data extension
body: <p>Scenario:  I am working with a Firebird database (somewhat similar to MySQL) connected to Microsoft SSRS 2012 via ODBC connection manager.</p>
  
  <p>I have a huge stored procedure (which I am not supposed to modify at all) given by our client. The stored procedure has a parameter - Parameter X filtering Column X (integer datatype); when I pass values to  Parameter X - say 1,2,3,4... individually, I am able to run the report correctly in SSRS.</p>
  
  <p>However, when I try to pass a string of values - (1,2,3,4...)  - i.e. (by checking) 'Allow multiple values' for this Parameter X (text datatype) in SSRS Report Parameter Properties box, I get this error -</p>
  
  <blockquote>
    <p>'Cannot add multi value parameter '?' for dataset XYZ because it is
    not supported by the data extension.   (XYZ is the main dataset for this report)</p>
  </blockquote>
  
  <p>The values 1,2,3 are passed as input from <em>another dataset (PQR).</em></p>
  
  <p>How can I pass multiple input values (1,2,3,...) to Parameter X from this PQR dataset ?</p>
  
  <h2>As I have mentioned, I cannot modify the PSQL Firebird stored procedure (main dataset XYZ) at all. The procedure reads something like this for filtering Column_X:</h2>
  
  <pre><code>WHERE       :Parameter_X    CONTAINING   Column_X 
  </code></pre>
  
  <hr>
  
  <p>Now   if :Parameter_X = 1 or 2 or 3 individually passed from dataset PQR, SSRS report works fine.</p>
  
  <p>If          :Parameter_X = (1 ,2, 3, ....) multi values passed from dataset PQR, SSRS report throws the above error.</p>
  
  <p>I can modify the dataset PQR, but not the main dataset XYZ.   </p>
  
  <p>Any suggestions ?</p>