title: SSRS: passing a multivalue parameter to a query
body: <p>I have an SSRS report based on a BigQuery database. the main query uses parameters as arguments and is supposed to accept multiple values for each argument.</p>
  <p>The query has the following structure :</p>
  <pre><code>select 
  field1,field2
  from
  tableName
  where
  field1 in (?)
  </code></pre>
  <p>And the parameter value of the argument ? is :</p>
  <pre><code>=Join(Parameters!P_MyParam.Value,&quot;,&quot;)
  </code></pre>
  <p>When I run the report, the filter works only if one single value of <strong>P_MyParam</strong> is selected. If I select two values for example, no results are displayed (even if each of the two values gives results if used separately).</p>
  <p>When I try the formula:</p>
  <pre><code>=&quot;'&quot; &amp; Join(Parameters!P_MyParam.Value,&quot;','&quot;) &amp; &quot;'&quot;
  </code></pre>
  <p>no results are shown at all (even if one single value of the parameter is selected).</p>
  <p>I tried to use filters instead of parameters but it leads to the error : <strong>System.OutOfMemoryException.</strong></p>
  <p>Is there an efficient way to pass multiple values to a parameter when the used database is BigQuery ?</p>
  <p>Thanks in advance,</p>