Any1 Sub-R....please chk out this 1..SOS!

[2005 IR Help]

By: Joey - joeyfeet

Any1 Sub-R....please chk out this 1..SOS!

2004-05-06 03:05

Hi all!

 

I am posting this for the third time due to urgency...so plz help!

 

 

I have create a Report where I've two Sub-Reports "A.jasper" and "B.jasper" included in a Master Report i.e. "Master.jasper". I am passing the DataSource to there two Sub-Reports from the Master report using Data Source Expression. This part is working fine and the two reports get populated with the data perfectly.

 

I have included the two-subreports in two different Groups i.e. "AGroup (for Sub-Report A)" and "BGroup" (for Sub-Report B) in the the Master report one followed by another.

 

However when the first sub-report (A) has around 20 records the resulting output is fine but when it exceeds 20 the below sub-report (B) again overwrites itself!

Also if we exceed the number of Records for Sub-Report A in order to have Multiple-Pages for sun-report A it doesn't do so.Instead the Sub-Report A is retricted to only first page when the records exceeds it starts Overwriting the Same first Page making the Output a complete MESS.

 

This is the skeleton structure of the rpt:

 

Master Report Starts++++++++

 

<AGroup >

SubReport A

<AGroup Ends>

 

<BGroup>

SubReport B

</BGroup Ends>

 

Static Text in Master Report

 

 

Master Report Ends++++++++++

 

 

 

Please have a look at the below given Master Report's XML file:

 

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

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="595"

pageHeight="842"

columnWidth="515"

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="ASubreport" isForPrompting="true" class="dori.jasper.engine.JasperReport"/>

<parameter name="BSubreport" isForPrompting="true" class="dori.jasper.engine.JasperReport"/>

<parameter name="ADataSource" isForPrompting="true" class="dori.jasper.engine.JRDataSource"/>

<parameter name="BDataSource" isForPrompting="true" class="dori.jasper.engine.JRDataSource"/>

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

<group name="ConditionGroup" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="60" >

<groupExpression><![CDATA[

$F{City}

]]></groupExpression>

<groupHeader>

<band height="40">

<subreport isUsingCache="true">

<reportElement

mode="Opaque"

x="7"

y="3"

width="325"

height="20"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="false"

isRemoveLineWhenBlank="true"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="true"/>

<subreportParameter name="City">

<subreportParameterExpression><![CDATA[$F{City}]]></subreportParameterExpression>

</subreportParameter>

<dataSourceExpression><![CDATA[$P{ADataSource}]]></dataSourceExpression>

<subreportExpression class="dori.jasper.engine.JasperReport"><![CDATA[$P{ASubreport}]]></subreportExpression>

</subreport>

</band>

</groupHeader>

<groupFooter>

<band height="0">

</band>

</groupFooter>

</group>

<group name="PremiumGroup" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >

<groupExpression><![CDATA[

$F{City}

]]></groupExpression>

<groupHeader>

<band height="50">

<subreport isUsingCache="true">

<reportElement

mode="Opaque"

x="7"

y="3"

width="325"

height="21"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="false"

isRemoveLineWhenBlank="true"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<subreportParameter name="City">

<subreportParameterExpression><![CDATA[$F{City}]]></subreportParameterExpression>

</subreportParameter>

<dataSourceExpression><![CDATA[$P{BDataSource}]]></dataSourceExpression>

<subreportExpression class="dori.jasper.engine.JasperReport"><![CDATA[$P{BSubreport}]]></subreportExpression>

</subreport>

</band>

</groupHeader>

<groupFooter>

<band height="0">

</band>

</groupFooter>

</group>

<background>

<band height="0">

</band>

</background>

<title>

<band height="0">

</band>

</title>

<pageHeader>

<band height="0">

</band>

</pageHeader>

<columnHeader>

<band height="0">

</band>

</columnHeader>

<detail>

<band height="0">

</band>

</detail>

<columnFooter>

<band height="0">

</band>

</columnFooter>

<pageFooter>

<band height="0">

</band>

</pageFooter>

<summary>

<band height="70">

<staticText>

<reportElement

mode="Opaque"

x="7"

y="27"

width="123"

height="42"

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" size="9"/>

</textElement>

<text><![CDATA[signature]]></text>

</staticText>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="136"

y="66"

width="132"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

</line>

<staticText>

<reportElement

mode="Opaque"

x="279"

y="56"

width="43"

height="14"

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" size="9"/>

</textElement>

<text><![CDATA[Examined]]></text>

</staticText>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="330"

y="66"

width="50"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

</line>

</band>

</summary>

</jasperReport>

 

 

