Single select querry

[javi_123]

Hi all,

When you add the input control and specify the type as single select query, it does populate all the results in the drop down but if you don't select any value from the drop down list it will display all the results when a user clicks ok. Is it possible to hard code the dropdown to show "All" in the drop down list, so that the user will know that they hav selected all of the results?

Cheers

javi

 

[rodonell]

I'm having the opposite problem, when you don't click on something in the drop-box box it doesn't display anything.  How did you structure your WHERE statement and parameter to get that to happen? Thanks.

[gabrielinux]

I usually do a UNION in my query... something like this:

SELECT '%' AS Value, '  All  ' AS Label

UNION ALL

SELECT MachineName AS Value, MachineName AS Label FROM NC_Workstation

 

Then, in your report query, you would use LIKE:

SELECT *

FROM NC_Workstation

WHERE MachineName LIKE $P{InputMachineName}

 

This blog post has some examples:   http://blog-gabriel.mongefranco.com/2008/07/csv-and-wildcard-searches-in.html