daningaddr Posted December 8, 2012 Share Posted December 8, 2012 We are on 4.7.0 ce In the report, we need to select multple client ids, and pass to stored procedure. I defined "publisher_clients" as a collection for multiselect input control, and another parameter "client_ids" to get string from "publisher_clients" from . client_ids is passed to stored procedure in the . But it does not work, "client_ids" cannot get things selected, it is either empty or just one item. Anything I did wrong? jrxml file is attached Thanks, Daning Link to comment Share on other sites More sharing options...
daningaddr Posted December 8, 2012 Author Share Posted December 8, 2012 Here is the jrxml $P{publisher_clients}.toString() CALL contextlinks3.contextlinks_pub_report_2($P{starting_date},$P{ending_date},$P{client_ids},0,1,1,0,1,0,0,1); Link to comment Share on other sites More sharing options...
cjasper Posted December 8, 2012 Share Posted December 8, 2012 I Don't know the exact solution. I guess you have to cast the publisher_clients to varchar in your input control query.and name="publisher_clients" class="java.util.Collection" nestedType="java.lang.String">. Link to comment Share on other sites More sharing options...
daningaddr Posted December 10, 2012 Author Share Posted December 10, 2012 Thanks a lot. amazing! that worked. but looks something is wrong to deal with integer collection in jasperserver 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