I wud really appreciate if any 1 can b a source of help for me.

 

 

Thankz a loadz before hand

Joey

 

 

 

 

By: Chuck Deal - cdeal

RE: Any1 Sub-R....please chk out this 1..SOS!

2004-05-06 10:03

In the past, I've had trouble using the minHeightToStartNewGroup attribute. Try removing it.

 

Also, as a rule of thumb, when something isn;t working, start by using the default attributes and slowly change the attribute values until you find the one causing the problem.

 

It is very difficult for the forum users to help you when you continually repost the same message but not telling us what new things you have tried since the last post.

 

 

 

 

 

 

By: Joey - joeyfeet

RE: Any1 Sub-R....please chk out this 1..SOS!

2004-05-06 22:16

 

Hi !

 

 

I tried removing the attribute "minHeightToStartNewGroup" and also tried the default settings but still the sub-reports over write themself.

 

to eloborate i am placing the XML of the two sib reports below:

 

 

Sub-Report A:

 

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

columnCount="2"

printOrder="Vertical"

orientation="Portrait"

pageWidth="545"

pageHeight="842"

columnWidth="160"

columnSpacing="5"

leftMargin="0"

rightMargin="0"

topMargin="0"

bottomMargin="0"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

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

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

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

<reportFont name="Verdana_Normal11" isDefault="true" fontName="Verdana" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

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

<reportFont name="Verdana_Italic11" isDefault="false" fontName="Verdana" size="11" isBold="false" isItalic="true" isUnderline="false" isStrikeThrough="false" pdfFontName="" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

<reportFont name="Verdana_Normal" isDefault="true" fontName="Verdana" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

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

<reportFont name="Verdana_Italic" isDefault="false" fontName="Verdana" size="10" isBold="true" isItalic="true" isUnderline="false" isStrikeThrough="false" pdfFontName="" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

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

<field name="Id" class="java.lang.Integer"/>

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

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

<group name="ProductGroup" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >

<groupExpression><![CDATA[

$F{Id}

]]></groupExpression>

<groupHeader>

<band height="14">

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="3"

y="0"

width="513"

height="13"

forecolor="#CCCCCC"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

</rectangle>

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

mode="Transparent"

x="5"

y="1"

width="473"

height="11"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font reportFont="Verdana_Normal" pdfFontName="verdana.TTF" size="7"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{condition}]]></textFieldExpression>

</textField>

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

mode="Transparent"

x="483"

y="1"

width="29"

height="11"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font reportFont="Verdana_Normal" pdfFontName="verdana.TTF" size="7"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{answer}]]></textFieldExpression>

</textField>

</band>

</groupHeader>

<groupFooter>

<band height="0">

</band>

</groupFooter>

</group>

<background>

<band height="0">

</band>

</background>

<title>

<band height="14">

</band>

</title>

<pageHeader>

<band height="14">

</band>

</pageHeader>

<columnHeader>

<band height="30">

<staticText>

<reportElement

mode="Opaque"

x="3"

y="1"

width="513"

height="28"

forecolor="#000000"

backcolor="#436457"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font fontName="SansSerif" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>

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

</staticText>

<staticText>

<reportElement

mode="Transparent"

x="6"

y="2"

width="86"

height="12"

forecolor="#E9F5F0"

backcolor="#CCCCCC"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font reportFont="Verdana_Bold11" pdfFontName="verdanab.TTF"/>

</textElement>

<text><![CDATA[Conditions:]]></text>

</staticText>

<staticText>

<reportElement

mode="Transparent"

x="6"

y="16"

width="509"

height="12"

forecolor="#FFFFFF"

backcolor="#CCCCCC"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font reportFont="Verdana_Bold11" pdfFontName="verdanab.TTF"/>

</textElement>

<text><![CDATA[Do Any of The Following Conditions Exist? Yes/No]]></text>

</staticText>

<line direction="BottomUp">

<reportElement

mode="Opaque"

x="515"

y="1"

width="0"

height="28"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

</line>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="3"

y="1"

width="513"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

</line>

<line direction="BottomUp">

<reportElement

mode="Opaque"

x="3"

y="28"

width="513"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

</line>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="3"

y="1"

width="0"

height="28"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

</line>

</band>

</columnHeader>

<detail>

<band height="0">

</band>

</detail>

<columnFooter>

<band height="0">

</band>

</columnFooter>

<pageFooter>

<band height="0">

</band>

</pageFooter>

<summary>

<band height="0">

</band>

</summary>

</jasperReport>

 

 

 

Sub-Report B:

 

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

columnCount="2"

printOrder="Vertical"

orientation="Portrait"

pageWidth="560"

