<?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="WELR037_KKB" 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.*" /> <parameter name="REPORTHEADER" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> <defaultValueExpression ><![CDATA["รายงานทะเบียนประเภทบริษัท"]]></defaultValueExpression> </parameter> <parameter name="PAGE" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["PAGE"]]></defaultValueExpression> </parameter> <parameter name="SCREEN" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> <defaultValueExpression ><![CDATA["CS008"]]></defaultValueExpression> </parameter> <parameter name="LANG" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[lang]]></parameterDescription> <defaultValueExpression ><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="NO" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["NO."]]></defaultValueExpression> </parameter> <parameter name="YEAR__T1" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["YEAR"]]></defaultValueExpression> </parameter> <parameter name="YEARS" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> </parameter> <parameter name="MONTH1" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> </parameter> <parameter name="MONTH2" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> </parameter> <parameter name="COSTCENTER__T1" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["COSTCENTER"]]></defaultValueExpression> </parameter> <parameter name="COSTCENTERID" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["COSTCENTERID"]]></defaultValueExpression> </parameter> <parameter name="AMOUNT__T3" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["AMOUNT"]]></defaultValueExpression> </parameter> <parameter name="TOTALCOST__T2" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["TOTAL-COST"]]></defaultValueExpression> </parameter> <parameter name="VAT" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["VAT"]]></defaultValueExpression> </parameter> <parameter name="NET" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["NET"]]></defaultValueExpression> </parameter> <parameter name="TOTALALL__T1" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["TOTALALL"]]></defaultValueExpression> </parameter> <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__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__emp_prefix" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__emp_prefix]]></fieldDescription> </field> <field name="memployee__bu1" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__bu1]]></fieldDescription> </field> <field name="memployee__bu2" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__bu2]]></fieldDescription> </field> <field name="memployee__bu3" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__bu3]]></fieldDescription> </field> <field name="memployee__emp_position" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__emp_position]]></fieldDescription> </field> <field name="memployee__sex" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__sex]]></fieldDescription> </field> <field name="memployee__branch" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__branch]]></fieldDescription> </field> <field name="memployee__emp_group" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__emp_group]]></fieldDescription> </field> <field name="memployee__workarea" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__workarea]]></fieldDescription> </field> <field name="memployee__costcenter" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__costcenter]]></fieldDescription> </field> <field name="mcostcenter0__costcenterid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcostcenter0__costcenterid]]></fieldDescription> </field> <field name="mcostcenter0__tdesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcostcenter0__tdesc]]></fieldDescription> </field> <field name="mcostcenter0__edesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcostcenter0__edesc]]></fieldDescription> </field> <field name="mcostcenter0__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcostcenter0__companyid]]></fieldDescription> </field> <field name="trequis_uniform__years" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by trequis_uniform__years]]></fieldDescription> </field> <field name="trequis_uniform__employeeid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by trequis_uniform__employeeid]]></fieldDescription> </field> <field name="trequis_uniform__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by trequis_uniform__companyid]]></fieldDescription> </field> <field name="trequis_uniform__docno" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by trequis_uniform__docno]]></fieldDescription> </field> <field name="trequis_uniform__uniformgid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by trequis_uniform__uniformgid]]></fieldDescription> </field> <field name="trequis_uniform__uniformtid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by trequis_uniform__uniformtid]]></fieldDescription> </field> <field name="trequis_uniform__uniformid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by trequis_uniform__uniformid]]></fieldDescription> </field> <field name="trequis_uniform__qtyreq" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by trequis_uniform__qtyreq]]></fieldDescription> </field> <field name="trequis_uniform__reqdate" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by trequis_uniform__reqdate]]></fieldDescription> </field> <field name="trequis_uniform__uniformsize" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by trequis_uniform__uniformsize]]></fieldDescription> </field> <field name="muniform__uniformid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by muniform__uniformid]]></fieldDescription> </field> <field name="muniform__tdesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by muniform__tdesc]]></fieldDescription> </field> <field name="muniform__edesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by muniform__edesc]]></fieldDescription> </field> <field name="muniform__unit" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by muniform__unit]]></fieldDescription> </field> <field name="muniform__period" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by muniform__period]]></fieldDescription> </field> <field name="muniform__qty" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by muniform__qty]]></fieldDescription> </field> <field name="muniform__qtytype" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by muniform__qtytype]]></fieldDescription> </field> <field name="muniform__price" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by muniform__price]]></fieldDescription> </field> <field name="muniform__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by muniform__companyid]]></fieldDescription> </field> <field name="memployee__branchname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__branchname]]></fieldDescription> </field> <field name="memployee__fullname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__fullname]]></fieldDescription> </field> <field name="memployee__bu1name" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__bu1name]]></fieldDescription> </field> <field name="memployee__bu2name" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__bu2name]]></fieldDescription> </field> <field name="memployee__bu3name" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__bu3name]]></fieldDescription> </field> <field name="memployee__positionname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__positionname]]></fieldDescription> </field> <variable name="sumreq" class="java.lang.Integer" resetType="Group" resetGroup="coscenter" calculation="Sum"> <variableExpression><![CDATA[Integer.valueOf($F{trequis_uniform__qtyreq})]]></variableExpression> </variable> <variable name="sumreqprice" class="java.lang.Double" resetType="Group" resetGroup="coscenter" calculation="Sum"> <variableExpression><![CDATA[Double.valueOf(Integer.parseInt($F{trequis_uniform__qtyreq})*Double.parseDouble($F{muniform__price}))]]></variableExpression> </variable> <variable name="vats" class="java.lang.Double" resetType="Group" resetGroup="coscenter" calculation="Sum"> <variableExpression><![CDATA[Double.valueOf($V{sumreqprice}.doubleValue()*.07)]]></variableExpression> </variable> <variable name="nets" class="java.lang.Double" resetType="Group" resetGroup="coscenter" calculation="Sum"> <variableExpression><![CDATA[Double.valueOf($V{sumreqprice}.doubleValue()+$V{vats}.doubleValue())]]></variableExpression> </variable> <variable name="countcost" class="java.lang.Integer" resetType="Report" incrementType="Group" incrementGroup="coscenter" calculation="Count"> <variableExpression><![CDATA[$F{memployee__costcenter}]]></variableExpression> </variable> <variable name="sumreqall" class="java.lang.Integer" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[Integer.valueOf($F{trequis_uniform__qtyreq})]]></variableExpression> </variable> <variable name="sumallreqprice" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[Double.valueOf(Integer.parseInt($F{trequis_uniform__qtyreq})*Double.parseDouble($F{muniform__price}))]]></variableExpression> </variable> <variable name="sumallvat" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[Double.valueOf($V{sumreqprice}.doubleValue()*.07)]]></variableExpression> </variable> <variable name="sumallnet" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[Double.valueOf($V{sumreqprice}.doubleValue()+$V{vats}.doubleValue())]]></variableExpression> </variable> <group name="coscenter" > <groupExpression><![CDATA[$F{memployee__costcenter}]]></groupExpression> <groupHeader> <band height="0" isSplitAllowed="true" > </band> </groupHeader> <groupFooter> <band height="20" isSplitAllowed="true" > <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="30" height="20" key="textField" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{countcost}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="30" y="0" width="237" height="20" key="textField" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{mcostcenter0__tdesc}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="267" y="0" width="60" height="20" key="textField" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{memployee__costcenter}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="327" y="0" width="60" height="20" key="textField" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{sumreq}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="387" y="0" width="60" height="20" key="textField" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" rightPadding="5" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{sumreqprice}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="447" y="0" width="60" height="20" key="textField" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" rightPadding="5" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{vats}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="507" y="0" width="60" height="20" key="textField" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" rightPadding="5" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{nets}]]></textFieldExpression> </textField> </band> </groupFooter> </group> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="66" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="444" y="2" width="83" 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="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" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="528" y="2" width="39" 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="14" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="3" y="2" width="100" height="20" forecolor="#000000" backcolor="#FFFFFF" key="textField" isPrintInFirstWholeBand="true"/> <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="14" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{SCREEN}+"-"+new com.csc.library.report.ReportUDF().getTimeShort()+"-"+new com.csc.library.report.ReportUDF().getDateShort()]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="75" y="2" width="416" height="20" key="textField"/> <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="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{REPORTHEADER}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="83" y="22" width="400" height="18" key="textField"/> <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="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{YEAR__T1}+" "+$P{YEARS}+"("+new com.csc.library.utilities.CscCalendar($P{YEARS}+"-"+$P{MONTH1}+"-01").getThaiShortMonth()+"-"+new com.csc.library.utilities.CscCalendar($P{YEARS}+"-"+$P{MONTH2}+"-01").getThaiShortMonth()+")"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Opaque" x="0" y="46" width="30" height="20" backcolor="#CCCCCC" key="textField-1" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{NO}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Opaque" x="30" y="46" width="237" height="20" backcolor="#CCCCCC" key="textField" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{COSTCENTER__T1}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Opaque" x="267" y="46" width="60" height="20" backcolor="#CCCCCC" key="textField" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{COSTCENTERID}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Opaque" x="387" y="46" width="60" height="20" backcolor="#CCCCCC" key="textField" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{TOTALCOST__T2}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Opaque" x="327" y="46" width="60" height="20" backcolor="#CCCCCC" key="textField" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{AMOUNT__T3}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Opaque" x="447" y="46" width="60" height="20" backcolor="#CCCCCC" key="textField" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{VAT}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Opaque" x="507" y="46" width="60" height="20" backcolor="#CCCCCC" key="textField" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{NET}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="0" isSplitAllowed="true" > </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="0" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="20" isSplitAllowed="true" > <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="327" height="20" key="textField-2" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{TOTALALL__T1}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="327" y="0" width="60" height="20" key="textField-5" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{sumreqall}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="387" y="0" width="60" height="20" key="textField-6" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" rightPadding="5" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{sumallreqprice}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="447" y="0" width="60" height="20" key="textField-7" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" rightPadding="5" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{sumallvat}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="507" y="0" width="60" height="20" key="textField-8" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" rightPadding="5" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{sumallnet}]]></textFieldExpression> </textField> </band> </summary> </jasperReport>