<?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="TEST" 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="CODEID" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["CODE"]]></defaultValueExpression> </parameter> <parameter name="DESCRIPTION" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["DESCRIPTION"]]></defaultValueExpression> </parameter> <parameter name="CLASSNAME" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["CLASSNAME"]]></defaultValueExpression> </parameter> <parameter name="REPORTHEADER" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> <defaultValueExpression><![CDATA["รายงานทะเบียนประเภทบริษัท"]]></defaultValueExpression> </parameter> <parameter name="COMPANY" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> <defaultValueExpression><![CDATA["CSC"]]></defaultValueExpression> </parameter> <parameter name="TOTAL" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["TOTAL"]]></defaultValueExpression> </parameter> <parameter name="CODE" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["CODE(S)"]]></defaultValueExpression> </parameter> <parameter name="APPRISAL" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["APPRISAL"]]></defaultValueExpression> </parameter> <parameter name="SCREEN" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> <defaultValueExpression><![CDATA["CS008"]]></defaultValueExpression> </parameter> <parameter name="TYPE" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["TYPE"]]></defaultValueExpression> </parameter> <parameter name="MYGRAPH" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["../../chart/apprisal/test_rep21.jsp?graphid='ASR08000000001'"]]></defaultValueExpression> </parameter> <parameter name="PAGE" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["PAGE"]]></defaultValueExpression> </parameter> <parameter name="RECORDS" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["RECORD(S)"]]></defaultValueExpression> </parameter> <parameter name="FROM" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["FROM"]]></defaultValueExpression> </parameter> <parameter name="GRAPH" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["GRAPH"]]></defaultValueExpression> </parameter> <parameter name="YEARID" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["YEARID"]]></defaultValueExpression> </parameter> <parameter name="MONTHID" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["MONTHID"]]></defaultValueExpression> </parameter> <parameter name="EMPLOYEE_CODE" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["EMPLOYEEID"]]></defaultValueExpression> </parameter> <parameter name="CARCODE" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["CARCODE"]]></defaultValueExpression> </parameter> <parameter name="CARID" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["CARID"]]></defaultValueExpression> </parameter> <parameter name="OILTYPE" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["OILTYPE"]]></defaultValueExpression> </parameter> <parameter name="LPT" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["LPT"]]></defaultValueExpression> </parameter> <parameter name="OILAMOUNT" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["OILAMOUNT"]]></defaultValueExpression> </parameter> <parameter name="LANG" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[lang]]></parameterDescription> <defaultValueExpression><![CDATA["LANG"]]></defaultValueExpression> </parameter> <parameter name="EMPID" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression><![CDATA["EMPID"]]></defaultValueExpression> </parameter> <field name="memployee__fullname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__fullname]]></fieldDescription> </field> <field name="mcar__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MCAR__COMPANYID]]></fieldDescription> </field> <field name="mcar__oiltype" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MCAR__OILTYPE]]></fieldDescription> </field> <field name="mcar__model" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MCAR__MODEL]]></fieldDescription> </field> <field name="mcar__brand" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MCAR__BRAND]]></fieldDescription> </field> <field name="mcar__carid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MCAR__CARID]]></fieldDescription> </field> <field name="mprovince__long_ename" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MPROVINCE__LONG_ENAME]]></fieldDescription> </field> <field name="mprovince__long_tname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MPROVINCE__LONG_TNAME]]></fieldDescription> </field> <field name="mprovince__provinceid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MPROVINCE__PROVINCEID]]></fieldDescription> </field> <field name="csczipcode__province" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by CSCZIPCODE__PROVINCE]]></fieldDescription> </field> <field name="csczipcode__eamphur" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by CSCZIPCODE__EAMPHUR]]></fieldDescription> </field> <field name="csczipcode__tamphur" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by CSCZIPCODE__TAMPHUR]]></fieldDescription> </field> <field name="csczipcode__zipcode" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by CSCZIPCODE__ZIPCODE]]></fieldDescription> </field> <field name="mempl_addr__distance" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__DISTANCE]]></fieldDescription> </field> <field name="mempl_addr__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__COMPANYID]]></fieldDescription> </field> <field name="mempl_addr__zipcode" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__ZIPCODE]]></fieldDescription> </field> <field name="mempl_addr__amphur" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__AMPHUR]]></fieldDescription> </field> <field name="mempl_addr__eaddr" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__EADDR]]></fieldDescription> </field> <field name="mempl_addr__edistrict" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__EDISTRICT]]></fieldDescription> </field> <field name="mempl_addr__evillage" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__EVILLAGE]]></fieldDescription> </field> <field name="mempl_addr__emoo" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__EMOO]]></fieldDescription> </field> <field name="mempl_addr__esoi" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__ESOI]]></fieldDescription> </field> <field name="mempl_addr__eroad" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__EROAD]]></fieldDescription> </field> <field name="mempl_addr__efloor" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__EFLOOR]]></fieldDescription> </field> <field name="mempl_addr__eroom_no" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__EROOM_NO]]></fieldDescription> </field> <field name="mempl_addr__taddr" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__TADDR]]></fieldDescription> </field> <field name="mempl_addr__tdistrict" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__TDISTRICT]]></fieldDescription> </field> <field name="mempl_addr__tvillage" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__TVILLAGE]]></fieldDescription> </field> <field name="mempl_addr__tmoo" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__TMOO]]></fieldDescription> </field> <field name="mempl_addr__tsoi" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__TSOI]]></fieldDescription> </field> <field name="mempl_addr__troad" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__TROAD]]></fieldDescription> </field> <field name="mempl_addr__tfloor" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__TFLOOR]]></fieldDescription> </field> <field name="mempl_addr__troom_no" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__TROOM_NO]]></fieldDescription> </field> <field name="mempl_addr__employeeid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_ADDR__EMPLOYEEID]]></fieldDescription> </field> <field name="memployee__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPLOYEE__COMPANYID]]></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__employeeid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPLOYEE__EMPLOYEEID]]></fieldDescription> </field> <field name="mempl_oil__amount" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_OIL__AMOUNT]]></fieldDescription> </field> <field name="mempl_oil__lpt" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_OIL__LPT]]></fieldDescription> </field> <field name="mempl_oil__carid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_OIL__CARID]]></fieldDescription> </field> <field name="mempl_oil__carcode" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_OIL__CARCODE]]></fieldDescription> </field> <field name="mempl_oil__employeeid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_OIL__EMPLOYEEID]]></fieldDescription> </field> <field name="mempl_oil__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_OIL__COMPANYID]]></fieldDescription> </field> <field name="mempl_oil__monthid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_OIL__MONTHID]]></fieldDescription> </field> <field name="mempl_oil__yearid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by MEMPL_OIL__YEARID]]></fieldDescription> </field> <variable name="TEST" class="java.lang.String" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA["A"]]></variableExpression> <initialValueExpression><![CDATA["A"]]></initialValueExpression> </variable> <group name="empgrp" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" > <groupExpression><![CDATA[$F{memployee__employeeid}]]></groupExpression> <groupHeader> <band height="21" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="2" y="1" width="114" 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{EMPID}+ " " + $F{memployee__employeeid}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="115" y="1" width="375" 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[$F{memployee__fullname}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="24" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="empgrp" hyperlinkType="None" > <reportElement mode="Transparent" x="2" y="2" width="65" 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.Integer"><![CDATA[$V{empgrp_COUNT}]]></textFieldExpression> </textField> </band> </groupFooter> </group> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="105" isSplitAllowed="true" > <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="71" width="531" 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="73" width="531" 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="100" width="531" 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="102" width="531" 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="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="114" y="48" width="278" 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="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="413" y="3" 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="496" y="3" width="39" 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["" + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="114" y="26" width="278" 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="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="114" y="3" width="278" 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{APPRISAL}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="2" y="3" width="212" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="true" 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{SCREEN}+"-"+new com.csc.library.report.ReportUDF().getTimeShort()+"-"+new com.csc.library.report.ReportUDF().getDateShort()]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="2" y="77" width="38" 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{YEARID}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="39" y="77" width="65" 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{MONTHID}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="108" y="77" width="62" 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{CARCODE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="170" y="77" width="144" 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{CARID}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="368" y="77" width="81" 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{LPT}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="450" y="77" width="80" 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{OILAMOUNT}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement mode="Transparent" x="314" y="77" width="50" 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{OILTYPE}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="22" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="2" y="2" width="38" 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[$F{mempl_oil__yearid}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="39" y="2" width="65" 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[$F{mempl_oil__monthid}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="108" y="2" width="62" 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[$F{mempl_oil__carcode}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="170" y="2" width="144" 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[$F{mempl_oil__carid} + " " + $F{mcar__model} + " " + $F{mcar__brand}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="368" y="2" width="81" 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[$F{mempl_oil__lpt}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="450" y="2" width="80" 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[$F{mempl_oil__amount}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="314" y="2" width="50" 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[new com.csc.library.report.ReportUDF().getSystemCode("OILTYPE",$P{LANG},$F{mcar__oiltype})]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="40" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="43" isSplitAllowed="true" > </band> </summary> </jasperReport>