title: Show/Hide Parameter Values based on Selected Value of another Parameter. Possible?
body: <p>I'm trying to find out whether it is possible to engineer a SSRS report where the array of selectable values for a Parameter changes depending on the selected value(s) of another parameter.</p>
  
  <p>Let's say I have the following two parameters :</p>
  
  <pre><code>House : (multi-select parameter with the below selectable values)
  [x] Auckland
  [ ] Christchurch
  
  Furniture : (multiselect also, with a list of furniture within those houses)
  [ ] AKL-TABLE
  [ ] AKL-CHAIR
  </code></pre>
  
  <p>I want to know how to achieve showing/hiding values that belong to a collection tied to each house, in a SSRS report.</p>
  
  <p>If it is not impossible, what extra tables will I need to enable this? If it is impossible within the frame of SSRS, I will give up on it.</p>