writing if condition for Multi Value Selection

hello all,

below is my requirement.

i've a paramater (say Mul_param)which gets populated by the user id passed through the URL .it is a mutli value parameter.
the default value for this paramter is 'ALL'.

say, if the user has access to department 1,2,3 then only those 3 depts will be there in my list box;along with these 'ALL' will be the first one to select.

if the user selects ALL he should be able to see all the 3 depts data.
if he selects 1,2 only those 2 depts data should be shown.
i'm able to hadle selecting multiple values from the drop down but my only concern is with the ALL value.
i'm unable to handle it.

can anyone please help me out in getting this solved.

Thanks,
Sailaja.k

Find more posts tagged with

Comments

mwilliams

Hi Sailaja.k,

You should be able to solve this by editing your query in the beforeOpen script of the dataSet to have no where statement if 'all' is selected. You can do this by setting up a simple query in your dataSet to start with and adding the where clause only if 'all' is not selected. Or you could set the query up as the full complex query in the dataSet and if 'all' is selected, you replace the query text with the simple query that gets all departments. Let me know if you have any questions.

Hope this helps.