Hi
I am facing problem with passing parameter to the jasper...
I need to pass the list of values to the jasper report for that query is
(select * from sample where $P{sample_id})
and i am passing the parameter as [sample_id like 2 or sample_id like 3]
from the jsp but while passing the parameter to the jasper report it is appending with the coates and i am not getting the result..
the constructed query is like this..
Code:
select * from sample where sample_id like 2 or sample_id like 3
Please tell me how do i need to pass the parameter to the jasper in order to achieve the result
Thankyou.