"All" parameter in Multiple selection listbox

Hi, 
 
I would to introduce an "All" parameter in a listbox which has the multiple selection allowed. How could I implement this? 
 
I found an example but for non multiple one: 
 
<a class='bbc_url' href='http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=356'>http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=356</a> 
 
Thank you! 
J.

Find more posts tagged with

Comments

joseiru

Does anybody know anything about this? Pleaseeeeee

Thank you!
J.

mwilliams

Hi J,

To do that, you'll have to do some scripting to change the SQL to pass the entire result set when the parameter is left blank.

shahamar

Hi,

One way of doing it if list is not too big is for 'All' entry assign value as "," seperated list of all the values.

Another way if it fits to your requirement is, Assign blank value "" to "All" entry. This means when ever "" is selected don't append the condition for the corresponding field in final SQL query to be used.

It all depends on from where are you getting the list values, how much entries you have in list and how you are using the selected values.

Hope this might help.

Amar

joseiru

And how can I do this?:

"This means when ever "" is selected don't append the condition for the corresponding field in final SQL query to be used."

Thanks a lot by your help.
J.

joseiru

Can anybody explain me more about this, pleaseeeee?

"This means when ever "" is selected don't append the condition for the corresponding field in final SQL query to be used."

Thank you!
J.

rpolunsky

What I've done (and I'll admit it's not elegant) is to create my listbox dataset with a union query, the first element being either "(All)" or "(Any)" depending on how I feel. Then i handle the listbox selections in the beforeOpen() event of the report query dataset, iterating first to see whether All/Any was selected and otherwise iterating to build my IN() clause.

Richard