Jump to content
Changes to the Jaspersoft community edition download ×

Subreport Not Displaying - Please Help


2005 IR Help

Recommended Posts

By: mike w - mwans

Subreport Not Displaying - Please Help

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" ?>

<!-- Created with iReport - A designer for JasperReports -->

<!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 height="0">

</band>

</title>

<pageHeader>

<band height="50">

<staticText>

<reportElement positionType="Float" x="0" y="0" width="540" height="16"/>

<textElement textAlignment="Center">

<font size="12"/>

</textElement>

<text><![CDATA[Table 2]]></text>

</staticText>

.

.

.

</band>

</pageHeader>

 

<columnHeader>

<band height="40">

.

.

.

</band>

</columnHeader>

 

<detail>

<band height="0">

<!-- EVENTS TOTALS SUB: "TBL_02_EVENT_TOTAL_SUB.jasper" -->

<subreport isUsingCache="true">

<reportElement x="0" y="0" width="270" height="0" forecolor="#FFFFFF" positionType="Float"/>

<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">

 

<queryString><![CDATA[sELECT SUM(COUNT(VW_TBL_02_EVENTS.YEAR)) AS EVENTS_TOTAL FROM VW_TBL_02_EVENTS WHERE VW_TBL_02_EVENTS.YEAR = 2003 group by VW_TBL_02_EVENTS.SHORT_DESCRIPTION]]></queryString>

 

<field name="EVENTS_TOTAL" class="java.lang.Long"/>

 

<variable name="test" class="java.lang.String" resetType="None" calculation="Nothing">

<variableExpression><![CDATA["test"]]></variableExpression>

<initialValueExpression><![CDATA["test"]]></initialValueExpression>

</variable>

 

<title>

<band height="0">

</band>

</title>

<pageHeader>

<band height="0">

</band>

</pageHeader>

<columnHeader>

<band height="30">

<staticText>

<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 textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="Helvetica" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

<text>Total</text>

</staticText>

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

<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 textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

.

.

.

</band>

</columnHeader>

<detail>

<band height="0">

<!-- EVENTS GROUP SUB: "TBL_02_EVENT_GROUP_SUB.jasper" -->

<subreport isUsingCache="true">

<reportElement x="0" y="0" width="270" height="0" forecolor="#FFFFFF" positionType="Float"/>

<subreportParameter name="TOTAL">

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

</subreportParameter>

<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>

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

</subreport>

</band>

</detail>

<columnFooter>

<band height="0">

</band>

</columnFooter>

<pageFooter>

<band height="0">

</band>

</pageFooter>

<summary>

<band height="0">

</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" ?>

<!-- Created with iReport - A designer for JasperReports -->

<!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">

<reportFont name="Arial_Normal" isDefault="true" fontName="Arial" size="12" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

<reportFont name="Arial_Bold" isDefault="false" fontName="Arial" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

<reportFont name="Arial_Italic" isDefault="false" fontName="Arial" size="12" isBold="false" isItalic="true" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Oblique" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

<parameter name="ReportTitle" isForPrompting="true" class="java.lang.String"/>

<parameter name="BaseDir" isForPrompting="true" class="java.io.File"/>

<queryString>select sysdate from dual</queryString>

<field name="SYSDATE" class="java.sql.Timestamp"/>

<title>

<band height="108">

<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"/>

<graphicElement stretchType="NoStretch" pen="None" fill="Solid" />

<imageExpression class="java.io.File"><![CDATA[new File($P{BaseDir}, "images/logo.gif")]]></imageExpression> <hyperlinkReferenceExpression><![CDATA["http://www.optimabroker.it/optima"]]></hyperlinkReferenceExpression>

</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 textAlignment="Right" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" reportFont="Arial_Normal" pdfFontName="Helvetica" size="22" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA["MASTER: " + $P{ReportTitle}]]></textFieldExpression>

</textField>

<subreport isUsingCache="true">

<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"/>

<subreportParameter name="SYSDATE">

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

</subreportParameter>

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

<subreportExpression class="java.lang.String"><![CDATA["NoReport.jasper"]]></subreportExpression>

</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 textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

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

</textField>

</band>

</title>

<pageHeader>

<band height="38">

</band>

</pageHeader>

<columnHeader>

<band height="0">

</band>

</columnHeader>

<detail>

<band height="34">

</band>

</detail>

<columnFooter>

<band height="0">

</band>

</columnFooter>

<pageFooter>

<band height="42">

<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 textAlignment="Right" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA["Pagina " + String.valueOf($V{PAGE_NUMBER}) + " di"]]></textFieldExpression>

</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 textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[" " + String.valueOf($V{PAGE_NUMBER})]]></textFieldExpression>

</textField>

</band>

</pageFooter>

<summary>

<band height="80">

</band>

</summary>

</jasperReport>

 

 

DETAIL (NoReport.xml)

 

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

<!-- Created with iReport - A designer for JasperReports -->

<!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">

<reportFont name="Arial_Normal" isDefault="true" fontName="Arial" size="12" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

<reportFont name="Arial_Bold" isDefault="false" fontName="Arial" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

<reportFont name="Arial_Italic" isDefault="false" fontName="Arial" size="12" isBold="false" isItalic="true" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Oblique" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

<parameter name="ReportTitle" isForPrompting="true" class="java.lang.String"/>

<parameter name="BaseDir" isForPrompting="true" class="java.io.File"/>

<queryString>select SYSDATE from dual</queryString>

<field name="SYSDATE" class="java.sql.Timestamp"/>

<title>

<band height="56">

<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"/>

<graphicElement stretchType="NoStretch" pen="None" fill="Solid" />

<imageExpression class="java.io.File"><![CDATA[new File($P{BaseDir}, "images/logo.gif")]]></imageExpression> <hyperlinkReferenceExpression><![CDATA["http://www.optimabroker.it/optima"]]></hyperlinkReferenceExpression>

</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 textAlignment="Right" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" reportFont="Arial_Normal" pdfFontName="Helvetica" size="22" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA["DETAIL: " + $P{ReportTitle}]]></textFieldExpression>

</textField>

</band>

</title>

<pageHeader>

<band height="20">

</band>

</pageHeader>

<columnHeader>

<band height="0">

</band>

</columnHeader>

<detail>

<band height="56">

<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 textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" reportFont="Arial_Normal" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA["Questa stampa non è ancora stata implementata"]]></textFieldExpression>

</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 textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

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

</textField>

</band>

</detail>

<columnFooter>

<band height="0">

</band>

</columnFooter>

<pageFooter>

<band height="42">

<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 textAlignment="Right" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA["Pagina " + String.valueOf($V{PAGE_NUMBER}) + " di"]]></textFieldExpression>

</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 textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[" " + String.valueOf($V{PAGE_NUMBER})]]></textFieldExpression>

</textField>

</band>

</pageFooter>

<summary>

<band height="80">

</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?

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...