JulEgner Posted August 17, 2006 Share Posted August 17, 2006 I found out that it is possible to set a connection expression for subreports that does not have to be the connection expression of the main report.But how do i make a new connection expression? I even cannot read the connection expression of the main report because iReport does not let me.Maybe I only need to know the syntax of a Report Connection. I need this Information because this seems a way to have more than one Datasource in a Report. I have to use several Databases and if I do not find a way to do this with iReport, or a simple Way to put everything in one Database, I may be forced to use Crystal Reports. I would prefer to stay using iReport. Link to comment Share on other sites More sharing options...
javydreamercsw Posted August 17, 2006 Share Posted August 17, 2006 I'm with the same problem. I posted a related question some time ago (http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&id=958&catid=9) and still waiting for an answer. Just posting here to make sure to get noticed if some answer arises. Link to comment Share on other sites More sharing options...
JulEgner Posted August 21, 2006 Author Share Posted August 21, 2006 I read that you posted a feature request about this, and that you posted, that you created a subreport from a different datasource than the master report. Please tell me how to do this. Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted August 21, 2006 Share Posted August 21, 2006 Report connection: java.sql.ConnectionReport datasource: net.sf.jasperreports.engine.JRDataSource Giulio Link to comment Share on other sites More sharing options...
javydreamercsw Posted August 21, 2006 Share Posted August 21, 2006 Report connection: java.sql.ConnectionReport datasource: net.sf.jasperreports.engine.JRDataSource Ok those are the classes to be used in each case. An example will be more than welcomed since I have no experience with the report datasource. In the SubReport's Properties/SubReport Connection / Datasource Expression- Use datasource expression it creates a default $P{MyDataource}. I proceeded to create the $P{MyDataource} parameter, but what I write in? WHat's the format? Any example?Post edited by: javydreamercsw, at: 2006/08/21 12:05 Link to comment Share on other sites More sharing options...
Scott Andersen Posted June 14, 2022 Share Posted June 14, 2022 Here is a WIKI article that my provide a possible solution:https://community.jaspersoft.com/wiki/jaspersoft-report-using-two-separate-data-sources 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