Warn on JasperReports Server if parameter and control doesn't match

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

Hi!

I have Jasper Report created via Jasper Studio 6.12.2.
In this report there is a parameter "CompaniesIDs" of type java.util.Collection and it's used in SQL queryString like this: AND $X{IN, company, CompaniesIDs}
Report produces correct SQL and executes fine in Jasper Sudio.
Report is published on JasperReports Server. To use the parameter a Control of type Multi-select Query was created. The "Parameter Name" of control is "Companies".

Yes, I know the "Parameter Name" must match  the name of the parameter in my report.

The report has been run manually via web-panel.
The built sql from query log contains "0 = 0" instead of "AND company IN (11,22,33)".
What I was expecting is that JasperReports Server web-app gives some error message and will not let execute the report at all.

So the question is if is it possible to tune Server to get Fatal Errors in such cases but not only silently start execution.

Any suggestions appreciated.

Kind regards.

JasperReports Server:
Product Version: 7.8.1
Build: 20210726_1127

web_13's picture
2
Joined: Aug 8 2018 - 12:06am
Last seen: 2 months 5 days ago

0 Answers:

No answers yet
Feedback
randomness