Subreport: PDF No Pages Error

2002 JI Open Discussion · August 18, 2006

By: Ryan - louier79

2003-08-18 14:15

Hello,

I am trying to use the subreport feature, but I keep receiving an error in Adobe Acrobat: "There was an error opening this document. This file cannot be opened because it has no pages.

Here is the MasterReport.xml:

------------------------------

<jasperReport

name="Bill_Master"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="612"

pageHeight="792"

columnWidth="612"

columnSpacing="0"

leftMargin="0"

rightMargin="0"

topMargin="0"

bottomMargin="0"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

<title>

</band>

</title>

</band>

</pageHeader>

</band>

</columnHeader>

<reportElement

mode="Transparent"

x="0"

y="0"

width="612"

height="260"

forecolor="#000000"

backcolor="#FFCC99"

positionType="FixRelativeToTop"

isPrintRepeatedValues="false"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<subreportExpression class="dori.jasper.engine.JasperReport">$P{Bill_Header}</subreportExpression>

</subreport>

</band>

</detail>

</band>

</columnFooter>

</band>

</pageFooter>

</band>

</summary>

</jasperReport>

Subreport.xml:

---------------

<jasperReport

name="Bill_Header"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="612"

pageHeight="260"

columnWidth="612"

columnSpacing="0"

leftMargin="0"

rightMargin="0"

topMargin="0"

bottomMargin="0"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

<queryString><![CDATA[sELECT

i.CAMPUS_ID,

i.HEADER_MESSAGE1,

i.HEADER_MESSAGE2,

i.PAYMENT_ADDRESS,

s.SID,

s.ACTIVITY_THROUGH,

s.AMOUNT_DUE,

s.DATE_DUE,

s.AMOUNT_PAID,

s.STUDENT_NAME,

s.BILL_RECORD_NUMBER

FROM

BRS_WEBBILLS_ACCOUNT_SUMMARY s,

BRS_WEBBILLS_CAMPUS_INFO i

WHERE

s.SID = '522-31-6590'

AND i.CAMPUS_ID = 'DN'

AND s.ACTIVITY_THROUGH = to_date('03/14/03','MM/DD/YY')

AND s.ACTIVITY_THROUGH = i.ACTIVITY_THROUGH]]></queryString>

</band>

</background>

<title>

</band>

</title>

</band>

</pageHeader>

<reportElement

mode="Transparent"

x="45"

y="20"

width="130"

height="15"

forecolor="#808080"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

<text>University of Colorado</text>

</staticText>

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

mode="Transparent"

x="45"

y="35"

width="205"

height="65"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

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

mode="Transparent"

x="335"

y="25"

width="230"

height="75"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

<reportElement

mode="Opaque"

x="0"

y="205"

width="612"

height="55"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</rectangle>

<reportElement

mode="Opaque"

x="45"

y="100"

width="522"

height="25"

forecolor="#000000"

backcolor="#DDDDDD"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</rectangle>

<reportElement

mode="Transparent"

x="60"

y="103"

width="59"

height="10"

forecolor="#000000"

backcolor="#C0C0C0"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

<text>Student ID</text>

</staticText>

<reportElement

mode="Transparent"

x="150"

y="103"

width="80"

height="10"

forecolor="#000000"

backcolor="#C0C0C0"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

<text>Activity Through</text>

</staticText>

<reportElement

mode="Transparent"

x="285"

y="103"

width="55"

height="10"

forecolor="#000000"

backcolor="#C0C0C0"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

<text>Amount Due</text>

</staticText>

<reportElement

mode="Transparent"

x="380"

y="103"

width="45"

height="10"

forecolor="#000000"

backcolor="#C0C0C0"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

<reportElement

mode="Transparent"

x="470"

y="103"

width="55"

height="10"

forecolor="#000000"

backcolor="#C0C0C0"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

<text>AMOUNT PAID</text>

</staticText>

<reportElement

mode="Opaque"

x="440"

y="100"

width="0"

height="25"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</line>

<reportElement

mode="Transparent"

x="340"

y="246"

width="240"

height="10"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

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

mode="Transparent"

x="60"

y="112"

width="59"

height="10"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

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

mode="Transparent"

x="150"

y="112"

width="80"

height="10"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

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

mode="Transparent"

x="285"

y="112"

width="55"

height="10"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

<textFieldExpression class="java.lang.String">$F{AMOUNT_DUE}</textFieldExpression>

</textField>

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

mode="Transparent"

x="380"

y="112"

width="45"

height="10"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

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

mode="Transparent"

x="481"

y="112"

width="40"

height="10"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

<textFieldExpression class="java.lang.String">$F{AMOUNT_PAID}</textFieldExpression>

