how to disable multivalue prompt

  • [font="Comic Sans MS"]Hi all,

    I have a criteria to run my report with two different options:

    Run by Selecting Employee Name or Run by selecting Department

    No If I say Employee name it shows me a multivalue text box with all emp names...

    But if I select Department, it shows me again a multivalue textbox with all department names.

    Now the problem is in disabling the other box

    If I select Emp Name the Dept box should be diabled, and I should be allowed to Run my report only by selecting the Empname (same thing applies to Dept select)

    Both the prompts are MULTIVALUE so i cannot ALLOW NULL VALUE in them

    Any help

    Thanks in advance[/font]

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • What I have done in the past is give each box a default of 'ALL' and UNION that with the query that loads the multivalue dropdown so it will appear in the top of the list for the user to see. Then I alter the procedure on the backend to ignore the default of ALL if it is passed in and build dynamic SQL accordingly. In your case, if ALL is passed in for Dept, you would build the query string to only search by Emp.

  • I do something a bit different.

    The first combo box I popuolate with "Elployee", "Dept" and so on....

    in other words "user - how do you want to filter?"

    then based upon what they select I load the 2nd combo with the available values.

    works very well for us.

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

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