title: How to assign one same label for multiple value in non-queried available values in ssrs 2005 report?
body: <p>Parameters - Multiple Values For One Label - Possible?</p>
  
  <p>Sorry my modified Question.....</p>
  
  <p>I have question to ask,...
  Is it possible to have multiple values for ONE label in non-queried available values in SSRS 2005? i want to join fields value in a single row like,</p>
  
  <pre><code>Works: (But this bring a long list in drop down menu - which i donot want)
  
  Label                Value
  ---------------------------
  Site-1                 150
  Site-1                 151 
  Site-2                 152
  Site-2                 153
  
  
  Required result (Which i want - in one line)
  
  Label                Value
  ---------------------------
  Site-1                 150,151
  Site-2                 152,153
  (which will bring one label and related multi-value in drop down or combo box.
  But the problem is that ColumnName IN (@Site) does not work with multi-value.)
  </code></pre>
  
  <p>More description of the problem:</p>
  
  <p>Let say, I have a field/column </p>
  
  <pre><code> Name = Site
   Value = C150,C151, C152, C153
  </code></pre>
  
  <p>I want drop down menu on report with </p>
  
  <pre><code> C150,C151(as Site-1) &amp; C152,C153(as Site-2)
  </code></pre>
  
  <p>So I created parameter i.e. @getSite and set values as 
  multi-value in the report as</p>
  
  <pre><code> Label                       Value
   ---------------------------------------------
   Site-1                      (150,151)
   Site-2                      (152,153)
  </code></pre>
  
  <p>And set my parameter as <code>@getSite:= Parameters!@getSite.Value</code>
  And Query i wrote as,</p>
  
  <pre><code>SELECT  * FROM ..
  WHERE Site IN (@getDisease)
  </code></pre>
  
  <p>But after all these, my report result is empty,literally no result. 
  It seems like if i select only one value as Site-1 = 150, then it works 
  but not two or more values in one line, 
  why it is not possible?? if yes then how?</p>
  
  <p>Please help!!!</p>