Dear Experts,
i developed a pdf report using jasperreports . in this reports i used a query string where dont have any parameter, now i want to add a parameter between querystring. how can i do this?? (i know another solution and that is using jrDatasource) in this context i dont want to do this beacuse then i have to do it again from begining.
here is my XML FILE
i just want to add a parameter in querysting
like
<queryString><![CDATA[SELECT CH_RECORD_ID,FH_PRODUCT_ID,
CH_SEQUENCE_NO FROM TABLE_NAE WHERE ID='<![CDATA[$P{CH_FULL_NAME}]]>'
can i do this or how can i do this
<?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="Statement"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="612"
pageHeight="864"
columnWidth="612"
columnSpacing="0"
leftMargin="0"
rightMargin="0"
topMargin="0"
bottomMargin="0"
whenNoDataType="BlankPage"
isTitleNewPage="true"
isSummaryNewPage="false">
<queryString><![CDATA[SELECT CH_RECORD_ID,FH_PRODUCT_ID,
CH_SEQUENCE_NO,
CH_CUSTOMER_NO,
CH_FULL_NAME,
CH_COMPANY_NAME,
CH_ADDR1 as ADD1,
CH_ADDR2 as ADD2,
CH_CITY,
CH_STATE,
CH_CNTRY,
CH_POSTCODE,
CH_STMT_DATE,
CH_STMT_END_DATE,
CH_PAYDUE_DATE,
CH_COMBINE_LIMIT,
CH_BARCODED_COMBINE_LIMIT,
AH_RECORD_ID,
AH_SEQUENCE_NO,
AH_CARDHOLDER_NO,
AH_CARD_DESC,
AH_CARD_DESC2,
AH_BILLING_CURR_CD,
AH_OUTSTD_BAL,
AH_OUTSTD_BAL_S,
AH_MIN_PMT,
AH_BPON_OPEN,
AH_BPNT_EARN,
AH_BPNT_EARN_S,
AH_BPNT_MGM,
AH_BPNT_MGM_S,
AH_BPNT_REDEEM,
AH_BPNT_REDEEM_S,
AH_BPNT_EXPIRY_MTH,
AH_BPNT_EXPIRY_MTH_S,
AH_BPNT_CLOSE,
AH_BPNT_EXPIRY,
AH_BPNT_EXP_DATE,
AH_REWARDS_IND,
AH_LINE_LIMIT,
AH_AVAIL_LIMIT,
AH_AVAIL_LIMIT_S,
AH_AVAIL_CASH_LIMIT,
AH_AVAIL_CASH_LIMIT_S,
TD_RECORD_ID,
TD_RECORD_TAG,
TD_CARDHOLDER_NO,
TD_CARDHOLDER_NAME,
TD_BILLING_CURR_CD,
TD_BAS_SUPP_IND,
if(TD_TRXN_DATE="00000000",' ',TD_TRXN_DATE) as TD_TRXN_DATE,
if(TD_POST_DATE="00000000",' ',TD_POST_DATE) as TD_POST_DATE ,
TD_DESCRIPTION,
TD_AMOUNT,
TD_AMOUNT_S,
TD_CARD_LIMIT FROM CUSTOMER_HEADER,
ACCOUNT_HEADER, TRANSACTION_DETAIL,FILE_HEADER
WHERE
CH_RECORD_ID = AH_RECORD_ID AND
AH_RECORD_ID = TD_RECORD_ID AND
AH_BILLING_CURR_CD = TD_BILLING_CURR_CD AND
TD_DESCRIPTION!='SUB TOTAL'
ORDER BY CH_RECORD_ID,
AH_BILLING_CURR_CD,
TD_BILLING_CURR_CD,
TD_RECORD_TAG, TD_POST_DATE]]></queryString>
<field name="ADD1" class="java.lang.String"/>
<field name="ADD2" class="java.lang.String"/>
<field name="AH_AVAIL_CASH_LIMIT" class="java.lang.String"/>
<field name="AH_AVAIL_CASH_LIMIT_S" class="java.lang.String"/>
<field name="AH_AVAIL_LIMIT" class="java.lang.String"/>
<field name="AH_AVAIL_LIMIT_S" class="java.lang.String"/>
<field name="AH_BILLING_CURR_CD" class="java.lang.String"/>
<field name="AH_BPNT_CLOSE" class="java.lang.String"/>
<field name="AH_BPNT_EARN" class="java.lang.String"/>
<field name="AH_BPNT_EARN_S" class="java.lang.String"/>
<field name="AH_BPNT_EXPIRY" class="java.lang.String"/>
<field name="AH_BPNT_EXPIRY_MTH" class="java.lang.String"/>
<field name="AH_BPNT_EXPIRY_MTH_S" class="java.lang.String"/>
<field name="AH_BPNT_EXP_DATE" class="java.lang.String"/>
<field name="AH_BPNT_MGM" class="java.lang.String"/>
<field name="AH_BPNT_MGM_S" class="java.lang.String"/>
<field name="AH_BPNT_REDEEM" class="java.lang.String"/>
<field name="AH_BPNT_REDEEM_S" class="java.lang.String"/>
<field name="AH_BPON_OPEN" class="java.lang.String"/>
<field name="AH_CARDHOLDER_NO" class="java.lang.String"/>
<field name="AH_CARD_DESC" class="java.lang.String"/>
<field name="AH_CARD_DESC2" class="java.lang.String"/>
<field name="AH_LINE_LIMIT" class="java.lang.String"/>
<field name="AH_MIN_PMT" class="java.lang.String"/>
<field name="AH_OUTSTD_BAL" class="java.lang.String"/>
<field name="AH_OUTSTD_BAL_S" class="java.lang.String"/>
<field name="AH_RECORD_ID" class="java.lang.String"/>
<field name="AH_REWARDS_IND" class="java.lang.String"/>
<field name="AH_SEQUENCE_NO" class="java.lang.String"/>
<field name="CH_BARCODED_COMBINE_LIMIT" class="java.lang.String"/>
<field name="CH_CITY" class="java.lang.String"/>
<field name="CH_CNTRY" class="java.lang.String"/>
<field name="CH_COMBINE_LIMIT" class="java.lang.String"/>
<field name="CH_COMPANY_NAME" class="java.lang.String"/>
<field name="CH_CUSTOMER_NO" class="java.lang.String"/>
<field name="CH_FULL_NAME" class="java.lang.String"/>
<field name="CH_PAYDUE_DATE" class="java.lang.String"/>
<field name="CH_POSTCODE" class="java.lang.String"/>
<field name="CH_RECORD_ID" class="java.lang.String"/>
<field name="CH_SEQUENCE_NO" class="java.lang.String"/>
<field name="CH_STATE" class="java.lang.String"/>
<field name="CH_STMT_DATE" class="java.lang.String"/>
<field name="CH_STMT_END_DATE" class="java.lang.String"/>
<field name="FH_PRODUCT_ID" class="java.lang.String"/>
<field name="TD_AMOUNT" class="java.lang.String"/>
<field name="TD_AMOUNT_S" class="java.lang.String"/>
<field name="TD_BAS_SUPP_IND" class="java.lang.String"/>
<field name="TD_BILLING_CURR_CD" class="java.lang.String"/>
<field name="TD_CARDHOLDER_NAME" class="java.lang.String"/>
<field name="TD_CARDHOLDER_NO" class="java.lang.String"/>
<field name="TD_CARD_LIMIT" class="java.lang.String"/>
<field name="TD_DESCRIPTION" class="java.lang.String"/>
<field name="TD_POST_DATE" class="java.lang.String"/>
<field name="TD_RECORD_ID" class="java.lang.String"/>
<field name="TD_RECORD_TAG" class="java.lang.String"/>
<field name="TD_TRXN_DATE" class="java.lang.String"/>
<group name="Customer_header" isStartNewColumn="false" isStartNewPage="true" isResetPageNumber="true" isReprintHeaderOnEachPage="true" minHeightToStartNewPage="0" >
<groupExpression><![CDATA[$F{CH_RECORD_ID}]]></groupExpression>
<groupHeader>
<band height="208" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="168"
y="84"
width="274"
height="16"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{CH_FULL_NAME}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="168"
y="116"
width="281"
height="14"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{ADD1}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="168"
y="100"
width="179"
height="14"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{CH_COMPANY_NAME}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="239"
y="148"
width="119"
height="14"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{CH_CITY}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="168"
y="148"
width="70"
height="14"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{CH_POSTCODE}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="168"
y="164"
width="201"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{CH_CNTRY}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="29"
y="130"
width="90"
height="14"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{CH_STMT_DATE}.substring(6,8)+"."+$F{CH_STMT_DATE}.substring(4,6)+"."+$F{CH_STMT_DATE}.substring(0,4)]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="470"
y="130"
width="81"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{CH_PAYDUE_DATE}.substring(6,8)+"."+$F{CH_PAYDUE_DATE}.substring(4,6)+"."+$F{CH_PAYDUE_DATE}.substring(0,4)]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="476"
y="67"
width="46"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{FH_PRODUCT_ID}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="168"
y="132"
width="236"
height="14"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{ADD2}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="529"
y="67"
width="28"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{CH_RECORD_ID}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
<groupFooter>
<band height="0" isSplitAllowed="true" >
</band>
</groupFooter>
</group>
<group name="Account_Header" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="true" isReprintHeaderOnEachPage="true" minHeightToStartNewPage="0" >
<groupExpression><![CDATA[$F{AH_BILLING_CURR_CD}]]></groupExpression>
<groupHeader>
<band height="175" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="12"
y="16"
width="156"
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="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{AH_CARDHOLDER_NO}.substring(0,4)+" "+$F{AH_CARDHOLDER_NO}.substring(4,8)+" "+$F{AH_CARDHOLDER_NO}.substring(8,12)+" "+$F{AH_CARDHOLDER_NO}.substring(12,16)]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="226"
y="16"
width="84"
height="15"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Right" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{AH_OUTSTD_BAL}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="417"
y="16"
width="90"
height="15"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Right" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{AH_MIN_PMT}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="0"
y="95"
width="128"
height="14"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{AH_CARDHOLDER_NO}.substring(0,4)+" "+$F{AH_CARDHOLDER_NO}.substring(4,8)+" "+$F{AH_CARDHOLDER_NO}.substring(8,12)+" "+$F{AH_CARDHOLDER_NO}.substring(12,16)]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="191"
y="95"
width="216"
height="14"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{CH_FULL_NAME}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="517"
y="95"
width="35"
height="14"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="9"
y="134"
width="72"
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="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{CH_STMT_DATE}.substring(6,8)+"."+$F{CH_STMT_DATE}.substring(4,6)+"."+$F{CH_STMT_DATE}.substring(0,4)]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="123"
y="135"
width="69"
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="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{CH_PAYDUE_DATE}.substring(6,8)+"."+$F{CH_PAYDUE_DATE}.substring(4,6)+"."+$F{CH_PAYDUE_DATE}.substring(0,4)]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="201"
y="135"
width="82"
height="15"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Right" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{AH_LINE_LIMIT}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="332"
y="135"
width="88"
height="15"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Right" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{AH_AVAIL_LIMIT}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="461"
y="136"
width="79"
height="15"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Right" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{AH_AVAIL_CASH_LIMIT}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="284"
y="135"
width="44"
height="15"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["("+$F{AH_BILLING_CURR_CD}+")"]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="421"
y="135"
width="30"
height="15"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{AH_AVAIL_LIMIT_S}.equals("-")?"CR":""]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="541"
y="136"
width="22"
height="15"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{AH_AVAIL_CASH_LIMIT_S}.equals("-")?"CR":""]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="337"
y="16"
width="19"
height="15"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="Float"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{AH_OUTSTD_BAL_S}.equals("-")?"CR":""]]></textFieldExpression>
</textField>
</band>
</groupHeader>
<groupFooter>
<band height="0" isSplitAllowed="true" >
</band>
</groupFooter>
</group>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<