</textField>

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

mode="Transparent"

x="45"

y="155"

width="145"

height="10"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

<textFieldExpression class="java.lang.String">$F{STUDENT_NAME}</textFieldExpression>

</textField>

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

mode="Transparent"

x="340"

y="160"

width="140"

height="40"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

<textFieldExpression class="java.lang.String">$F{PAYMENT_ADDRESS}</textFieldExpression>

</textField>

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

mode="Transparent"

x="340"

y="213"

width="240"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

<textFieldExpression class="java.lang.String">$F{BILL_RECORD_NUMBER}</textFieldExpression>

</textField>

<reportElement

mode="Transparent"

x="477"

y="112"

width="5"

height="10"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

</band>

</columnHeader>

</band>

</detail>

</band>

</columnFooter>

</band>

</pageFooter>

</band>

</summary>

</jasperReport>

Thank you for your assistance and advice!

By: Sohan Kasula - skasula

RE: Subreport: PDF No Pages Error

2003-08-18 14:59

Probably there is no output through the SQL statement. If there is try using whenNoDataType="AllSectionsNoDetail" in the reports and go about trouble shooting the data.

Hope this helps.

By: Ryan - louier79

RE: Subreport: PDF No Pages Error

2003-08-18 15:23

Thank you, I added the whenNoDataType="AllSectionsNoDetail" line and it stopped the error message in Acrobat, but it displayed a blank page. When I run the subreport separtely, it prints out fine with all the results.

Any other suggestions or advice?

Thank you again!

By: Gregory A. Swarthout - gswarthout

RE: Subreport: PDF No Pages Error

2003-08-18 15:37

What data source are you passing into the master report? It has to have at least one row to get the detail section containing the subreport to print.

By: Ryan - louier79

RE: Subreport: PDF No Pages Error

2003-08-18 15:57

The data source is the JRDataSource, a SQL query that I put into the iReport app. The subreport prints every field/row when printed separtely, but is blank when in the master report.

Any other suggestions?

Thank you again!!!

By: Gregory A. Swarthout - gswarthout

RE: Subreport: PDF No Pages Error

2003-08-18 16:09

I don't use iReport, so I'm not sure how much help I can give you on this. There isn't a queryString in your master report, so you're passing in a date source of type JRDataSource. JRDataSource is an interface, so what is the concrete type of the data source you are passing in?

By: Ryan - louier79

RE: Subreport: PDF No Pages Error

2003-08-18 16:25

The subreport has the queryString, should it be in the subreport or the master report?

I put the queryString in the master report, instead of the subreport and it still printed a blank page. (Note: the queryString was still in the subreport)

Also, in the master report, I use the <connectionExpression>$P{REPORT_CONNECTION}</connectionExpression>, should I be using the REPORT_DATASOURCE instead?

Thank you again!!!

By: Gregory A. Swarthout - gswarthout

RE: Subreport: PDF No Pages Error

2003-08-18 16:37

This is where you've reached the extend of my knowledge on the matter. Maybe someone else can step in a help you with this.

But, just for testing purposes, come up with a queryString for the master report that is guaranteed to return exactly one row (maybe a sum() or count()) and leave everything else the way it is, and let me know what happens.

By: Teodor Danciu - teodord

RE: Subreport: PDF No Pages Error

2003-08-19 07:34

Hi,

I suspect the master report receives a data source

with no records in it, as Gregory pointed out already.

Maybe a null datasource.

In this case, the detail section of the master report

never gets generated, even if you set whenNoDataType="AllSectionsNoDetail" for you master report. Note the "...NoDetail" part.

A quick solution is to move the subreport from the detail section to the title section of the master report.

I hope this helps.

Teodor

By: Ryan - louier79

RE: Subreport: PDF No Pages Error

2003-08-19 11:03

Hello,

I tried moving the subreport to the title band and it will still not print. When I run the subreport separtely, it prints all the fields (i.e records in the resultset).

I re-read the docs and came over dataSourceExpression, can you please provide same sample code (both master and subreport) with dataSourceExpression?

My master report has the queryString, so should I use the dataSourceExpression or connectionExpression?

Thank you again for your assistance!!!

By: Teodor Danciu - teodord

RE: Subreport: PDF No Pages Error

2003-10-05 02:32

Hi,

<connectionExpression> is used to pass a connection

object to the subreport in case the subreport has a

query of its own inside.

<dataSourceExpression> is used when there is no

query inside the subreport and we pass a

JRDataSource object directly.

Usually, those two tags are not used simultaneously

for the same <subreport>.

I hope this helps.

Teodor

Sign In

Subreport: PDF No Pages Error

Recommended Posts

2002 JI Open Discussion

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