title: Fill a drop-down list parameter with specific available values
body: <p>I have an SSRS report that creates report from a SQL table:</p>
  
  
  
  <pre class="lang-none prettyprint-override"><code> id  type    name
   1   fruit   wilk
   2   fruit   scot
   3   paper   jon
   4   pen     brad
   5   tape    lin
   6   water   james
  </code></pre>
  
  <p>The report has two data sets: one feeds query for report, and the other feeds data to parameter. So in the report the multi-value parameter gets its values from dataset2.</p>
  
  <pre class="lang-sql prettyprint-override"><code>-- dataset1::  
  select ID, TYPE, name from table1 where type in (@types)
  
  -- dataset2::
  select TYPE from table1
  </code></pre>
  
  <p>The report is generated based on type selected from dropdown list (which is a multi select list).</p>
  
  <p>For example if we select "fruit" the report displays:</p>
  
  <blockquote>
    <p>wilk, scot</p>
  </blockquote>
  
  <p>If we select "water":</p>
  
  <blockquote>
    <p>james</p>
  </blockquote>
  
  <p>Now the thing is that I need to create a name for all the values "TAPE", "pen", and "paper", say the name "STATIONARY", such that the dropdown list should show only:</p>
  
  <blockquote>
    <p>fruit, stationary, water</p>
  </blockquote>
  
  <p>And when I select "STATIONARY" from thedropdown list the report should display:</p>
  
  <blockquote>
    <p>jon, brad, lin (all 3 have some form of stationary, i.e paper, pen, tape)</p>
  </blockquote>
  
  <p>And when I select type as "STATIONARY" and "water" it should display:</p>
  
  <blockquote>
    <p>jon, brad, lin, james</p>
  </blockquote>