mailtojustine Posted December 8, 2015 Share Posted December 8, 2015 I am using MS SQL query to generate Jasper Report. I need to use a multi select parameter for selecting projects. I have a query already for fetching projects and I have created an input control using that querBt when I reied to run the report it is showing the error as "Parameter type not supported in query : ProjectID class java.util.Collection". ProjectID is my parameter. Initially it was of integer type and everything was working fine. Now in order to provide multi select parameter I used collection type and changed the query part.The where condition in query is like this : AND $X{IN, i.id, ProjectID}. Can anyone help me to resolve this problem? 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