title: SSRS - Concatenate Multiple Parameter Values in a Text Box
body: <p>I have an SSRS report with several parameters the user selects at runtime.  One of the parameters allows multi-select.  I'm using the values to populate a text box and am having a problem using the parameter values when multiples are selected.  Below is when the user selects one value and this works:</p>
  <pre><code>=Switch(Parameters!ID.Value(0) = 5, &quot;Location 1&quot;, Parameters!ID.Value(0) = 9, &quot;Location 2&quot;) &amp; &quot; Status Report&quot;
  </code></pre>
  <p>I have another case, though.  Since it's multi-select, if the parameter carries values of 5 and 9, I want to have have it say &quot;Location 1 and Location 2&quot; &amp; &quot; Status Report&quot;</p>
  <p>I'm not sure how to accomplish that.</p>
  <p>I tried:</p>
  <pre><code>=Switch(Parameters!ID.Value(0) = 5, &quot;Location 1&quot;, Parameters!ID.Value(0) = 9, &quot;Location 2&quot;, **Parameters!ID.Value(0) = 5 AndAlso Parameters!ID.Value(0) = 9, &quot;Location 1 and Location 2&quot;**) &amp; &quot; Status Report&quot;
  </code></pre>
  <p>Thoughts?</p>