pageHeight="842"

columnWidth="160"

columnSpacing="5"

leftMargin="0"

rightMargin="0"

topMargin="0"

bottomMargin="0"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

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

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

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

<reportFont name="Verdana_Normal11" isDefault="true" fontName="Verdana" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

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

<reportFont name="Verdana_Italic11" isDefault="false" fontName="Verdana" size="11" isBold="false" isItalic="true" isUnderline="false" isStrikeThrough="false" pdfFontName="" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

<reportFont name="Verdana_Normal" isDefault="true" fontName="Verdana" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

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

<reportFont name="Verdana_Italic" isDefault="false" fontName="Verdana" size="10" isBold="true" isItalic="true" isUnderline="false" isStrikeThrough="false" pdfFontName="" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

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

<field name="Id" class="java.lang.Integer"/>

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

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

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

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

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

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

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

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

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

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

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

<group name="ProductGroup" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >

<groupExpression><![CDATA[

$F{Id}

]]></groupExpression>

<groupHeader>

<band height="14">

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

mode="Opaque"

x="7"

y="1"

width="49"

height="12"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font reportFont="Verdana_Normal" pdfFontName="VERDANA.TTF" size="7"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{deductibleOption}]]></textFieldExpression>

</textField>

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

mode="Opaque"

x="60"

y="1"

width="47"

height="12"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(!(new String($F{product}).equalsIgnoreCase("TOTAL")))]]></printWhenExpression>

</reportElement>

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

<font reportFont="Verdana_Normal" pdfFontName="VERDANA.TTF" size="7"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{product}]]></textFieldExpression>

</textField>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="4"

y="0"

width="0"

height="14"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(!(new String($F{totalFlag}).equalsIgnoreCase("TOTAL")))]]></printWhenExpression>

</reportElement>

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

</line>

<line direction="BottomUp">

<reportElement

mode="Opaque"

x="516"

y="0"

width="0"

height="14"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(!(new String($F{totalFlag}).equalsIgnoreCase("TOTAL")))]]></printWhenExpression>

</reportElement>

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

</line>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="58"

y="0"

width="0"

height="14"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(!(new String($F{totalFlag}).equalsIgnoreCase("TOTAL")))]]></printWhenExpression>

</reportElement>

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

</line>

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

mode="Opaque"

x="110"

y="1"

width="47"

height="12"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font reportFont="Verdana_Normal" pdfFontName="VERDANA.TTF" size="7"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{Rate}]]></textFieldExpression>

</textField>

<line direction="BottomUp">

<reportElement

mode="Opaque"

x="108"

y="0"

width="0"

height="14"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(!(new String($F{totalFlag}).equalsIgnoreCase("TOTAL")))]]></printWhenExpression>

</reportElement>

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

</line>

<line direction="BottomUp">

<reportElement

mode="Opaque"

x="158"

y="0"

width="0"

height="14"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(!(new String($F{totalFlag}).equalsIgnoreCase("TOTAL")))]]></printWhenExpression>

</reportElement>

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

</line>

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

mode="Opaque"

x="160"

y="1"

width="50"

height="12"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font reportFont="Verdana_Normal" pdfFontName="VERDANA.TTF" size="7"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{pr}]]></textFieldExpression>

</textField>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="210"

y="0"

width="0"

height="14"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(!(new String($F{totalFlag}).equalsIgnoreCase("TOTAL")))]]></printWhenExpression>

</reportElement>

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

</line>

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

mode="Opaque"

x="211"

y="1"

width="38"

height="12"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font reportFont="Verdana_Normal" pdfFontName="VERDANA.TTF" size="7"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{fsl}]]></textFieldExpression>

</textField>

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

mode="Opaque"

x="251"

y="1"

width="47"

height="12"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font reportFont="Verdana_Normal" pdfFontName="VERDANA.TTF" size="7"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{gst}]]></textFieldExpression>

</textField>

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

mode="Opaque"

x="300"

y="1"

width="51"

height="12"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font reportFont="Verdana_Normal" pdfFontName="VERDANA.TTF" size="7"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{stampDuty}]]></textFieldExpression>

</textField>

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

mode="Opaque"

x="354"

y="1"

width="54"

height="12"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font reportFont="Verdana_Normal" pdfFontName="VERDANA.TTF" size="7"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{finalPayable}]]></textFieldExpression>

</textField>

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

mode="Opaque"

x="411"

y="1"

width="48"

height="12"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font reportFont="Verdana_Normal" pdfFontName="VERDANA.TTF" size="7"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{br}]]></textFieldExpression>

</textField>

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

mode="Opaque"

x="462"

y="1"

