iancr01 Wrote: You can also use: select ... where $X{IN, colname, parameter name} "parameter name" is a parameter of type Collection or array. Hi, Today I was trying to use parameter in where clause such as-- select emp_salary,last_name from employees where emp_id in ($p{id1},$p{id2}) but i m getting error so how to figure out this problem plz help me Is it possible to do such a thing with iReport and JasperReport ?