Hi, I am building a report with a subreport in it. I need the subreport to connect to another datasource then the main report. I got this working with a connection expression: java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname", "username", "password") The problem is we have different environments (development, testing, production) where the report has to be used and the database name and address is different for each environment. I want to use the datasource expression to solve this problem. This way we can add datasources on each envorinment and let the report point to this datasource instead of using a different connection expression on each environment. I tried the following exporessions, which didn't work: it.businesslogic.ireport.util.Misc.getConnection("repo:/datasource_name") it.businesslogic.ireport.util.Misc.getJRDataSource("datasource_name") net.sf.jasperreports.engine.JRDataSource("datasource_name") "repo:datasource_name" Does anyone know how to do this?
