andrew.brooks_1 Posted December 28, 2018 Share Posted December 28, 2018 Good afternoonI have a report with a parameter that is a java.util.Collection that runs fine in Jaspersoft Studio.These is to go into the where clause of my SQL query.I have uploaded the report to Jasperserver but am unable to test as it want's me to search and select values isntead of typing in manually.When trying to run the report through the REST API, I can add the parameter to the URL, but it doesn't seem to get passed to the report, and the report tries to run without the where clause and all my data is returned.Any ideas why this might be?Cheers Link to comment Share on other sites More sharing options...
andrew.brooks_1 Posted January 2, 2019 Author Share Posted January 2, 2019 Update to this.I now have this partially working through the API, the only issue is that it will only work if I'm passing more than one value into the collection parameter.I can workaround this by adding an extra blank value to the query (see example below):localhost:8080/jasperserver-pro/rest_v2/reports/reports/test_5.pdf?jobs=18-39222&jobs= Has anyone else experienced this, and found a fix? RegardsAndrew Link to comment Share on other sites More sharing options...
vinothm2k Posted January 21, 2019 Share Posted January 21, 2019 yes this is the only way for Jasper Report 7.1 there is no proper documentation/api method details Link to comment Share on other sites More sharing options...
florian.weihl Posted August 12, 2021 Share Posted August 12, 2021 I know this is a pretty old problem, but I'm currently facing the same problem with Jaseper Version 7.8.0.Even if I pass multiple values to my collection it wont work and resolves in an error.Can anybody help? I've already created an articel ( https://community.jaspersoft.com/questions/1186721/report-parameter-list) 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