Post reply

SSRS Report parameter - cross parameter reference between datasets

  • December 20, 2008 at 2:05 am

    #197623

    I have a scenario which I am not finding any solution. Here goes my scenario.

    My report has got 3 parameters. Each of this parameter is a dropdown list. Out of these 3 parameters, the first parameter is mandatory. Second or Third parameter is mandatory. Which means user has to select first parameter and can either select second or third parameter. Based on first parameter selection, the second and third parameter dropdown list gets populated. But upon selecting second parameter, the third parameter should get filtered or vice versa.

    (It is not cascading the parameter)

    Please throw some light.

  • January 2, 2009 at 5:25 am

    #920196

    The dataset SQL for the third parameter will decide that upon selecting second parameter, the third parameter should get filtered i.e. the SQL for the thrid parameter needs to have a reference of the selected value of the second parameter in it's filter condition (e.g. WHERE clause).

    However, not sure whether vice versa will be possible.

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

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