<?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="PR0002" 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"> <parameter name="VPAGE" isForPrompting="false" class="java.lang.String"> <defaultValueExpression><![CDATA["PR032"]]></defaultValueExpression> </parameter> <parameter name="head1" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["PAYROLL SYSTEM"]]></defaultValueExpression> </parameter> <parameter name="page" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["PAGE"]]></defaultValueExpression> </parameter> <parameter name="ranking" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["RANKING BY BUSINESS UNIT"]]></defaultValueExpression> </parameter> <parameter name="empCode" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["EMP.CODE"]]></defaultValueExpression> </parameter> <parameter name="nameSurname" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["NAME-SURNAME"]]></defaultValueExpression> </parameter> <parameter name="SEVERANGE" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["SEVERANGE"]]></defaultValueExpression> </parameter> <parameter name="record" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["RECORD(S)"]]></defaultValueExpression> </parameter> <parameter name="TOTALBY" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["TOTAL BY"]]></defaultValueExpression> </parameter> <parameter name="COMPANY" isForPrompting="false" 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> <parameter name="UDF1" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> <defaultValueExpression><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="lang" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[lang]]></parameterDescription> <defaultValueExpression><![CDATA["lang"]]></defaultValueExpression> </parameter> <parameter name="TOTAL" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["TOTAL"]]></defaultValueExpression> </parameter> <parameter name="CONTRACT_NO" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["CONTRACT NO"]]></defaultValueExpression> </parameter> <parameter name="TYPE" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label ]]></parameterDescription> <defaultValueExpression><![CDATA["TYPE"]]></defaultValueExpression> </parameter> <parameter name="LOAN_DESC" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["LOAN DESC"]]></defaultValueExpression> </parameter> <parameter name="UDF2" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> <defaultValueExpression><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="UDF3" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> <defaultValueExpression><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="AMOUNT__T4" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["AMOUNT"]]></defaultValueExpression> </parameter> <field name="memployee__fullname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__fullname]]></fieldDescription> </field> <field name="mprefix__edesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mprefix__edesc]]></fieldDescription> </field> <field name="mprefix__tdesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mprefix__tdesc]]></fieldDescription> </field> <field name="mprefix__prefixid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mprefix__prefixid]]></fieldDescription> </field> <field name="memployee__branch" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by Memployee__branch]]></fieldDescription> </field> <field name="memployee__bu5" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by Memployee__bu5]]></fieldDescription> </field> <field name="memployee__bu4" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by Memployee__bu4]]></fieldDescription> </field> <field name="memployee__bu3" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by Memployee__bu3]]></fieldDescription> </field> <field name="memployee__bu2" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by Memployee__bu2]]></fieldDescription> </field> <field name="memployee__bu1" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by Memployee__bu1]]></fieldDescription> </field> <field name="memployee__status" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by Memployee__status]]></fieldDescription> </field> <field name="memployee__elname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by Memployee__elname]]></fieldDescription> </field> <field name="memployee__efname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by Memployee__efname]]></fieldDescription> </field> <field name="memployee__lname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by Memployee__lname]]></fieldDescription> </field> <field name="memployee__fname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by Memployee__fname]]></fieldDescription> </field> <field name="memployee__emp_prefix" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by Memployee__emp_prefix]]></fieldDescription> </field> <field name="memployee__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by Memployee__companyid]]></fieldDescription> </field> <field name="memployee__employeeid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by Memployee__employeeid]]></fieldDescription> </field> <field name="mloan__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mloan__companyid]]></fieldDescription> </field> <field name="mloan__edesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mloan__edesc]]></fieldDescription> </field> <field name="mloan__tdesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mloan__tdesc]]></fieldDescription> </field> <field name="mloan__loanid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mloan__loanid]]></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__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="mempl_loan__payment_formula" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mempl_loan__payment_formula]]></fieldDescription> </field> <field name="mempl_loan__tot_install" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mempl_loan__tot_install]]></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__loanprinciple" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mempl_loan__loanprinciple]]></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__startdate" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mempl_loan__startdate]]></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__employeeid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mempl_loan__employeeid]]></fieldDescription> </field> <field name="tpytran1__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by tpytran1__companyid]]></fieldDescription> </field> <field name="tpytran1__cur_amount" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by tpytran1__cur_amount]]></fieldDescription> </field> <field name="tpytran1__currencyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by tpytran1__currencyid]]></fieldDescription> </field> <field name="tpytran1__formulaid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by tpytran1__formulaid]]></fieldDescription> </field> <field name="tpytran1__employeeid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by tpytran1__employeeid]]></fieldDescription> </field> <field name="tpytran0__netincome" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by TPYTRAN0__NETINCOME]]></fieldDescription> </field> <field name="tpytran0__formulacode" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by TPYTRAN0__FORMULACODE]]></fieldDescription> </field> <field name="tpytran0__remark" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by TPYTRAN0__REMARK]]></fieldDescription> </field> <field name="tpytran0__xml_tax" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by TPYTRAN0__XML_TAX]]></fieldDescription> </field> <field name="tpytran0__cal_soc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by TPYTRAN0__CAL_SOC]]></fieldDescription> </field> <field name="tpytran0__cal_pvf" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by TPYTRAN0__CAL_PVF]]></fieldDescription> </field> <field name="tpytran0__cal_tax" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by TPYTRAN0__CAL_TAX]]></fieldDescription> </field> <field name="tpytran0__gendate" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by TPYTRAN0__GENDATE]]></fieldDescription> </field> <field name="tpytran0__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by TPYTRAN0__COMPANYID]]></fieldDescription> </field> <field name="tpytran0__employeeid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by TPYTRAN0__EMPLOYEEID]]></fieldDescription> </field> <variable name="TOTAL_COMPANY" class="java.lang.Integer" resetType="Report" calculation="Count"> <variableExpression><![CDATA[$F{memployee__employeeid}]]></variableExpression> </variable> <variable name="TOTAL_BRANCH" class="java.lang.Integer" resetType="Group" resetGroup="groupLoan" calculation="Count"> <variableExpression><![CDATA[$F{memployee__employeeid}]]></variableExpression> </variable> <variable name="sumBranchFormu1" class="java.lang.Double" resetType="Group" resetGroup="groupLoan" calculation="Sum"> <variableExpression><![CDATA[Double.valueOf(new com.csc.library.utilities.CheckNull().chkNullString($F{tpytran1__cur_amount},"0"))]]></variableExpression> </variable> <variable name="sumCompanyFormu1" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[Double.valueOf(new com.csc.library.utilities.CheckNull().chkNullString($F{tpytran1__cur_amount},"0"))]]></variableExpression> </variable> <group name="groupLoan" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="true" minHeightToStartNewPage="0" > <groupExpression><![CDATA[$F{mloan__loanid}]]></groupExpression> <groupHeader> <band height="22" isSplitAllowed="true" > <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="1" y="1" width="51" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{mloan__loanid}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="52" y="1" width="126" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{mloan__edesc}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="22" isSplitAllowed="true" > <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="52" y="1" width="75" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{TOTAL}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="groupLoan" hyperlinkType="None" > <reportElement mode="Transparent" x="127" y="1" width="61" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[String.valueOf($V{TOTAL_BRANCH})]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="188" y="1" width="61" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{record}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="groupLoan" hyperlinkType="None" > <reportElement mode="Transparent" x="426" y="1" width="108" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[String.valueOf($V{sumBranchFormu1})]]></textFieldExpression> </textField> </band> </groupFooter> </group> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="142" isSplitAllowed="true" > <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="1" y="116" width="51" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{TYPE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="322" y="116" width="109" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{nameSurname}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="430" y="116" width="105" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{AMOUNT__T4}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="112" width="534" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="114" width="534" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="137" width="534" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="139" width="534" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="6" y="6" width="184" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{VPAGE}+"-"+new com.csc.library.report.ReportUDF().getTimeShort()+"-"+new com.csc.library.report.ReportUDF().getDateShort()]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="431" y="5" width="83" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{page} +" "+ $V{PAGE_NUMBER}+ "/"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="514" y="5" width="17" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[String.valueOf($V{PAGE_NUMBER})]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="144" y="28" width="220" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{head1}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="122" y="48" width="262" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{COMPANY}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="124" y="68" width="263" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{REPORTHEADER}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="124" y="88" width="263" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{UDF1}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="52" y="116" width="94" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{LOAN_DESC}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="146" y="116" width="91" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{CONTRACT_NO}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="236" y="116" width="87" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{empCode}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="false" > </band> </columnHeader> <detail> <band height="21" isSplitAllowed="true" > <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="323" y="1" width="107" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" 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="true" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="431" y="1" width="103" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{tpytran1__cur_amount}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="237" y="1" width="86" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{memployee__employeeid}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="145" y="1" width="91" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" 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> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="0" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="75" isSplitAllowed="true" > <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="1" y="54" width="184" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{VPAGE}+"-"+new com.csc.library.report.ReportUDF().getTimeShort()+"-"+new com.csc.library.report.ReportUDF().getDateShort()]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="1" y="2" width="534" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="1" y="4" width="534" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="1" y="30" width="534" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="1" y="32" width="534" height="0" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="1" y="7" width="75" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{TOTAL}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="76" y="7" width="169" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{COMPANY}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="257" y="7" width="61" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[String.valueOf($V{TOTAL_COMPANY})]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="324" y="7" width="61" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{record}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="426" y="7" width="108" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[String.valueOf($V{sumCompanyFormu1})]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="1" y="34" width="56" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <text><![CDATA[ VERIFY BY :]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="310" y="34" width="56" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <text><![CDATA[ APPROVED BY :]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="57" y="34" width="249" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{UDF2}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="366" y="34" width="168" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{UDF3}]]></textFieldExpression> </textField> </band> </summary> </jasperReport>