Post reply

Parameter Dependency

  • September 8, 2009 at 7:38 pm

    #204356

    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.

  • September 10, 2009 at 4:47 am

    #1051648

    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

  • September 16, 2009 at 2:40 pm

    #1054716

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply