title: Howto make SSRS report parameters depend on each other
body: <p>My report has two dropdown list -<br>
  1) List one shows all fruit-sellers<br>
  2) List two shows all fruits</p>
  
  <p>If user selects one seller, I want the second list to show only those fruits sold by selected seller.<br>
  If the user select a fruit, I would want to show list of only those sellers selling the fruit (this will effectively override the selected seller in the list)</p>
  
  <p>From whatever I have found, ssrs report does not allow forward dependency. I can only make one of these parameters dependent. How do I achieve two-way dependency**??**</p>
  
  <p>PS: I have third parameter also which is price range - if user selects a price range, I would want only those fruits &amp; sellers which fall in that price range but if I can figure out above problem, I should be able to fix this as well.</p>