camnott
-
Posts
25 -
Joined
-
Last visited
Community Answers
-
camnott's post in How can I hide the jrxml code from showing in errors? was marked as the answer
Actually found my own way to get around this. Added new parameters p_connection p_user p_password and changed the expression to
java.sql.DriverManager.getConnection($P{p_connection},$P{p_user},$P{p_password})
Works perfectly.
-
camnott's post in Sub Query "EXCEPT" Clause not working was marked as the answer
Found the issue....
WHERE $X{IN, SRP.cop_report_date, TIME_PERIOD}
So.... I had this parameter as a collection. Got rid of this, and created two new parameters. Period Start and Period End, Changed line to
WHERE SRP.cop_report_date BETWEEN $P{PERIOD_START} AND $P{PERIOD_END}
Works like a charm. I guess I should have done it this way originally. Was just trying to make it easier.
-
camnott's post in Issue with Parameter was marked as the answer
So - This is a foolish mistake I made. Thank you for your answer Mariano, but I figured out what I was doing wrong.
When I was trying to pass parameters down to the sub report, I apparently mapped this parameter to the report by mistake, instead of passing it down.
When it tried to call the report, it was trying to map the parameter, throwing the error.
