Post reply

SSRS-Report parameters

  • September 8, 2009 at 2:47 pm

    #135313

    I 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...?

    Thanks in advance.

  • September 8, 2009 at 6:01 pm

    #1050852

    This post should really be in the SSRS forums.

    Nevertheless, yes, this is supported in SSRS 2005 and 2008 (not sure about earlier versions). 2 terms this sort of thing is known by are "dependent parameters" or "cascading parameters".

    Google those terms and you will get some useful info. Here are a few links that may help

    http://forums.asp.net/p/1062358/1528660.aspx#1528660

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

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

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