How can we pass multiple values in a single parameter in iReport ?

[ajinkya_c]

Hi,

Use java.util.collection as datatype for parameter and use it with $X{In, column name, parameter name} in your sql query.

So that you can able to provide multiple values to parameter in iReport. Provide (,) comma separated multiple values to input control.

Hope this helps.

Thanks

Ajinkya

[vkumar_1]

Hey Ajinka,thanks for help but we want to do it through SQL query.

[bchandrasekarsamiyathal]

Ajinkya,

 

I tried the same format $X{In, column name, parameter name}. It threw me error like the parameter does not exist. Any ideas why?

 

Is there no way to modify any property of the parameter to achieve multi value prompt?

 

Thanks

 

 

[merugu.srinivas]

Create a dynamic Parameter like ($P{STUDY_CODE}) then change the parameter in Ur SQL Query

($P!{STUDY_CODE}).Which means add Exclamation Mark after $P.

 

Example :

select * from customer where customer_id in($P!{customer_id})

[merugu.srinivas]

Create a dynamic Parameter like  ($P{STUDY_CODE})  then change the parameter in Ur SQL Query
($P!{STUDY_CODE}). Which means add Exclamation Mark after  $P.

Example :
select  *  from  customer  where customer_id in ($P!{customer_id})