Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Parameter Dependency Expand / Collapse
Author
Message
Posted Tuesday, September 08, 2009 7:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 27, 2013 12:01 AM
Points: 8, Visits: 129
have 4 parameters (District,Region,State,Country)in a report. In this If I change the fourth parameter(Country) then the values for the parameters District,Region,State to be change according to the value chosen in the fourth parameter country.

Ex:the country parameter contains the values INDIA,USA,UK,RUSSIA... then If I choose INDIA, then the state should be change to Karnataka, Region=Southern, District=Kolar, like this if I choose USA then the state, Region, District values should be change to the corresponding values..

Is it is possible to Implement this scenario, anybody help me to implememt...?
Thanks in advance.
Post #784673
Posted Thursday, September 10, 2009 4:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 13, 2012 5:18 AM
Points: 37, Visits: 166
Create datasets for each parameter values with each dataset query is filtered with the value from the other parameter value except country.

for eg
create sate dataset with query like
select State from tblState where Country=@Country
@Country is passed from the Parameters!Country.value in dataset properties-Parameters section

goto State param --Available values -->From Query -->[Select state dataSet] -set Value field and LabelField

do the same for District and Region with State and District params respectively


Post #785606
Posted Wednesday, September 16, 2009 2:40 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 9:56 AM
Points: 30, Visits: 306
Looks like you are working with cascading parameters.

The below link tells you in detail how to create them.

http://msdn.microsoft.com/en-us/library/aa337169.aspx


Thanks,
Nemo
Post #789276
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse