Single select input control with "All" option

[snehalata_d]

Hello,

 

I want to create a report in JasperServer with input control which has 'All' option.

I have created a report in iReport with two parameters-shipcountry1 and All
The shipcountry parameter is of type String and All parameter is of type Boolean.
My report query is "Select ..from.. where shipcountry=$P{shipcountry1} or $P{All}=1 "
This report is working fine in iReport but after deploying it on JasperServer it is giving empty report when I select 'All' from the single select drop down list.
I don't know how to link this 'All' label in drop down list  to 'All parameter'

Post Edited by snehalata_d at 07/27/2010 03:45

[mespub]

Hi,

 

you can change the All parameter to String and give it the value 'All'.

You can then use it in the Query like this :

where shipcountry=$P{shipcountry1} or $P{All}='All'

 

Regards

[snehalata_d]

Hi mespub,

Thanks for your reply.My report is working in iReport using your method.
But it is giving me the same error when I deploy it on JasperServer.(i.e. empty report when 'All' is selected from the drop down).
Please can you give me some hints on how to deploy this report on JasperServer???
I want to use single drop down list with 'All' option in it.

Regards,
Snehalata
 

[snehalata_d]

Please if anyone knows the way to achieve it then please help me.

Regards,

Snehalata

 

[mespub]

did you create the input control in the report unit as a string ?