I want to use different datasources for main report and for subreport. As far as I have read this could be configured by specifying Connection Expression / Data Source Expression in the subreport properties. I have tried the following expressions: 1. For connection expression a) java.sql.DriverManager.getConnection("jdbc:mysql://localhost/mydatabase?user=root&password=root") I have recieved the exception: Error evaluating expression Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/mydatabase?user=root&password=root b) it.businesslogic.ireport.util.Misc.getConnection("MySQL") I have recieved the exception: Error evaluating expression Caused by: groovy.lang.MissingPropertyException: No such property: it for class: MainReport2_1261053872640_197936 2. For Data Source expression a) com.jaspersoft.ireport.designer.utils.Misc.getDataSource("MySql") I have got no exceptions though the subreport was not displayed at all b) it.businesslogic.ireport.util.Misc.getJRDataSource("MySQL") I have recieved the exception: Error evaluating expression Caused by: groovy.lang.MissingPropertyException: No such property: it for class: MainReport2_1261058321687_913089 I use iReport 3.6.1, Java: 1.6.0_06; Windows XP. mysql-connector-java-5.1.10-bin.jar is listed in the classpath. Could you please advice?
