Multiple select values for parameter in Ireport 4.0.1

[swathi.reddys2008]

Hi...

 I am presenty working on Ireport 4.0.1 version. Here am trying to create a parameter which should take input multiple values. After searching on google i got this solution.

Main Query :  
SELECT * from customer where $X{IN,customer_id,param_customerID}

Parameter : 
Name : param_customerID
Class : java.lang.Integer

Parameter Query in the repository : 
Type : Multi Select Query
Query :
SELECT DISTINCT 
        customer_id FROM customer 
ORDER BY customer_id

 

    Here my question is where can I set Multe Select Query in Ireport 4.0.1. Please anyone help me. Its urjent.

Waiting for solution

 

Thanks in Advance

[AnnMary.Thomas]

I had a similar case. The query I have specified in the same way as you have specified. But the Parameter i have specified in the following way.

Parameter Name=parameter1

Class=java.util.Collection

Default Value Expression=java.util.Arrays.asList($P{REPORT_PARAMETERS_MAP}.get( "parameter1" ))