A Subreport Question

By: Jay Fleck - jayf23
A Subreport Question
2003-02-21 15:05
I created a master report and a subreport. When I compile the master report, the static text from the subreport appears correctly. However, the data fields in my subreport are not being filled in. I would assume that this has something to do with my subreport 'Connection Expression'. Per the JasperReports documentation and example, I set this to $P{REPORT_CONNECTION}, assuming that it would then use the same connection as the master report. However, when I compile I receive the message:
Warning: The supplied java.sql.Connection object is null.
And the subreport data fields are not appearing on the report.

Can anyone offer any help? Forgive me if I sound ignorant as I am trying to grasp these concepts which are all fairly new to me.

Thank You.

By: Giulio Toffoli - gt78
RE: A Subreport Question
2003-02-22 01:52
Ciao Jay,

Leave blank the query field in the compilation window. In this way, IReportCompiler pass the connection as Parameter to jasperReport filler, and not only the ResultSet, that is not useful for generating subreports and cause the Warning: The supplied java.sql.Connection object is null.

Good Luck


By: Jay Fleck - jayf23
RE: A Subreport Question
2003-02-24 07:24
That worked!

Thank you very much, Giulio.

ktrinad's picture
Joined: Aug 9 2006 - 2:36am
Last seen: 16 years 10 months ago

2 Answers:

hey guys...
i too have the same problem. My sub-report data is not being displayed. But my master report is displaying data. On the console getting following error -- "warning :the supplied java.sql.connection object is null in subreports"

Please help me out.. thanks in advance
itzbobi's picture
Joined: Sep 10 2009 - 3:45am
Last seen: 13 years 9 months ago