How to pass multi values for a place holder as iReport input Parameter

[koushikroy1989]

Hi,

I have a query which looks like - 

Select tab_id, tab_name from table where tab_id in ('1', '2', '3')[/code]

I do not understand how can I pass these Comma Separated Values to the report as input...

I have tried with this, but it doesn't work -

select tab_id, tab_name from table where tab_id in ($P{IP_TAB_ID})[/code]

.... and then passing the CSVs as input to

[ajinkya_c]

Hi,

Use $X{} syntax in query for multiple values, and set datatype of parameter as java.util.colllection.

Thanks,

Ajinkya