2004 IR Help Posted September 2, 2006 Share Posted September 2, 2006 By: ASK - anupinder_singh How to Use SubReport 2004-07-19 22:56 Hi All I am a newbie to iReport. Till the last week, I was using Crystal Report but now I want to use iReport. Here I m facing a problem regarding subreport. I don't know how to use subreport in iReport. In iReport, I found subreport but it's not as it was in Crystal Report. Please tell me how can I use SubReports in iReport. In this regard, any help or exapmle will be appriciated!!!! Thanks Anupinder Singh By: C-Box - c-box RE: How to Use SubReport 2004-07-20 00:46 Just look at the SubReport-Sample that comes with JasperReport-Release (Full download). It's quite easy to understand. Or you look here... http://ireport.sourceforge.net/swf/Subreport_viewlet_swf.htm hth C-Box By: Rick Millar - rmillar RE: How to Use SubReport 2004-07-20 07:50 Make sure to search this forum for help too. Try this thread.... https://sourceforge.net/forum/message.php?msg_id=2639157 By: ASK - anupinder_singh RE: How to Use SubReport 2004-07-20 23:13 I have chked sample and make my master and subreport. Now I can complie my master report and subreport both. Both reports are working fine individualy. Bur when I combine both, although it compiles but while filling Data in report, it gives error. The error message is:: Filling report... Error?filling?print... java.sql.SQLException:?[Microsoft][ODBC?SQL?Server?Driver]Connection?is?busy?with?results?for?another?hstmt ????at?sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) ????at?sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) ????at?sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3150) ????at?sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:214) ????at?sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(JdbcOdbcPreparedStatement.java:89) ????at?dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:466) ????at?dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:413) ????at?java.lang.Thread.run(Thread.java:534) NESTED?BY?: java.sql.SQLException:?[Microsoft][ODBC?SQL?Server?Driver]Connection?is?busy?with?results?for?another?hstmt ????at?sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) ????at?sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) ????at?sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3150) ????at?sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:214) ????at?sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(JdbcOdbcPreparedStatement.java:89) ????at?dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:466) ????at?dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:413) ????at?java.lang.Thread.run(Thread.java:534) NESTED?BY?: dori.jasper.engine.JRException:?Error?executing?SQL?statement?for?report?:?AddressReport ????at?dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:475) ????at?dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:413) ????at?java.lang.Thread.run(Thread.java:534) Caused?by:?java.sql.SQLException:?[Microsoft][ODBC?SQL?Server?Driver]Connection?is?busy?with?results?for?another?hstmt ????at?sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) ????at?sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) ????at?sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3150) ????at?sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:214) ????at?sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(JdbcOdbcPreparedStatement.java:89) ????at?dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:466) ????...?2?more Print?not?filled.?Try?to?use?an?EmptyDataSource...! I must be doing something wrong. Please tell me where I m wrong. Thanks Anupinder Singh 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