January 19, 2010 at 12:01 pm
[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]
Thanks [/font]
January 21, 2010 at 10:25 am
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.
January 22, 2010 at 7:05 am
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