Select All in Multi Select

[umair]

While creating a Control in a report:

 

I created an Input Control with the Type "Multi-Select Query".

Now, i can see the values listed as multiple select options.

But how can i adjust this control so i can have an option to 'Select All'.

Right now, i can select all options, individually.

But i need one option as 'Select All' among other options.

How would i achieve that ?

[mdahlman]

Hi umair,

 

Generally you can achieve the effect that you are describing by selecting nothing in the multi-select input control. Ctrl-click to unselect any existing value.

 

Then the $X{} syntax correctly resolves to the trivial clause "0=0" and queries on all values.

 

This isn't exactly what you requested, but in many cases it gives the desired result. If explicit support for the choice of ALL seems important, please log an enhancement request.

 

Regards,

Matt

[vpremkumar]

Hi Matt ,

 

Were you able to achieve 'Select All' option in 3.7 jasper server?

 

Will appreciate any inputs

 

Thanks,

Vandana

[ramnik]

1. We have option -> Select All available as part of Dynamic Filter in adhoc editor [ 3.7 Pro feature]

2. With Multi-select query input control , the option to select All is not available in 3.7 [ as per my knowledge ]

Ramnik Kaur

Senior QA Engineer

[scottn]

The way we do it for all input controls is by adding an "All" option to the input control query, i.e.:

 

SELECT "All" AS `DISPLAY_NAME`

UNION

SELECT DISPLAY_NAME FROM TABLE

 

That then makes the first option always "All". Then to handle that in the report, we use something like this:

 

($X{IN,'All', parameter_mlist} OR $X{IN,DISPLAY_NAME,parameter_mlist})

 

So basically the logic will accept everything if "All" is selected because it short circuits the logic before it gets to the second check where it actually looks at the column in the database.