Post reply

Help needed with parameter selection based on another parameter

  • March 24, 2009 at 8:31 am

    #198343

    Hi,

    I want to do the following... My main sproc takes 4 Parameters A,b,c,d where is A and B is going to be a list type and c and d are date time...

    IF the User Selects A, then you should not have the ability to select the B variable.

    If the user Select B, then you should not have the ability to select the A variable.

    How can i achieve this using SSRS..

    I have tried to have another variable called AB which will be boolean and if AB is true then i can show Variable A else

    show Variable B. But i am not sure how conditionally do things for parameters..

    any help will be appreicated

    Thanks,

    Karen

  • March 26, 2009 at 1:37 pm

    #967010

    Well, you can't choose to make a parameter hidden/visible based on an expression. What you can do, though, is have a single-select list parameter (AB), with the following items:

    Label: "Use List A" Value "A"

    Label: "Use List B" Value "B"

    Then, list A and B would both use parameter AB in this fashion:

    --For List A

    If @ab = "A"

    SELECT * FROM ListATable

    Else

    SELECT 'NA' [Label], -1 [Value]

    Cheers!

    John

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

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