Problem with Subreport and Connection

[thohei]

Hi,

i´m trying to create a Report with a subreport.

The Report with Subreport i created in iReport 4.0 and everything works fine.

But if i trie to call the report from my java application the MainReport is still working but the subreport data is empty.

The subreport is loaded in the mainreport. I checked this with adding a title band in the subreport an the everything works fine.

The Error Message from java is:

net.sf.jasperreports.engine.query.JRJdbcQueryExecuter <init>

Warning: The supplied java.sql.Connection object is null.

In the mainreport actually is set on subreport properties:

Connection type: Use a connection expression

Connection expression: $P{REPORT_CONNECTION}

I don´t no where the error is. But it is still the same problem.

  Here is my java file where i´m calling the report:

Code:

Have anyone an idea where the problem is?

 

Regards

Thomas

Post Edited by thohei at 02/03/2011 12:34

Post Edited by thohei at 02/03/2011 12:35

[phantastes]

Not sure if this will help, but it might be worth a try. Do you have a query in the main report? If not just add a very simple query to the main report and try again.

 

 

[thohei]

Hi,

does not working. I have tested a lot of options, but nothing will work correct. In the iReport 4.0 Program everythings works very well.

Could anyone tell me the resolution for this problem.

Or is there another free reporting tool for java?