How to display values in dropdown2 (Report parameter) based on dropdown1 selected value.

  • Hi All,

    I have two dropdown boxes as input parameters.

    1 - dbname

    2 - Name

    If i choose the dbname from dropdown1,dropdown2(name should display all values corresponding to dbname (dropdown1)).. Can anyone help me on this??

    Thanks in Advance...

  • follow this

    1. Define 1st dataset

    2. Map it in available values to create a drop down 1 with dataset 1.

    3. create 2nd dataset with a sql input parameter.

    4. in Dataset map map the sql input parameter with the first drop down output

    5. Map it in available values to create a drop down 2.

    hope this helps

    Regards
    Durai Nagarajan

  • It will be great if you provide an example...

  • Can anyone help me on this?

  • Hello,

    Kindly check the attachments for the flow.

    Regards
    Durai Nagarajan

Viewing 5 posts - 1 through 4 (of 4 total)

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