Multi-select query

[pavithram]

Im tring to filter records by giving IN cluase in the select statement.  

 

Report main query is given below:

 

select v.br_code,v.br_name,v.br_admin_unit

from branch v

where br_admin_unit=$X{IN, br_admin_unit, br_admin_unit}

 

I have define the input control where user can select the branch admin unit. parameter name is defined as 'br_admin_unit'  java.util.Collection.

though the report is generated records are not filtered in the report. 

 

pls provide some solution. 

[ajinkya_c]

 

Try this Query

------------------

select v.br_code,v.br_name,v.br_admin_unit

from branch v

where $X{IN, br_admin_unit, br_admin_unit}

[marianol]

ajinkya_c has a good point use the query he added in the comment.

The $X{..} funtion has to be used as:

$X{IN, field_name, parameter_name} 

Jasper will take care of creating the correct SQL syntax. 

[pavithram]

Yes Its working. Thanks for the support.

[marianol]

You are welcome.