one parameter value depends on other parameter

• rshm35

  SSC-Addicted

  Points: 496

  More actions

  July 2, 2010 at 8:20 am

  #222792

  I have a report showing the data regarding the regions and countys in a state

  In the parameters I should enter both region and county,these should be in drop down

  when I enter a region value then countys in that spacific region should appear in the drop down.

  Help me!

  Thanks

• Dan.Humphries

  SSChampion

  Points: 12125

  More actions

  July 2, 2010 at 10:31 am

  #1188343

  basically you need to create multiple datasets. So lets use the following example:

  Start with the highest level. this will be a parameter that populates from the dateset.

  Lets call this state. this will list from a defined dataset the states available to choose from.

  Then you would define a parameter with a link to another dataset.

  the second dataset would use the parameter from the first.

  so lets say the second level is city. the dataset would have a query like

  select * from city where state=@state

  this would the populate the list of citys. based on what state is selected.

  Dan

  If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.