Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

add parameter in jasper report query string

843838Dec 15 2005 — edited May 16 2006
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>
		<                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2006
Added on Dec 15 2005
1 comment
668 views