Parameter Dependency

  • 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.

  • 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

  • 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