tmacks Posted January 7, 2013 Share Posted January 7, 2013 Is it possible to have one parent report that accesses an Oracle database and a subreport within that parent report that accesses a PostgreSQL database through some type of connection expression? I can run separate reports in iReport right now that hits both databases, but would like to have a single report. Link to comment Share on other sites More sharing options...
atadu Posted January 10, 2013 Share Posted January 10, 2013 Yes we can connect to different databases with the help of subreport . Connection Expression : Use a datasource expression Link to comment Share on other sites More sharing options...
tmacks Posted January 11, 2013 Author Share Posted January 11, 2013 I was able to get it working by using the "connection" expression com.jaspersoft.ireport.designer.utils.Misc.getConnection("name of my database configured in iReport") in the subReport. Thank you! 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