information printing twice

[2002 JI Open Discussion]

By: tim spring - desertspring

information printing twice

2003-07-30 01:34

Hi,

for some reason, the following prints my information twice, once on a page for two pages. Any help greatly appreciated:

 

<?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="OrganisationDetails" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="501" pageHeight="471" columnWidth="501" columnSpacing="0" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" whenNoDataType="BlankPage" isTitleNewPage="false" isSummaryNewPage="false">

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

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

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

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

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

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

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

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

<queryString><![CDATA[sELECT tbOrganization.Name as OrganisationName, tbOrganization.SDLNumber, tbOrganization.RegNo as OrgRegistrationNumber, tbOrganization.PostalAddress, tbOrganization.PostalCode, tbOrganization.PhysicalAddress as Address, tbOrganization.Telephone, tbOrganization.Fax, tbOrganization.Description as OrganisationDescription, tbIndustryCodes.Code as IndustryCode, tbOrganization.TradeName as TradingAs FROM tbOrganization, tbIndustryCodes]]></queryString>

<field name="OrganisationName" class="java.lang.String"/>

<field name="SDLNumber" class="java.lang.String"/>

<field name="OrgRegistrationNumber" class="java.lang.String"/>

<field name="PostalAddress" class="java.lang.String"/>

<field name="PostalCode" class="java.lang.String"/>

<field name="Address" class="java.lang.String"/>

<field name="Telephone" class="java.lang.String"/>

<field name="Fax" class="java.lang.String"/>

<field name="OrganisationDescription" class="java.lang.String"/>

<field name="IndustryCode" class="java.lang.String"/>

<field name="TradingAs" class="java.lang.String"/>

<background>

<band height="0">

</band>

</background>

<title>

<band height="1">

<line direction="TopDown">

<reportElement mode="Opaque" x="0" y="0" width="500" height="1" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/>

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

</line>

</band>

</title>

<pageHeader>

<band height="0">

</band>

</pageHeader>

<columnHeader>

<band height="0">

</band>

</columnHeader>

<detail>

<band height="467">

<staticText>

<reportElement mode="Transparent" x="5" y="10" width="482" height="30" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Bold" size="14"/>

</textElement>

<text><![CDATA[A. WORKPLACE SKILLS PLAN]]></text>

</staticText>

<staticText>

<reportElement mode="Transparent" x="5" y="31" width="476" height="30" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal" size="12"/>

</textElement>

<text><![CDATA[The information provided in this document will be treated in the strictest confidence.]]></text>

</staticText>

<staticText>

<reportElement mode="Transparent" x="129" y="67" width="256" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal" pdfFontName="Helvetica-Bold" size="14" isBold="true"/>

</textElement>

<text>Tell us about your Organisation</text>

</staticText>

<staticText>

<reportElement mode="Transparent" x="1" y="91" width="320" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

<text>Period for which WSP is submitted</text>

</staticText>

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

<reportElement mode="Transparent" x="333" y="91" width="67" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal" size="6"/>

</textElement>

<textFieldExpression class="java.lang.String">$P{PeriodFrom}</textFieldExpression>

</textField>

<staticText>

<reportElement mode="Transparent" x="395" y="91" width="22" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal" size="8"/>

</textElement>

<text>to</text>

</staticText>

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

<reportElement mode="Transparent" x="421" y="91" width="71" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal" size="6"/>

</textElement>

<textFieldExpression class="java.lang.String">$P{PeriodTo}</textFieldExpression>

</textField>

<staticText>

<reportElement mode="Transparent" x="2" y="115" width="320" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

<text><![CDATA[in which industry is your Organisation involved?]]></text>

</staticText>

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

<reportElement mode="Transparent" x="331" y="116" width="158" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

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

</textField>

<staticText>

<reportElement mode="Transparent" x="1" y="141" width="320" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

<text><![CDATA[sARS Skills Development Levy ("SDL") Registration No.]]></text>

</staticText>

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

<reportElement mode="Transparent" x="331" y="141" width="158" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

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

</textField>

<staticText>

<reportElement mode="Transparent" x="1" y="166" width="320" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

<text><![CDATA[Organisation Name.]]></text>

</staticText>

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

<reportElement mode="Transparent" x="331" y="166" width="158" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

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

</textField>

<staticText>

<reportElement mode="Transparent" x="1" y="191" width="320" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

<text><![CDATA[Trading As.]]></text>

</staticText>

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

<reportElement mode="Transparent" x="331" y="191" width="158" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

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

</textField>

<staticText>

<reportElement mode="Transparent" x="1" y="216" width="320" height="45" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

<text>Postal Address</text>

</staticText>

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

<reportElement mode="Transparent" x="331" y="216" width="158" height="45" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

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

</textField>

<staticText>

<reportElement mode="Transparent" x="1" y="261" width="320" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

<text>Postal Code</text>

</staticText>

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

<reportElement mode="Transparent" x="331" y="261" width="158" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

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

</textField>

<staticText>

<reportElement mode="Transparent" x="1" y="287" width="320" height="45" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

<text>Physical Address</text>

</staticText>

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

<reportElement mode="Transparent" x="331" y="287" width="158" height="45" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

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

</textField>

<staticText>

<reportElement mode="Transparent" x="1" y="332" width="320" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

<text>Organisation Tel Number</text>

</staticText>

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

<reportElement mode="Transparent" x="331" y="332" width="158" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

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

</textField>

<staticText>

<reportElement mode="Transparent" x="1" y="357" width="320" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

<text>Organisation Fax Number</text>

</staticText>

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

<reportElement mode="Transparent" x="331" y="357" width="158" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

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

</textField>

<staticText>

<reportElement mode="Transparent" x="2" y="382" width="320" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

<text>What does your Organisation do?</text>

</staticText>

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

<reportElement mode="Transparent" x="331" y="382" width="158" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

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

</textField>

<staticText>

<reportElement mode="Transparent" x="1" y="407" width="320" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

<text><![CDATA[Total no. of Employees for whom SDL Levies are Paid]]></text>

</staticText>

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

<reportElement mode="Transparent" x="331" y="407" width="158" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

<textFieldExpression class="java.lang.String">$P{NumEmployees}</textFieldExpression>

</textField>

<staticText>

<reportElement mode="Transparent" x="1" y="432" width="320" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

<text><![CDATA[Total Annual Payroll for the End of the Last Financial Year]]></text>

</staticText>

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

<reportElement mode="Transparent" x="331" y="432" width="158" height="25" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font reportFont="Arial_Normal"/>

</textElement>

<textFieldExpression class="java.lang.String">$P{Payroll}</textFieldExpression>

</textField>

</band>

</detail>

<columnFooter>

<band height="0">

</band>

</columnFooter>

<pageFooter>

<band height="0">

</band>

</pageFooter>

<summary>

<band height="0">

</band>

</summary>

</jasperReport>