default value for a parameter

[pioppogatto]

Hi, I have a report with two java.util.Collection parameters and my report query is like that in the Code.

In the report unit under jasperserver there are two input controls, pMacro is mandatory and pCategoria is not mandatory, but pCategoria get the report having all the values of the parameter if I didn't choose any value in the input control. How can I set the default value to gat ANY value? I try to put "" but I have an error

com.jaspersoft.jasperserver.api.JSExceptionWrapper: Errors were encountered when compiling report expressions class file: 1. Cannot cast from String to Collection value = (java.util.Collection)(""); //$JR_EXPR_ID=1$ <------------------------> 2. Cannot cast from String to Collection value = (java.util.Collection)(""); //$JR_EXPR_ID=1$ <------------------------> 3. Cannot cast from String to Collection value = (java.util.Collection)(""); //$JR_EXPR_ID=1$ <------------------------> 3 errors

 

Thank you

Code:

SELECT * FROMstatisticwhere  $X{IN, macrocategoria, pMacro} OR $X{IN, categoria, pCategoria}

[ADR707]

When you use " " as the default value, jasper server expects the parameter to be of the type String.

But as per your explanation, you are using parameter of collection type; hence try using [" "] instead of  " "