title: Conditional DropDown List with SSRS
body: <p>I created a SSRS report with a dropdown to parameterize data being reported.  This works fine.  I now need to add another parameter to filter the report a little further.  For example, I have a location dropdown that shows area, country, region, etc.  I need to add another dropdown that is dependant on the first dropdown.  So if I select "country" in the 1st dropdown, I show the list of countries in the 2nd dropdown or if I select Region - I show list of Regions in the 2nd dropdown.  Country, Area, Region data is stored in different tables.  So basically my query needs to be smart enough to run the appropriate sql based on 1st dropdown selection.</p>
  
  <p>Thanks so much for any assistance given.</p>