Subreport Not Displaying - Please Help

2005 IR Help · August 26, 2006

By: mike w - mwans

2003-04-18 09:07

Hello,

I am having a problem. I have some subreports that are not showing up. When I compile them (with iReport) seperately, they work fine. But when I put them in my Master report, they do not show up. I am sure this is something simple, but after looking at it for so long, I cannot figure it out. PLEASE HELP! Thank you in advance.

Here is the code:

MASTER:

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport

name="TBL_02_MASTER"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="595"

pageHeight="842"

columnWidth="540"

columnSpacing="0"

leftMargin="20"

rightMargin="20"

topMargin="30"

bottomMargin="30"

whenNoDataType="AllSectionsNoDetail"

isTitleNewPage="false"

isSummaryNewPage="false">

<title>

</band>

</title>

</textElement>

</staticText>

.

</band>

</pageHeader>

.

</band>

</columnHeader>

<connectionExpression>$P{REPORT_CONNECTION}</connectionExpression>

<subreportExpression class="java.lang.String">".\TBL_02_EVENT_TOTAL_SUB.jasper"</subreportExpression>

</subreport>

</band>

</detail>

.

TOTAL:

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport

name="TBL_02_EVENT_TOTAL"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="270"

pageHeight="500"

columnWidth="270"

columnSpacing="0"

leftMargin="0"

rightMargin="0"

topMargin="0"

bottomMargin="0"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

</variable>

<title>

</band>

</title>

</band>

</pageHeader>

<reportElement

mode="Transparent"

x="3"

y="0"

width="172"

height="30"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

<text>Total</text>

</staticText>

<reportElement

mode="Transparent"

x="183"

y="0"

width="42"

height="30"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

.

</band>

</columnHeader>

<subreportParameterExpression>new Float($F{EVENTS_TOTAL}.floatValue())</subreportParameterExpression>

</subreportParameter>

<subreportExpression class="java.lang.String">".\TBL_02_EVENT_GROUP_SUB.jasper"</subreportExpression>

</subreport>

</band>

</detail>

</band>

</columnFooter>

</band>

</pageFooter>

</band>

</summary>

</jasperReport>

THANK YOU IN ADVANCE FOR ANY HELP!!!

Mike

By: mike w - mwans

RE: Subreport Not Displaying - Please Help

2003-04-18 09:41

OK, I finally figured it out. I needed to add a dummy query into my Master report. I'm assuming this is to initialize the connection? Anyone have some ideas?

By: Teodor Danciu - teodord

RE: Subreport Not Displaying - Please Help

2003-04-21 01:54

Hi,

You have included the subreport in the detail

section of the master reports.

But when there are no records in the master report

data source, the detail section is not generated,

like indicated by whenNoDataType="AllSectionsNoDetail".

A dummy data source can be simulated with new JREmptyDataSource() which will create a data source with only one record and all fields null.

But you still need to pass a Connection object to

your subreports, by using a report parameters in

the master report.

I hope this helps.

Teodor

By: Marco Bucciarelli - marcobuc

RE: Subreport Not Displaying - Please Help

2003-04-23 09:25

Hi,

I have a very similar problem and I tried what you suggest here (perhaps I only try to do what you say but I am doing something wrong).

I have two simple report, a master and a detail. I pass to the subreport the $P{REPORT_CONNECTION} parameter but the subreport is not displayed. I tried to put the subreport in the detail or in the title section but nothing happens (all other fields of the master are displayed, also the sysdate field).

This is only a test, because my real problem is this (perhaps I am using an incorrect approach):

I have to print a report that is composed by 2 pages repeated 4 times (total 8 pages). Each copy of the pages has only a little difference compared with the others (something like "copy for the customer", "copy for the management", etc...). Each page is a fixed form in which I have to write only some fields using only 1 record of a datasource.

So I want to create two reports for page 1 and page 2, then put this reports 4 times in my master report to obtain an 8 pages report with the fields filled.

Doing the test, when I run the report from iReport I get this (the message "AVVERTENZA: The supplied java.sql.Connection object is null is the problem, I think"):

C:ProgrammiJavasoftj2sdk1.4.1_01binjava.exe -Dorg.xml.sax.driver=org.apache.xerces.parsers.SAXParser IReportCompiler -c -pdf -jdriveroracle.jdbc.driver.OracleDriver -juserscott -jpasswdtiger -jurljdbc:oracle:thin:@ares:1521:WEBDB -query "select sysdate from dual" "F:downloadjasperreportsjasperreports-0.4.6-projectdemomytestsTwoPages.xml"

File: F:downloadjasperreportsjasperreports-0.4.6-projectdemomytestsTwoPages.xml

Compiling to file... F:downloadjasperreportsjasperreports-0.4.6-projectdemomytestsTwoPages.jasper

Compilation running time : 6119

Opening connection....

Executing query select sysdate from dual

23-apr-2003 18.08.02 dori.jasper.engine.fill.JRBaseFiller fill

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

Print generated succesfully.

Exporting pdf to file... F:downloadjasperreportsjasperreports-0.4.6-projectdemomytestsTwoPages.pdf

Running time : 11646

Viewing pdf...F:downloadjasperreportsjasperreports-0.4.6-projectdemomytestsTwoPages.pdf

Here are my reports:

MASTER (TwoPages.xml)

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport

name="TwoPages"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="595"

pageHeight="842"

columnWidth="300"

columnSpacing="0"

leftMargin="40"

rightMargin="40"

topMargin="50"

bottomMargin="50"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

<queryString>select sysdate from dual</queryString>

<title>

