Search code examples
nulljasper-reportsireportjasperserver

How to give condition for null values of multi select parameter in Ireport?

I am developing a report using iReport where I want to add a condition for null values. It's working with single select option as:

(city=$P{p_city} or $P{p_city} is null)

It means here if we do not pass any value for the city parameter, the report will work, but this is not working in case of a multiselect option. We have to choose a "Collection" value expression in iReport when we create a parameter:

($X{IN, country,p_country} or $P{p_country} is null)

I have created two input controls in JasperReports Server to run this report. One is a single select, "Select City" and the other is a multi select, "Select country", and the report is running without passing a value for the "Select city" parameter, but for the "select country" parameter, we must pass the value, because "Select country" is multi select and a Collection type parameter and you can not add null condition in a query as for the city parameter.

How we can modify the JRXML query?

Solution

  • The $X feature handles this automatically. In your case you have this in your query:

    $X{IN, country, p_country}

    That gets converted to 1 = 1 in the case where your Collection is null. So there is no reason to add $P{p_country} is null into the query.