2005 IR Help Posted August 26, 2006 Share Posted August 26, 2006 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now