1700 lines
66 KiB
XML
1700 lines
66 KiB
XML
<?xml version="1.0" encoding="UTF-8" ?>
|
|
<!-- Created with iReport - A designer for JasperReports -->
|
|
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
|
|
<jasperReport
|
|
name="term_deposit_certificate_ifss"
|
|
columnCount="1"
|
|
printOrder="Vertical"
|
|
orientation="Landscape"
|
|
pageWidth="842"
|
|
pageHeight="842"
|
|
columnWidth="782"
|
|
columnSpacing="0"
|
|
leftMargin="30"
|
|
rightMargin="30"
|
|
topMargin="20"
|
|
bottomMargin="20"
|
|
whenNoDataType="NoDataSection"
|
|
isTitleNewPage="false"
|
|
isSummaryNewPage="false">
|
|
<property name="ireport.scriptlethandling" value="0" />
|
|
<property name="ireport.encoding" value="UTF-8" />
|
|
<import value="java.util.*" />
|
|
<import value="net.sf.jasperreports.engine.*" />
|
|
<import value="net.sf.jasperreports.engine.data.*" />
|
|
|
|
<parameter name="ACCOUNT_NO" isForPrompting="true" class="java.lang.String">
|
|
<defaultValueExpression ><![CDATA[$P{ACCOUNT_NO}]]></defaultValueExpression>
|
|
</parameter>
|
|
<queryString><![CDATA[WITH kyc_primary AS (
|
|
SELECT *
|
|
FROM (
|
|
SELECT k.*,
|
|
ROW_NUMBER() OVER (PARTITION BY k.cif_no ORDER BY k.birth_date DESC) rn
|
|
FROM kyc_hdr k
|
|
)
|
|
WHERE rn = 1
|
|
),
|
|
|
|
joint_pan_split AS (
|
|
SELECT
|
|
da.account_no,
|
|
REGEXP_SUBSTR(REPLACE(da.joint_pan,'#',','),'[^,]+',1,LEVEL) pan,
|
|
LEVEL seq
|
|
FROM dep_account da
|
|
CONNECT BY REGEXP_SUBSTR(REPLACE(da.joint_pan,'#',','),'[^,]+',1,LEVEL) IS NOT NULL
|
|
AND PRIOR da.account_no = da.account_no
|
|
AND PRIOR SYS_GUID() IS NOT NULL
|
|
)
|
|
|
|
SELECT
|
|
|
|
dp.prod_name,
|
|
da.minor_ac,
|
|
|
|
da.term_from_dt,
|
|
da.acct_open_dt,
|
|
|
|
CASE UPPER(da.interest_cap_frequency)
|
|
WHEN 'Q' THEN 'Quarterly'
|
|
WHEN 'M' THEN 'Monthly'
|
|
WHEN 'O' THEN 'On Maturity'
|
|
ELSE 'Not Available'
|
|
END AS interest_cap_frequency,
|
|
|
|
dp.effec_dt,
|
|
dp.intt_rate,
|
|
dp.intt_payout_freq,
|
|
dp.prod_code,
|
|
dp.inst_no,
|
|
|
|
k.customer_name,
|
|
k.birth_date AS dob,
|
|
|
|
k.currentaddress || ',' ||
|
|
k.currentcity || ',' ||
|
|
k.currentdistrict || ',' ||
|
|
k.currentstate || '-' ||
|
|
k.currentpin AS address,
|
|
|
|
k.mobilecode || '-' || k.mobile_no AS mobile,
|
|
|
|
NVL(k.pan,'NA') AS pan,
|
|
NVL(k.aadhaar,'-') AS aadhaar,
|
|
|
|
da.transfer_acc_no AS credit_account_no,
|
|
da.cif_no AS customer_id,
|
|
da.customer_type AS constitution,
|
|
|
|
/* GUARDIAN (only for minor account) */
|
|
CASE
|
|
WHEN da.minor_ac = 'Y' THEN
|
|
(
|
|
SELECT kh.customer_name
|
|
FROM joint_pan_split jp
|
|
JOIN kyc_hdr kh ON kh.pan = jp.pan
|
|
WHERE jp.account_no = da.account_no
|
|
AND jp.seq = 1
|
|
)
|
|
END AS guardian_name,
|
|
|
|
/* JOINT HOLDERS */
|
|
(
|
|
SELECT LISTAGG(kh.customer_name, ', ')
|
|
WITHIN GROUP (ORDER BY jp.seq)
|
|
FROM joint_pan_split jp
|
|
JOIN kyc_hdr kh ON kh.pan = jp.pan
|
|
WHERE jp.account_no = da.account_no
|
|
AND (
|
|
(da.minor_ac = 'Y' AND jp.seq > 1)
|
|
OR (da.minor_ac <> 'Y')
|
|
)
|
|
) AS joint_holder_names,
|
|
|
|
CASE
|
|
WHEN da.term_length IS NOT NULL
|
|
THEN da.term_length || ' MONTHS'
|
|
ELSE 'N/A'
|
|
END AS term_length,
|
|
|
|
da.td_intt_rate AS rate_of_interest,
|
|
da.mat_value AS maturity_amt,
|
|
|
|
CASE
|
|
WHEN da.mat_value IS NOT NULL
|
|
THEN get_words(da.mat_value)
|
|
ELSE 'Not Available'
|
|
END AS maturity_amt_in_words,
|
|
|
|
da.term_value AS deposit_amount,
|
|
da.mat_dt AS date_of_maturity,
|
|
da.intt_projected AS total_interest,
|
|
|
|
da.transfer_bank_name AS bank_name,
|
|
da.transfer_branch_name AS branch,
|
|
da.transfer_ifsc_code AS credit_ifsc,
|
|
da.micr_code AS micr,
|
|
|
|
CASE
|
|
WHEN nd.nominee_relation IS NOT NULL
|
|
THEN nd.nominee_name || ' (' || nd.nominee_relation || ')'
|
|
ELSE nd.nominee_name
|
|
END AS nominee
|
|
|
|
FROM dep_account da
|
|
|
|
JOIN dep_product_new dp
|
|
ON da.dep_prod_id = dp.prod_id
|
|
|
|
JOIN kyc_primary k
|
|
ON da.cif_no = k.cif_no
|
|
|
|
LEFT JOIN nominee_details nd
|
|
ON nd.ref_id = da.nominee_ref_id
|
|
AND da.account_no = nd.account_no
|
|
|
|
WHERE da.account_no = $P{ACCOUNT_NO}]]></queryString>
|
|
|
|
<field name="PROD_NAME" class="java.lang.String"/>
|
|
<field name="MINOR_AC" class="java.lang.String"/>
|
|
<field name="TERM_FROM_DT" class="java.sql.Timestamp"/>
|
|
<field name="ACCT_OPEN_DT" class="java.sql.Timestamp"/>
|
|
<field name="INTEREST_CAP_FREQUENCY" class="java.lang.String"/>
|
|
<field name="EFFEC_DT" class="java.sql.Timestamp"/>
|
|
<field name="INTT_RATE" class="java.math.BigDecimal"/>
|
|
<field name="INTT_PAYOUT_FREQ" class="java.lang.String"/>
|
|
<field name="PROD_CODE" class="java.lang.String"/>
|
|
<field name="INST_NO" class="java.lang.String"/>
|
|
<field name="CUSTOMER_NAME" class="java.lang.String"/>
|
|
<field name="DOB" class="java.sql.Timestamp"/>
|
|
<field name="ADDRESS" class="java.lang.String"/>
|
|
<field name="MOBILE" class="java.lang.String"/>
|
|
<field name="PAN" class="java.lang.String"/>
|
|
<field name="AADHAAR" class="java.lang.String"/>
|
|
<field name="CREDIT_ACCOUNT_NO" class="java.lang.String"/>
|
|
<field name="CUSTOMER_ID" class="java.lang.String"/>
|
|
<field name="CONSTITUTION" class="java.lang.String"/>
|
|
<field name="GUARDIAN_NAME" class="java.lang.String"/>
|
|
<field name="JOINT_HOLDER_NAMES" class="java.lang.String"/>
|
|
<field name="TERM_LENGTH" class="java.lang.String"/>
|
|
<field name="RATE_OF_INTEREST" class="java.math.BigDecimal"/>
|
|
<field name="MATURITY_AMT" class="java.math.BigDecimal"/>
|
|
<field name="MATURITY_AMT_IN_WORDS" class="java.lang.String"/>
|
|
<field name="DEPOSIT_AMOUNT" class="java.math.BigDecimal"/>
|
|
<field name="DATE_OF_MATURITY" class="java.sql.Timestamp"/>
|
|
<field name="TOTAL_INTEREST" class="java.math.BigDecimal"/>
|
|
<field name="BANK_NAME" class="java.lang.String"/>
|
|
<field name="BRANCH" class="java.lang.String"/>
|
|
<field name="CREDIT_IFSC" class="java.lang.String"/>
|
|
<field name="MICR" class="java.lang.String"/>
|
|
<field name="NOMINEE" class="java.lang.String"/>
|
|
|
|
<variable name="current_datetime" class="java.util.Date" resetType="Report" calculation="Nothing">
|
|
<variableExpression><![CDATA[new java.util.Date()]]></variableExpression>
|
|
</variable>
|
|
<background>
|
|
<band height="0" isSplitAllowed="true" >
|
|
</band>
|
|
</background>
|
|
<title>
|
|
<band height="110" isSplitAllowed="true" >
|
|
<staticText>
|
|
<reportElement
|
|
x="199"
|
|
y="23"
|
|
width="432"
|
|
height="15"
|
|
key="staticText-2"/>
|
|
<box></box>
|
|
<textElement textAlignment="Center">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[(A Government of Tamil Nadu Enterprise)]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
x="96"
|
|
y="38"
|
|
width="657"
|
|
height="18"
|
|
key="staticText-9"/>
|
|
<box></box>
|
|
<textElement textAlignment="Center">
|
|
<font pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Regd.Office: "Tufidco-Powerfin Tower", 490/3-4, Anna Salai, Nandanam, Chennai-600035]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
x="198"
|
|
y="56"
|
|
width="432"
|
|
height="17"
|
|
key="staticText-10"/>
|
|
<box></box>
|
|
<textElement textAlignment="Center">
|
|
<font pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Phone: 044-4631 2345 Fax: 044 24329914]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
x="99"
|
|
y="76"
|
|
width="651"
|
|
height="26"
|
|
key="staticText-11"/>
|
|
<box></box>
|
|
<textElement textAlignment="Justified">
|
|
<font pdfFontName="Helvetica-Bold" size="18" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[ DEPOSIT CONFIRMATION]]></text>
|
|
</staticText>
|
|
<line direction="TopDown">
|
|
<reportElement
|
|
x="100"
|
|
y="73"
|
|
width="646"
|
|
height="1"
|
|
forecolor="#000000"
|
|
key="line-1"/>
|
|
<graphicElement stretchType="NoStretch"/>
|
|
</line>
|
|
<staticText>
|
|
<reportElement
|
|
x="96"
|
|
y="-1"
|
|
width="657"
|
|
height="22"
|
|
forecolor="#0B1F4D"
|
|
key="staticText-1"/>
|
|
<box></box>
|
|
<textElement textAlignment="Center">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="18" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Tamil Nadu Power Finance and Infrastructure Development Corporation Limited]]></text>
|
|
</staticText>
|
|
<line direction="TopDown">
|
|
<reportElement
|
|
x="63"
|
|
y="77"
|
|
width="718"
|
|
height="1"
|
|
forecolor="#003366"
|
|
key="line-7"/>
|
|
<graphicElement stretchType="NoStretch"/>
|
|
</line>
|
|
<line direction="TopDown">
|
|
<reportElement
|
|
x="199"
|
|
y="97"
|
|
width="432"
|
|
height="0"
|
|
forecolor="#000000"
|
|
key="line-8"/>
|
|
<graphicElement stretchType="NoStretch"/>
|
|
</line>
|
|
</band>
|
|
</title>
|
|
<pageHeader>
|
|
<band height="0" isSplitAllowed="true" >
|
|
</band>
|
|
</pageHeader>
|
|
<columnHeader>
|
|
<band height="0" isSplitAllowed="true" >
|
|
</band>
|
|
</columnHeader>
|
|
<detail>
|
|
<band height="498" isSplitAllowed="true" >
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="1"
|
|
width="110"
|
|
height="21"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-15"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Product Name]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="25"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-16"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Product Code]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="51"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-17"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Customer ID]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="77"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-18"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Constitution]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="103"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-19"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Name]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="129"
|
|
width="110"
|
|
height="50"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-22"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Address]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="182"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-23"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Nominee]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="269"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-28"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Credit Account]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="296"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-29"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Credit Bank]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="323"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-30"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Credit Branch]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="351"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-31"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Credit IFSC]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="378"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-32"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[MICR]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="400"
|
|
width="110"
|
|
height="52"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-33"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Maturity Amount In Words]]></text>
|
|
</staticText>
|
|
<line direction="TopDown">
|
|
<reportElement
|
|
x="400"
|
|
y="0"
|
|
width="1"
|
|
height="481"
|
|
key="line-2"/>
|
|
<graphicElement stretchType="NoStretch"/>
|
|
</line>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="1"
|
|
width="110"
|
|
height="21"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-34"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[PAN]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="26"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-35"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Date Of Birth]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="53"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-36"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Mobile]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="79"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-37"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Aadhaar]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="211"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-38"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Effective Date]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="265"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-39"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Deposit Amount]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="292"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-40"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Rate Of Interest]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="319"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-41"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Period]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="346"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-42"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Date Of Maturity]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="373"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-43"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Maturity Amount]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="456"
|
|
width="110"
|
|
height="25"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-45"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Total Interest]]></text>
|
|
</staticText>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="130"
|
|
y="2"
|
|
width="260"
|
|
height="20"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{PROD_NAME} != null ?$F{PROD_NAME}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="212"
|
|
width="240"
|
|
height="20"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{EFFEC_DT} == null ? "NA" : new java.text.SimpleDateFormat("dd/MM/yyyy").format($F{EFFEC_DT})]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="130"
|
|
y="103"
|
|
width="260"
|
|
height="23"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{CUSTOMER_NAME} != null ?$F{CUSTOMER_NAME}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="130"
|
|
y="129"
|
|
width="260"
|
|
height="50"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{ADDRESS} != null ?$F{ADDRESS}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="1"
|
|
width="240"
|
|
height="20"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{PAN} != null ? $F{PAN}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="130"
|
|
y="271"
|
|
width="262"
|
|
height="21"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{CREDIT_ACCOUNT_NO} != null ?$F{CREDIT_ACCOUNT_NO}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" pattern="##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="319"
|
|
width="239"
|
|
height="23"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{TERM_LENGTH}!= null ? $F{TERM_LENGTH}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="131"
|
|
y="297"
|
|
width="263"
|
|
height="22"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{BANK_NAME} != null ?$F{BANK_NAME}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="131"
|
|
y="324"
|
|
width="261"
|
|
height="22"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{BRANCH} != null ?$F{BRANCH}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="131"
|
|
y="378"
|
|
width="262"
|
|
height="23"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{MICR} != null ?$F{MICR}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="53"
|
|
width="240"
|
|
height="20"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{MOBILE} != null ? $F{MOBILE}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="130"
|
|
y="182"
|
|
width="260"
|
|
height="21"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMINEE} != null ?$F{NOMINEE}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" pattern="##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="374"
|
|
width="240"
|
|
backcolor="#EAFBF3"
|
|
height="22"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{MATURITY_AMT} != null ? $F{MATURITY_AMT}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" pattern="##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="292"
|
|
width="240"
|
|
backcolor="#EAFBF3"
|
|
height="20"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{RATE_OF_INTEREST} != null ? $F{RATE_OF_INTEREST}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="26"
|
|
width="240"
|
|
height="20"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{DOB} == null ? "NA" : new java.text.SimpleDateFormat("dd/MM/yyyy").format($F{DOB})]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="130"
|
|
y="51"
|
|
width="260"
|
|
height="23"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{CUSTOMER_ID} != null ?$F{CUSTOMER_ID}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="131"
|
|
y="352"
|
|
width="262"
|
|
height="20"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{CREDIT_IFSC} != null ?$F{CREDIT_IFSC}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="130"
|
|
y="77"
|
|
width="260"
|
|
height="23"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{CONSTITUTION} != null ?$F{CONSTITUTION}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" pattern="##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="265"
|
|
width="240"
|
|
backcolor="#EAFBF3"
|
|
height="20"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{DEPOSIT_AMOUNT} != null ? $F{DEPOSIT_AMOUNT}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="346"
|
|
width="240"
|
|
height="23"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{DATE_OF_MATURITY} == null ? "NA" : new java.text.SimpleDateFormat("dd/MM/yyyy").format($F{DATE_OF_MATURITY})]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" pattern="##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="456"
|
|
width="240"
|
|
backcolor="#EAFBF3"
|
|
height="25"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{TOTAL_INTEREST} != null ? $F{TOTAL_INTEREST}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="400"
|
|
width="240"
|
|
height="52"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="10"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{MATURITY_AMT_IN_WORDS} != null ?$F{MATURITY_AMT_IN_WORDS}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="105"
|
|
width="110"
|
|
height="29"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-50"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Guardian's Name]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="138"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-51"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Minor Account]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="165"
|
|
width="110"
|
|
height="42"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-52"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Joint Holder's Name]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="208"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-53"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Term From Date]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="235"
|
|
width="110"
|
|
height="30"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-54"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Account Open Date]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="405"
|
|
width="110"
|
|
height="36"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-55"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Interest Capital Frequency]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="445"
|
|
width="110"
|
|
height="36"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-56"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Interest Payout Frequency]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="410"
|
|
y="238"
|
|
width="110"
|
|
height="23"
|
|
backcolor="#DCE6F1"
|
|
key="staticText-57"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Tahoma" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Inst Number]]></text>
|
|
</staticText>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="130"
|
|
y="25"
|
|
width="260"
|
|
height="23"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{PROD_CODE} != null ?$F{PROD_CODE}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="130"
|
|
y="207"
|
|
width="260"
|
|
height="24"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{TERM_FROM_DT} == null ? "NA" : new java.text.SimpleDateFormat("dd/MM/yyyy").format($F{TERM_FROM_DT})]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="130"
|
|
y="235"
|
|
width="260"
|
|
height="32"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{ACCT_OPEN_DT} == null ? "NA" : new java.text.SimpleDateFormat("dd/MM/yyyy").format($F{ACCT_OPEN_DT})]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="130"
|
|
y="405"
|
|
width="262"
|
|
height="36"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{INTEREST_CAP_FREQUENCY} != null ?$F{INTEREST_CAP_FREQUENCY}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="130"
|
|
y="445"
|
|
width="260"
|
|
height="36"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{INTT_PAYOUT_FREQ} != null ?$F{INTT_PAYOUT_FREQ}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="79"
|
|
width="240"
|
|
height="23"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{AADHAAR} != null ?$F{AADHAAR}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="105"
|
|
width="240"
|
|
height="29"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{GUARDIAN_NAME} != null ?$F{GUARDIAN_NAME}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="138"
|
|
width="240"
|
|
height="23"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{MINOR_AC} != null ?$F{MINOR_AC}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="165"
|
|
width="240"
|
|
height="42"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{JOINT_HOLDER_NAMES} != null ?$F{JOINT_HOLDER_NAMES}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="530"
|
|
y="237"
|
|
width="240"
|
|
height="24"
|
|
backcolor="#FFFFFF"
|
|
key="textField"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<topPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<leftPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<bottomPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
<rightPen lineWidth="0.35" lineColor="#CBD5E1"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font/>
|
|
</textElement>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{INST_NO} != null ?$F{INST_NO}.toString() : "Not Available"]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
<columnFooter>
|
|
<band height="110" isSplitAllowed="true" >
|
|
<staticText>
|
|
<reportElement
|
|
x="0"
|
|
y="28"
|
|
width="780"
|
|
height="73"
|
|
key="staticText-12"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="1.0" lineStyle="Solid"/>
|
|
<topPen lineWidth="1.0" lineStyle="Solid"/>
|
|
<leftPen lineWidth="1.0" lineStyle="Solid"/>
|
|
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
|
|
<rightPen lineWidth="1.0" lineStyle="Solid"/>
|
|
</box>
|
|
<textElement>
|
|
<font pdfFontName="Helvetica-Bold" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[IMPORTANT:- "As per section 206A introduced by Finance (no. 2) Act 2009 wef 01.04.2010. every person who receives income on which TDS is detuctible shall furnish his PAN, Failing which TDS shall be deducted at the rate of 20% (as against 10% which is existing TDS rate). In case of Domestic deposits and 30.90% in case of NRO deposits". Please further note that in the absence of PAN as per CBDT circular no 03/11. TDS certificate will not be issued. Form 15G/H and other excemtion certificates will be aapplicable. Please rfead for applicability of the TDS and Form 15G/H requirements, for more information log on to :
|
|
https://tnpowerfinance.com/ ]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
x="2"
|
|
y="6"
|
|
width="81"
|
|
height="20"
|
|
key="staticText-13"/>
|
|
<box></box>
|
|
<textElement>
|
|
<font size="12"/>
|
|
</textElement>
|
|
<text><![CDATA[Generated By:]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement
|
|
x="588"
|
|
y="6"
|
|
width="162"
|
|
height="19"
|
|
key="staticText-14"/>
|
|
<box></box>
|
|
<textElement textAlignment="Right">
|
|
<font size="12"/>
|
|
</textElement>
|
|
<text><![CDATA[Authorised Signatory]]></text>
|
|
</staticText>
|
|
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
|
|
<reportElement
|
|
x="140"
|
|
y="7"
|
|
width="110"
|
|
height="20"
|
|
key="textField"/>
|
|
<box></box>
|
|
<textElement textAlignment="Right">
|
|
<font pdfFontName="Helvetica-Bold" isBold="true"/>
|
|
</textElement>
|
|
<textFieldExpression class="java.util.Date"><![CDATA[$V{current_datetime}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</columnFooter>
|
|
<pageFooter>
|
|
<band height="13" isSplitAllowed="true" >
|
|
</band>
|
|
</pageFooter>
|
|
<summary>
|
|
<band height="6" isSplitAllowed="true" >
|
|
</band>
|
|
</summary>
|
|
<noData>
|
|
<band height="41" isSplitAllowed="true" >
|
|
<staticText>
|
|
<reportElement
|
|
mode="Opaque"
|
|
x="10"
|
|
y="2"
|
|
width="760"
|
|
height="39"
|
|
forecolor="#000066"
|
|
backcolor="#CCCCFF"
|
|
key="staticText-49"/>
|
|
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"> <pen lineWidth="1.0" lineStyle="Double" lineColor="#000066"/>
|
|
<topPen lineWidth="1.0" lineStyle="Double" lineColor="#000066"/>
|
|
<leftPen lineWidth="1.0" lineStyle="Double" lineColor="#000066"/>
|
|
<bottomPen lineWidth="1.0" lineStyle="Double" lineColor="#000066"/>
|
|
<rightPen lineWidth="1.0" lineStyle="Double" lineColor="#000066"/>
|
|
</box>
|
|
<textElement textAlignment="Center">
|
|
<font pdfFontName="Helvetica-Bold" size="24" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[NO DATA FOUND]]></text>
|
|
</staticText>
|
|
</band>
|
|
</noData>
|
|
</jasperReport>
|