drallpradeep Posted June 17, 2009 Share Posted June 17, 2009 how to pass more than one paramter in JasperReport 2.0.5. Actally I would to pass more than one personal no as a paramter like personalno = $P{'232323','3444','4321234'}. Please reply.Regards,Pradeep Link to comment Share on other sites More sharing options...
dnvsrikanth Posted June 17, 2009 Share Posted June 17, 2009 Hi, Declare the parameter as string type and pass the value as comma seperated value and use IN in the query DNV Srikanth. Code: Post Edited by dnvsrikanth at 06/17/2009 06:38 Link to comment Share on other sites More sharing options...
drallpradeep Posted June 19, 2009 Author Share Posted June 19, 2009 Thanks for your reply.I tried your suggestion but could not accept more than one value in parameter. I gone through the tutorial /demo/sample/query and tried like : $X{IN,mess.mad_v_personalno,personalno}syntex - $X{IN, colName, paramName}and declare the parameter class type as java.util.Collection and pass the value in parameter field like : 15576595, 15153306,15565352,14406021which has been resolved my problems.Thanks & regards,Pradeepdrallpradeep@gmail.com Link to comment Share on other sites More sharing options...
dnvsrikanth Posted June 19, 2009 Share Posted June 19, 2009 Hi, Its working in my report... Though I need to check the way you told....Any way Thanks for providing the new way..... 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