width="53"

height="12"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font reportFont="Verdana_Normal" pdfFontName="VERDANA.TTF" size="7"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{tax}]]></textFieldExpression>

</textField>

<line direction="BottomUp">

<reportElement

mode="Opaque"

x="299"

y="0"

width="0"

height="14"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(!(new String($F{totalFlag}).equalsIgnoreCase("TOTAL")))]]></printWhenExpression>

</reportElement>

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

</line>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="250"

y="0"

width="0"

height="14"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(!(new String($F{totalFlag}).equalsIgnoreCase("TOTAL")))]]></printWhenExpression>

</reportElement>

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

</line>

<line direction="BottomUp">

<reportElement

mode="Opaque"

x="352"

y="0"

width="0"

height="14"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(!(new String($F{totalFlag}).equalsIgnoreCase("TOTAL")))]]></printWhenExpression>

</reportElement>

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

</line>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="409"

y="0"

width="0"

height="14"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(!(new String($F{totalFlag}).equalsIgnoreCase("TOTAL")))]]></printWhenExpression>

</reportElement>

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

</line>

<line direction="BottomUp">

<reportElement

mode="Opaque"

x="460"

y="0"

width="0"

height="14"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(!(new String($F{totalFlag}).equalsIgnoreCase("TOTAL")))]]></printWhenExpression>

</reportElement>

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

</line>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="4"

y="13"

width="513"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(!(new String($F{totalFlag}).equalsIgnoreCase("TOTAL")))]]></printWhenExpression>

</reportElement>

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

</line>

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

mode="Transparent"

x="520"

y="4"

width="12"

height="6"

forecolor="#FFFFFF"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font fontName="SansSerif" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{totalFlag}]]></textFieldExpression>

</textField>

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="4"

y="0"

width="55"

height="14"

forecolor="#000000"

backcolor="#E9F5F0"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(new String($F{totalFlag}).equalsIgnoreCase("TOTAL"))]]></printWhenExpression>

</reportElement>

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

</rectangle>

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="58"

y="0"

width="50"

height="14"

forecolor="#000000"

backcolor="#E9F5F0"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(new String($F{totalFlag}).equalsIgnoreCase("TOTAL"))]]></printWhenExpression>

</reportElement>

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

</rectangle>

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

mode="Transparent"

x="5"

y="1"

width="51"

height="11"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(new String($F{totalFlag}).equalsIgnoreCase("TOTAL"))]]></printWhenExpression>

</reportElement>

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

<font reportFont="Verdana_Bold" pdfFontName="VERDANAB.TTF" size="7"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{deductibleOption}]]></textFieldExpression>

</textField>

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

mode="Transparent"

x="59"

y="1"

width="47"

height="11"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(new String($F{totalFlag}).equalsIgnoreCase("TOTAL"))]]></printWhenExpression>

</reportElement>

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

<font reportFont="Verdana_Bold" pdfFontName="VERDANAB.TTF" size="7"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{product}]]></textFieldExpression>

</textField>

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="107"

y="0"

width="52"

height="14"

forecolor="#000000"

backcolor="#E9F5F0"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(new String($F{totalFlag}).equalsIgnoreCase("TOTAL"))]]></printWhenExpression>

</reportElement>

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

</rectangle>

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

mode="Transparent"

x="108"

y="1"

width="47"

height="11"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(new String($F{totalFlag}).equalsIgnoreCase("TOTAL"))]]></printWhenExpression>

</reportElement>

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

<font reportFont="Verdana_Bold" pdfFontName="VERDANAB.TTF" size="7"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{premiumRate}]]></textFieldExpression>

</textField>

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="158"

y="0"

width="53"

height="14"

forecolor="#000000"

backcolor="#E9F5F0"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(new String($F{totalFlag}).equalsIgnoreCase("TOTAL"))]]></printWhenExpression>

</reportElement>

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

</rectangle>

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="210"

y="0"

width="41"

height="14"

forecolor="#000000"

backcolor="#E9F5F0"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(new String($F{totalFlag}).equalsIgnoreCase("TOTAL"))]]></printWhenExpression>

</reportElement>

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

</rectangle>

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="250"

y="0"

width="50"

height="14"

forecolor="#000000"

backcolor="#E9F5F0"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(new String($F{totalFlag}).equalsIgnoreCase("TOTAL"))]]></printWhenExpression>

</reportElement>

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

</rectangle>

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="299"

y="0"

width="54"

height="14"

forecolor="#000000"

backcolor="#E9F5F0"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[new Boolean(new String($F{totalFlag}).equalsIgnoreCase("TOTAL"))]]></printWhenExpres