koushikroy1989 Posted July 25, 2013 Share Posted July 25, 2013 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 Link to comment Share on other sites More sharing options...
ajinkya_c Posted July 25, 2013 Share Posted July 25, 2013 Hi,Use $X{} syntax in query for multiple values, and set datatype of parameter as java.util.colllection.Thanks,Ajinkya Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now