<?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="PR030_LOAN_EASYBUY"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="595"
pageHeight="842"
columnWidth="535"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="NoPages"
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="NO" isForPrompting="true" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression ><![CDATA["No."]]></defaultValueExpression>
</parameter>
<parameter name="NO_CONTRACT" isForPrompting="true" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression ><![CDATA["No. Contract"]]></defaultValueExpression>
</parameter>
<parameter name="CUSTOMER_CODE" isForPrompting="true" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression ><![CDATA["Customer Code"]]></defaultValueExpression>
</parameter>
<parameter name="EMP_CODE" isForPrompting="true" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression ><![CDATA["EMP CODE"]]></defaultValueExpression>
</parameter>
<parameter name="NAME_SURNAME" isForPrompting="true" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression ><![CDATA["Name-Surname"]]></defaultValueExpression>
</parameter>
<parameter name="DEPARTMENT__T1" isForPrompting="true" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression ><![CDATA["Department"]]></defaultValueExpression>
</parameter>
<parameter name="PER_MONTH" isForPrompting="true" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression ><![CDATA["Per month"]]></defaultValueExpression>
</parameter>
<parameter name="PERIOD__T1" isForPrompting="true" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression ><![CDATA["Period"]]></defaultValueExpression>
</parameter>
<parameter name="FIRST_MONTH" isForPrompting="true" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression ><![CDATA["First month"]]></defaultValueExpression>
</parameter>
<parameter name="LAST_MONTH__T1" isForPrompting="true" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression ><![CDATA["Last month"]]></defaultValueExpression>
</parameter>
<parameter name="LANG" isForPrompting="true" class="java.lang.String">
<parameterDescription><![CDATA[lang]]></parameterDescription>
<defaultValueExpression ><![CDATA["THA"]]></defaultValueExpression>
</parameter>
<parameter name="TOTAL" isForPrompting="true" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression ><![CDATA["Total"]]></defaultValueExpression>
</parameter>
<parameter name="UDF1" isForPrompting="true" class="java.lang.String">
<parameterDescription><![CDATA[component]]></parameterDescription>
<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
</parameter>
<parameter name="REPORTHEADER" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[component]]></parameterDescription>
<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
</parameter>
<field name="mempl_loan__employeeid" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_loan__employeeid]]></fieldDescription>
</field>
<field name="mempl_loan__companyid" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_loan__companyid]]></fieldDescription>
</field>
<field name="mempl_loan__contractnoid" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_loan__contractnoid]]></fieldDescription>
</field>
<field name="mempl_loan__customerno" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_loan__customerno]]></fieldDescription>
</field>
<field name="mempl_loan__startdate" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_loan__startdate]]></fieldDescription>
</field>
<field name="mempl_loan__enddate" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_loan__enddate]]></fieldDescription>
</field>
<field name="mempl_loan__payment" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_loan__payment]]></fieldDescription>
</field>
<field name="mempl_loan__cur_install" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_loan__cur_install]]></fieldDescription>
</field>
<field name="mempl_loan__status" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_loan__status]]></fieldDescription>
</field>
<field name="mempl_loan__loantype" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_loan__loantype]]></fieldDescription>
</field>
<field name="memployee__employeeid" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__employeeid]]></fieldDescription>
</field>
<field name="memployee__bu2" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__bu2]]></fieldDescription>
</field>
<field name="memployee__branch" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__branch]]></fieldDescription>
</field>
<field name="memployee__emp_prefix" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__emp_prefix]]></fieldDescription>
</field>
<field name="memployee__fname" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__fname]]></fieldDescription>
</field>
<field name="memployee__lname" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__lname]]></fieldDescription>
</field>
<field name="memployee__efname" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__efname]]></fieldDescription>
</field>
<field name="memployee__elname" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__elname]]></fieldDescription>
</field>
<field name="memployee__status" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__status]]></fieldDescription>
</field>
<field name="memployee__emp_position" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__emp_position]]></fieldDescription>
</field>
<field name="memployee__birthday" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__birthday]]></fieldDescription>
</field>
<field name="memployee__companyid" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__companyid]]></fieldDescription>
</field>
<field name="mbu2__bu2id" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mbu2__bu2id]]></fieldDescription>
</field>
<field name="mbu2__tdesc" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mbu2__tdesc]]></fieldDescription>
</field>
<field name="mbu2__edesc" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mbu2__edesc]]></fieldDescription>
</field>
<field name="mbu2__companyid" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mbu2__companyid]]></fieldDescription>
</field>
<field name="mbu2__runno" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mbu2__runno]]></fieldDescription>
</field>
<field name="memployee__fullname" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__fullname]]></fieldDescription>
</field>
<field name="simmempl_loan__loan_amount" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by simmempl_loan__loan_amount]]></fieldDescription>
</field>
<variable name="NO" class="java.lang.Integer" resetType="Report" calculation="Count">
<variableExpression><![CDATA[$F{mempl_loan__employeeid}]]></variableExpression>
</variable>
<variable name="sumLOAN" class="java.lang.Double" resetType="Report" calculation="Sum">
<variableExpression><![CDATA[Double.valueOf(new com.csc.library.utilities.CheckNull().chkNullString($F{simmempl_loan__loan_amount},"0"))]]></variableExpression>
</variable>
<variable name="countEMP" class="java.lang.Integer" resetType="Report" calculation="Count">
<variableExpression><![CDATA[$F{memployee__employeeid}]]></variableExpression>
</variable>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="0" isSplitAllowed="true" >
</band>
</title>
<pageHeader>
<band height="33" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="102"
y="6"
width="280"
height="22"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="18" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{REPORTHEADER}+ " " +$P{UDF1}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="45" isSplitAllowed="true" >
<line direction="TopDown">
<reportElement
mode="Opaque"
x="0"
y="1"
width="535"
height="0"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="0"
y="44"
width="535"
height="0"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="0"
y="1"
width="0"
height="44"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="20"
y="1"
width="0"
height="44"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="89"
y="1"
width="0"
height="44"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="143"
y="1"
width="0"
height="44"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="193"
y="1"
width="0"
height="44"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="379"
y="1"
width="0"
height="44"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="419"
y="1"
width="0"
height="44"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="458"
y="1"
width="0"
height="44"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="496"
y="23"
width="0"
height="22"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="535"
y="1"
width="0"
height="44"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="458"
y="23"
width="77"
height="0"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="1"
y="15"
width="18"
height="16"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{NO}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="22"
y="15"
width="65"
height="16"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{NO_CONTRACT}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="91"
y="15"
width="50"
height="16"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{CUSTOMER_CODE}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="145"
y="15"
width="46"
height="16"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{EMP_CODE}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="213"
y="15"
width="140"
height="16"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{NAME_SURNAME}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="380"
y="15"
width="37"
height="16"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{PER_MONTH}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="420"
y="15"
width="37"
height="16"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{TOTAL}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="465"
y="3"
width="62"
height="16"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{PERIOD__T1}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="460"
y="27"
width="35"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="8" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{FIRST_MONTH}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="498"
y="27"
width="35"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="8" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{LAST_MONTH__T1}]]></textFieldExpression>
</textField>
</band>
</columnHeader>
<detail>
<band height="22" isSplitAllowed="true" >
<line direction="TopDown">
<reportElement
mode="Opaque"
x="0"
y="21"
width="535"
height="0"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="535"
y="0"
width="0"
height="22"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="496"
y="0"
width="0"
height="22"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="458"
y="0"
width="0"
height="22"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="419"
y="0"
width="0"
height="22"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="379"
y="0"
width="0"
height="22"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="193"
y="0"
width="0"
height="22"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="143"
y="0"
width="0"
height="22"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="89"
y="0"
width="0"
height="22"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="20"
y="0"
width="0"
height="22"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="0"
y="0"
width="0"
height="22"
forecolor="#000000"
backcolor="#FFFFFF"
key="line"
stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="Thin" fill="Solid" />
</line>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="22"
y="0"
width="65"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{mempl_loan__contractnoid}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="3"
y="0"
width="14"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$V{countEMP}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="91"
y="0"
width="50"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{mempl_loan__contractnoid}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="145"
y="0"
width="40"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{mempl_loan__employeeid}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="194"
y="0"
width="182"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{memployee__fullname}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="380"
y="0"
width="37"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.Double"><![CDATA[Double.valueOf(new com.csc.library.utilities.CheckNull().chkNullString($F{simmempl_loan__loan_amount},"0"))]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="420"
y="0"
width="37"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.Double"><![CDATA[Double.valueOf(new com.csc.library.utilities.CheckNull().chkNullString($F{simmempl_loan__loan_amount},"0"))]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="460"
y="0"
width="35"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[new com.csc.library.report.ReportUDF().getFullDate($P{LANG},$F{mempl_loan__startdate}).substring(new com.csc.library.report.ReportUDF().getFullDate($P{LANG},$F{mempl_loan__startdate}).indexOf(" ")+1)]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="498"
y="0"
width="35"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[new com.csc.library.report.ReportUDF().getFullDate($P{LANG},$F{mempl_loan__enddate}).substring(new com.csc.library.report.ReportUDF().getFullDate($P{LANG},$F{mempl_loan__enddate}).indexOf(" ")+1)]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="0" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="0" isSplitAllowed="true" >
</band>
</pageFooter>
<summary>
<band height="23" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="3"
y="3"
width="33"
height="16"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{TOTAL}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="379"
y="3"
width="38"
height="16"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.Double"><![CDATA[$V{sumLOAN}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="421"
y="3"
width="38"
height="16"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.Double"><![CDATA[$V{sumLOAN}]]></textFieldExpression>
</textField>
</band>
</summary>
</jasperReport>