[Settings required for generating large reports]

 Is it possible to make this work for a report that has subqueries (i.e. a table) or a subreport?  When it goes to execute the other query, I get this exception:

 

java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@51a9bf1f is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:934)	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)	at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2735)	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1899)	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)	at com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1606)	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2213)