Post reply

Mutually exclusive parameters in SSRS 2005 report - Any idea?

  • August 2, 2010 at 11:37 am

    #236130

    Hello,

    I have a requirement where a report will have lot of parameters. There will be few parameters which should be mutually exclusive. What I mean is if I have two parameters say A and B, and if user selects any value from parameter A selection dropdown box then the parameter B selection dropdown box should be greyed out (disabled) and vice versa. Selection from A and B is not allowed.

    Is there any way to achieve this, any workaround if this functionality is not available in SSRS 2005?

    Regards,

    Sachin

  • August 3, 2010 at 12:30 pm

    #1201737

    I am not sure this will help, but the only way I can think of it to link the 2 parameters together.

    In your example make the values for the B parameter dependent upon the selection of A by populating the values of B with the results of a query where A is a filtering criteria. If the parameters are completely independent then I don't think this will work.

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

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