maiolif Posted September 7, 2018 Share Posted September 7, 2018 Hello, sorry for my "stupid" question.In a report I put a clauseWHERE $X{ IN ,res_partner.id,IDS}[/code]The report is working well.when in preview, in jaspersoft Studio, I need to pass the parameter collection IDS to the report, but I always get this errornet.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: Invalid type java.lang.String for parameter IDS used in an IN clause; the value must be an array or a collection.I tried several ways to pass the list of IDS, but without success:[1,2]1,2"1,2""[1,2]""{1,2}"and many other... Help! Link to comment Share on other sites More sharing options...
Raphaël Peguet Posted January 23 Share Posted January 23 Try setting the parameter like this: Parameter: Name: IDS Class: java.util.Collection Default Value Expression: new ArrayList(Arrays.asList(1,2)) 1 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