Cascading parameters

• akshaycjoshi

  Valued Member

  Points: 66

  More actions

  February 16, 2010 at 4:31 am

  #230051

  The hierarchy is like this

  Country

  State

  City

  Now there is one query with a where clause like

  SELECT .... FROM CitiPlaces WHERE CityID=@City

  Notice there is no Country and State filter.

  What I want is that the user selects the country, State(based on the Country just selected) and finally the City.

  Please provide a detailed explaination.

  Assume the name of tables as

  Countries(Country,CountryID),States(State,StateID,CountryID),Cities(City,CityID,StateID)

  Edit:

  Sorry, this is for making a report in Sql Server Reporting Services.

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  February 16, 2010 at 4:33 am

  #1119163

  akshaycjoshi (2/16/2010)

  ---

  Please provide a detailed explaination.

  First you provide a detailed question.

  ---

  
  Clear Sky SQL
  My Blog[/url]

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  February 16, 2010 at 4:57 am

  #1119171

  Heres one option

  http://tinyurl.com/ygosjzr

  ---

  
  Clear Sky SQL
  My Blog[/url]