<?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="PRR113" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="567" columnSpacing="0" leftMargin="14" rightMargin="14" topMargin="14" bottomMargin="14" 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.*" /> <import value="com.csc.library.utilities.*" /> <parameter name="TRAN_DATE" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> <defaultValueExpression ><![CDATA[""]]></defaultValueExpression> </parameter> <field name="tpvf_tran__employeeid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by tpvf_tran__employeeid]]></fieldDescription> </field> <field name="tpvf_tran__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by tpvf_tran__companyid]]></fieldDescription> </field> <field name="tpvf_tran__fundtableid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by tpvf_tran__fundtableid]]></fieldDescription> </field> <field name="tpvf_tran__idmember" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by tpvf_tran__idmember]]></fieldDescription> </field> <field name="tpvf_tran__compamount" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by tpvf_tran__compamount]]></fieldDescription> </field> <field name="tpvf_tran__emplamount" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by tpvf_tran__emplamount]]></fieldDescription> </field> <field name="tpvf_tran__amount" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by tpvf_tran__amount]]></fieldDescription> </field> <field name="mfundtable__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mfundtable__companyid]]></fieldDescription> </field> <field name="mfundtable__fundtableid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mfundtable__fundtableid]]></fieldDescription> </field> <field name="mfundtable__tdesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mfundtable__tdesc]]></fieldDescription> </field> <field name="mfundtable__edesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mfundtable__edesc]]></fieldDescription> </field> <field name="mfundtable__comcode" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mfundtable__comcode]]></fieldDescription> </field> <field name="mfundtable__registerno" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mfundtable__registerno]]></fieldDescription> </field> <field name="memployee__employeeid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__employeeid]]></fieldDescription> </field> <field name="memployee__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__companyid]]></fieldDescription> </field> <field name="memployee__emp_prefix" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__emp_prefix]]></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__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="mprefix__prefixid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mprefix__prefixid]]></fieldDescription> </field> <field name="mprefix__tdesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mprefix__tdesc]]></fieldDescription> </field> <field name="mprefix__edesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mprefix__edesc]]></fieldDescription> </field> <field name="memployee__fullname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__fullname]]></fieldDescription> </field> <variable name="EmpCount" class="java.lang.Integer" resetType="Report" calculation="DistinctCount"> <variableExpression><![CDATA[$F{tpvf_tran__employeeid}]]></variableExpression> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression> </variable> <variable name="SumAmount" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[Double.valueOf($F{tpvf_tran__amount})]]></variableExpression> <initialValueExpression><![CDATA[new Double(0)]]></initialValueExpression> </variable> <variable name="SumEmp" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[Double.valueOf($F{tpvf_tran__emplamount})]]></variableExpression> <initialValueExpression><![CDATA[new Double(0)]]></initialValueExpression> </variable> <variable name="SumCom" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[Double.valueOf($F{tpvf_tran__compamount})]]></variableExpression> <initialValueExpression><![CDATA[new Double(0)]]></initialValueExpression> </variable> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="99" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="480" y="83" width="87" height="16" key="textField-8"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["รวมเงิน "]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="320" y="83" width="80" height="16" key="textField-9"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["เงินสะสม"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="170" y="83" width="150" height="16" key="textField-10"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Left"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" ชื่อ - นามสกุล"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="90" y="83" width="80" height="16" key="textField-11"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["เลขสมาชิก"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="30" y="83" width="60" height="16" key="textField-13"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["รหัสพนักงาน"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="83" width="30" height="16" key="textField-14"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["ลำดับ"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="67" width="567" height="16" key="textField-15"/> <box topBorder="Thin" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["รายละเอียด"]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement x="0" y="65" width="567" height="0" key="line-1"/> <graphicElement stretchType="NoStretch" pen="Thin"/> </line> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="31" width="49" height="16" key="textField-16"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["กองทุนฯ "]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="247" y="31" width="70" height="16" key="textField-17"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["COMP-CODE"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="363" y="31" width="54" height="16" key="textField-18"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["FUND-CODE "]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="487" y="21" width="30" height="16" key="textField-19"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["TIME "]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="487" y="5" width="30" height="16" key="textField-20"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["DATE "]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="5" width="240" height="18" key="textField-21"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="14" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["People's Garment public Company Limited (WPG)"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="517" y="21" width="50" height="16" key="textField-24"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new CscCalendar().getHHMMSS()]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="517" y="5" width="50" height="16" key="textField-25"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new CscCalendar().getDDMMYYYY()]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="49" y="31" width="190" height="16" key="textField-26"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{mfundtable__tdesc}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="317" y="31" width="40" height="16" key="textField-27"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{mfundtable__comcode}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="511" y="66" width="49" height="16" key="textField-28"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[String.valueOf($V{PAGE_NUMBER})]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="481" y="67" width="30" height="16" key="textField-29"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["PAGE : "]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="417" y="31" width="40" height="16" key="textField-36"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{mfundtable__registerno}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="60" y="48" width="100" height="16" key="textField-37"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{TRAN_DATE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="1" y="48" width="59" height="16" key="textField-38"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["วันที่นำส่ง "]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="400" y="83" width="80" height="16" key="textField-39"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["เงินสมทบ"]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="16" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="480" y="0" width="80" height="16" key="textField-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[Double.valueOf($F{tpvf_tran__amount})]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="320" y="0" width="80" height="16" key="textField-2"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[Double.valueOf($F{tpvf_tran__emplamount})]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="170" y="0" width="150" height="16" key="textField-3"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{memployee__fullname}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="90" y="0" width="80" height="16" key="textField-4"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{tpvf_tran__idmember}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="30" y="0" width="60" height="16" key="textField-6"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{tpvf_tran__employeeid}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="30" height="16" key="textField-7"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{EmpCount}.toString()]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="400" y="0" width="80" height="16" key="textField-40"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[Double.valueOf($F{tpvf_tran__compamount})]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="0" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="19" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="13" y="0" width="110" height="16" key="textField-30"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["รวมจำนวนพนักงานทั้งสิ้น"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="123" y="0" width="30" height="16" key="textField-31"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{EmpCount}.toString()]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="153" y="0" width="60" height="16" key="textField-32"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["คน"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="213" y="0" width="107" height="16" key="textField-33"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["รวมเงินสะสม"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="480" y="0" width="80" height="16" key="textField-34"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{SumAmount}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement x="0" y="0" width="567" height="0" key="line-2"/> <graphicElement stretchType="NoStretch" pen="Thin"/> </line> <line direction="TopDown"> <reportElement x="0" y="16" width="567" height="0" key="line-3"/> <graphicElement stretchType="NoStretch" pen="Thin"/> </line> <line direction="TopDown"> <reportElement x="0" y="18" width="567" height="0" key="line-4"/> <graphicElement stretchType="NoStretch" pen="Thin"/> </line> <textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="400" y="0" width="80" height="16" key="textField-41"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{SumCom}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="320" y="0" width="80" height="16" key="textField-42"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{SumEmp}]]></textFieldExpression> </textField> </band> </summary> </jasperReport>