Jump to content
Changes to the Jaspersoft community edition download ×

problems with Creating subreports with MS SQL


2005 IR Help

Recommended Posts

By: Shammi Hettiarachchi - shammif2

problems with Creating subreports with MS SQL

2005-12-11 12:05

HEllo people

 

i'm an IT student & currently working in a project

when i create two seperate reports and compile and Run it's ok.

but i cannot link those reports together through subreport tool. when i run the master report it shows only the master report content only.

i've used the option "use connection expression" in sub report.then whole report gets an error saying

resulset busy htsmt... and so on bla.. bla...

when i placed the sub report element in summery section it's ok & doesn't give above error.

How can i build a 100% working sub report with IReport 0.5.2.

 

Pleae help me, i've followed all the tutorials and found no answer.

if someone can send me some screenshots i'll be greatful. -shammif2@yahoo.com

 

this is the error codes....

--------------------------------------

 

 

 

 

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 net.sf.jasperreports.engine.fill.JRFillDataset.createDataSource(JRFillDataset.java:675) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:704) at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:444) 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 net.sf.jasperreports.engine.fill.JRFillDataset.createDataSource(JRFillDataset.java:675) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:704) at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:444) at java.lang.Thread.run(Thread.java:534) NESTED BY : net.sf.jasperreports.engine.JRException: Error executing SQL statement for report : sub_report at net.sf.jasperreports.engine.fill.JRFillDataset.createDataSource(JRFillDataset.java:683) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:704) at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:444) 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 net.sf.jasperreports.engine.fill.JRFillDataset.createDataSource(JRFillDataset.java:675) ... 3 more 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 net.sf.jasperreports.engine.fill.JRFillDataset.createDataSource(JRFillDataset.java:675) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:704) at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:444) at java.lang.Thread.run(Thread.java:534) NESTED BY : net.sf.jasperreports.engine.JRException: Error executing SQL statement for report : sub_report at net.sf.jasperreports.engine.fill.JRFillDataset.createDataSource(JRFillDataset.java:683) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:704) at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:444) 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 net.sf.jasperreports.engine.fill.JRFillDataset.createDataSource(JRFillDataset.java:675) ... 3 more NESTED BY : net.sf.jasperreports.engine.JRRuntimeException: Error executing SQL statement for report : sub_report at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:569) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:271) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:311) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:279) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1254) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:589) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:229) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:127) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:834) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:705) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:654) at java.lang.Thread.run(Thread.java:534) Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for report : sub_report at net.sf.jasperreports.engine.fill.JRFillDataset.createDataSource(JRFillDataset.java:683) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:704) at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:444) ... 1 more 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 net.sf.jasperreports.engine.fill.JRFillDataset.createDataSource(JRFillDataset.java:675) ... 3 more

Print not filled. Try to use an EmptyDataSource...!

Link to comment
Share on other sites

  • 1 year later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...