Help with Subreports and JAVA Bean connections
I have been writing Jasper reports for some time and do not have a problem
writing main and subreports.
I can write a main report that passes a $P{REPORT_CONNECTION} (JDBC
connection) to subreport1 and they work fine. I can also write a main
report that passes a JAVA Bean to subreport2 and they work fine also.
The issue that that I need to write a main report that passes a JAVA Bean
to subreport2 and then have subreport2 pass a JDBC connection to
subreport1. At this point the main works fine and subreport2 works fine,
but I receive NO data from subreport1. I have attempted to pass a
parameter as a java.sql.Connection to subreport2 that then gets passed as
$P{REPORT_CONNECTION} to subreport1, and also attempted to pass
$P{REPORT_CONNECTION} to subreport2 for it to pass along to subreport1.
But nothing seems to work.
main -> JDBC Connection -> subreport1 --- works fine
main -> JAVA Bean -> subreport2 --- works fine
main -> JAVA Bean -> subreport2 -> JDBC Connection -> subreport1 --- (main
prints data, subreport2 prints data, but subreport1 does NOT print data)
The issue here is that the JAVA Bean retrieves data that will be passed to
subreport1 to generate its portion of the report.
In addition I have also attempted to have a main report call a subreport
(subreport2) using a Java Bean and then have that subreport call another
subreport (subreport3) using a Java Bean and this does not work either.
main -> JAVA Bean -> subreport2 --- works fine
main -> JAVA Bean -> subreport3 --- works fine
main -> JAVA Bean -> subreport2 -> JAVA Bean -> subreport3 --- (main
prints data, subreport2 prints data, but subreport3 does NOT print data.
In addition, I do not believe that the second JAVA Bean is even called
because my trace messages do not get printed that are in the second JAVA
Bean.)
Any help would be appreciated.
Thanks in advance.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
RSS Feed