title: SSRS: Can I know if user selected "ALL" in multivalued param?
body: <p>Customer wants me to repeat the parameter values in the page header of the report. But if they just choose "Select All" on a multi-valued parameter, they want the text "Any" listed.</p>
  
  <p>For example, one parameter has a fixed set of 9 values. I hard-coded the expression for a text box to:</p>
  
  <pre><code>="Room Size: " &amp;
  iif(Parameters!pRoomCap.Count=9,
      "Any",
      Join(Parameters!pRoomCap.Value, ", "))
  </code></pre>
  
  <p>How can I do this if the parameter source is a query of unknown size?</p>