<image scaleImage="FillFrame" isUsingCache="false" evaluationTime="Now" hyperlinkType="Reference"> <reportElement

mode="Opaque"

x="0"

y="2"

width="132"

height="50"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</image>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="372"

y="0"

width="143"

height="30"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

<reportElement

mode="Opaque"

x="59"

y="66"

width="455"

height="20"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="true"/>

<subreportParameterExpression>$F{SYSDATE}</subreportParameterExpression>

</subreportParameter>

<connectionExpression>$P{REPORT_CONNECTION}</connectionExpression>

</subreport>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="2"

y="66"

width="52"

height="18"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

<textFieldExpression class="java.sql.Timestamp">$F{SYSDATE}</textFieldExpression>

</textField>

</band>

</title>

</band>

</pageHeader>

</band>

</columnHeader>

</band>

</detail>

</band>

</columnFooter>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="190"

y="20"

width="80"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement

mode="Transparent"

x="269"

y="20"

width="75"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

</band>

</pageFooter>

</band>

</summary>

</jasperReport>

DETAIL (NoReport.xml)

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport

name="NoReport"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="400"

pageHeight="400"

columnWidth="300"

columnSpacing="0"

leftMargin="40"

rightMargin="40"

topMargin="50"

bottomMargin="50"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

<queryString>select SYSDATE from dual</queryString>

<title>

<image scaleImage="FillFrame" isUsingCache="false" evaluationTime="Now" hyperlinkType="Reference"> <reportElement

mode="Opaque"

x="0"

y="2"

width="132"

height="50"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</image>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="177"

y="2"

width="143"

height="30"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

</band>

</title>

</band>

</pageHeader>

</band>

</columnHeader>

<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="4"

y="3"

width="309"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

<textField isStretchWithOverflow="false" pattern="dd/MM/yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="113"

y="26"

width="104"

height="18"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

<textFieldExpression class="java.sql.Timestamp">$F{SYSDATE}</textFieldExpression>

</textField>

</band>

</detail>

</band>

</columnFooter>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="109"

y="20"

width="80"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement

mode="Transparent"

x="188"

y="20"

width="75"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

</band>

</pageFooter>

</band>

</summary>

</jasperReport>

Thanks,

Marco.

By: Marco Bucciarelli - marcobuc

RE: Subreport Not Displaying - Please Help

2003-04-24 01:51

After a lot of testing and trying I could get the subreport printed on my master report.

The problem was that my master report is filled from a JRDataSource, so the Connection passed to the subreport is null and therefore that error message. Putting in the detail report whenNoDataType="AllSectionsNoDetail" the subreport is printed (without detail).

For my problem (generating the 8 pages report) I thought of this solution:

- generate two subreports for page 1 and 2 with a very big title section (getting all the page height) and put them 4 times on the master report;

- for the dynamic text fields in the subreports I will get the values as parameters (I read only 1 record in the master report);

- in the master report I get the datasource and pass all fields as parameters to the subreports.

This is not really a fast job to do, but I think it should work. If someone has a better solution or idea (perhaps someone who solved a similar problem) please let me know.

Another thing: is there a way to get in the subreport the real page number in which it is printed (the master page number)?

Thanks in advance,

Marco.

By: Teodor Danciu - teodord

RE: Subreport Not Displaying - Please Help

2003-04-24 06:37

Hi,

You should try to pass the current master report

page number to your subreport as a parameter.

Inside the subreport, you'll add this to the subreport's current page number to obtain the

overall page number from within the subreport.

I hope this helps.

Teodor

By: Dave Gray - dgray

RE: Subreport Not Displaying - Please Help

2003-04-30 09:01

I am also having problems with page numbers in subreports. I have a <pageFooter> in the main report and the sub report. This causes the following:

- for pages that just have main report records, the page number is formatted properly at the bottom of the page.

- for pages that contain records from the main report and the sub report (i.e. the subreport starts part way down the page), the page number appears twice - once for the subreport, once for the main report.

- for pages that contain only subreport records, the page footer appears directly below the last record on the page, not at the bottom of the page.

It would be really nice if the main report controlled page headers and footers if not overridden by the subreport description.

Thanks,

Dave

By: Teodor Danciu - teodord

RE: Subreport Not Displaying - Please Help

2003-04-30 23:04

Hi,

There is no particular relation between the content

of the master report and the content od the subreport.

Any report can run as a standalon report or can

be included into another report as a subreport.

If you have placed text fields that display the page

number both on the subreport and on the master

report, then this is why you get both.

You have to decide where you want to have the

page number displayed and put it only in one

place.

Thank you,

Teodor

By: Dave Gray - dgray

RE: Subreport Not Displaying - Please Help

2003-05-05 05:07

I resolved the duplicate page numbering when I move from main report to subreport. However still the page numbers in the subreport come just below the last report line instead of uniformly at the bottom of the page. Am I missing a setting?

By: Teodor Danciu - teodord

RE: Subreport Not Displaying - Please Help

2003-05-06 00:24

Hi,

This is how subreport page footers behave.

I would rather remove the page number from

the subreport, not the master report.

Thank you,

Teodor

By: Todd - mrtodds

RE: Subreport Not Displaying - Please Help

2004-05-06 14:01

I am also having this problem with passing page numbers to the sub-ReportS. I can pass the current page number as a parameter to the sub-report (as you suggested above) just fine, but how do I pass the total pages parameter which is just the same variable $V{PAGE_NUMBER} determined at report time instead?

Sign In

Subreport Not Displaying - Please Help

Recommended Posts

2005 IR Help

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore