How to do Subreport???

[2002 JI Open Discussion]

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

$P{REPORT_CONNECTION}.

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.

 

Giulio

 

 

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?