Jump to content
Changes to the Jaspersoft community edition download ×

How to do Subreport???

Recommended Posts

By: TesTech - testech

How to do Subreport???

2005-05-30 08:03

I am trying to create subreport through IReport Designer in any version.

I downloaded the video-tutorials from site.Even i am unable to create subreport.

For the SubReport Field in the Parent report,I set the property

"Use connection expression" as


While launching the report,Its throwing the following error :



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:454)     at dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:411)     at java.lang.Thread.run(Thread.java:534)



If i didnt set that property ,then the Parent report itself is launching ,but not the subreport.Please help me to launch the sub report.



By: Giulio Toffoli - gt78

RE: How to do Subreport???

2005-05-31 00:46


Use a native JDBC driver. ODBC/JDBC bridge don't permit more than a Statament per Connection: this is the error you catch.





By: TesTech - testech

RE: How to do Subreport???

2005-05-31 03:30

hi giulio , Thanks for ur reply.

ya i have used,native driver previously.As u said,it doesnt allow me to execute more than one queries.

Now i changed to thin driver.

Its working fine when i used different query in main report and subreport.

ie.without passing any parameter.

When i try to pass parameter from main report to sub report it is throwing the following errror


Microsoft][sqlServer 2000 Driver for JDBC]Syntax error at token }, line 0 offset 8.


I have given the following sql statement that i used in subreport

select city from customers where country=${country}


Please telll me the steps on how to pass parameter from main report to sub report.




By: whattodonow - whattodonow

RE: How to do Subreport???

2005-08-02 13:26

How did you use subreports without passing parameters?

Link to comment
Share on other sites

  • Replies 0
  • 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...