<?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="TRRE024" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="537" columnSpacing="0" leftMargin="29" rightMargin="29" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <parameter name="EXPECT" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["EXPECT"]]></defaultValueExpression> </parameter> <parameter name="EXPECTED" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["EXPECTED"]]></defaultValueExpression> </parameter> <parameter name="TRAININGTOPIC" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["TRAININGTOPIC"]]></defaultValueExpression> </parameter> <parameter name="NAMESURNAME" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["NAME-SURNAME"]]></defaultValueExpression> </parameter> <parameter name="REPORTHEADER" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> </parameter> <parameter name="COMPANY" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> </parameter> <parameter name="LANG" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[lang]]></parameterDescription> <defaultValueExpression ><![CDATA["THA"]]></defaultValueExpression> </parameter> <parameter name="Page" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Page"]]></defaultValueExpression> </parameter> <parameter name="trainingid" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Training ID"]]></defaultValueExpression> </parameter> <parameter name="course" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Course"]]></defaultValueExpression> </parameter> <parameter name="TRAINING" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Training"]]></defaultValueExpression> </parameter> <parameter name="PRINTNAME" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> </parameter> <parameter name="POSITIONNAME" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> </parameter> <parameter name="train" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Train"]]></defaultValueExpression> </parameter> <field name="htrain_referdoc0__referid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by htrain_referdoc0__referid]]></fieldDescription> </field> <field name="htrain_referdoc0__docno" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by htrain_referdoc0__docno]]></fieldDescription> </field> <field name="htrain_referdoc0__refer_docno" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by htrain_referdoc0__refer_docno]]></fieldDescription> </field> <field name="htrain_referdoc0__refer_docdate" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by htrain_referdoc0__refer_docdate]]></fieldDescription> </field> <field name="htrain_referdoc0__refer_appby" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by htrain_referdoc0__refer_appby]]></fieldDescription> </field> <field name="htrain_referdoc0__train_type" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by htrain_referdoc0__train_type]]></fieldDescription> </field> <field name="htrain_referdoc0__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by htrain_referdoc0__companyid]]></fieldDescription> </field> <field name="htraining__trainingid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by htraining__trainingid]]></fieldDescription> </field> <field name="htraining__crsid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by htraining__crsid]]></fieldDescription> </field> <field name="mcourse__crsid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcourse__crsid]]></fieldDescription> </field> <field name="mcourse__crsdesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcourse__crsdesc]]></fieldDescription> </field> <field name="mcourse__crsedesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcourse__crsedesc]]></fieldDescription> </field> <field name="mcourse__crsgid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcourse__crsgid]]></fieldDescription> </field> <field name="mcourse__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcourse__companyid]]></fieldDescription> </field> <variable name="train_no" class="java.lang.Integer" resetType="Group" incrementType="Group" incrementGroup="course" resetGroup="referid" calculation="Count"> <variableExpression><![CDATA[$F{mcourse__crsid}]]></variableExpression> </variable> <group name="referid" isStartNewPage="true" isResetPageNumber="true" > <groupExpression><![CDATA[$F{htrain_referdoc0__referid}]]></groupExpression> <groupHeader> <band height="0" isSplitAllowed="true" > </band> </groupHeader> <groupFooter> <band height="0" isSplitAllowed="true" > </band> </groupFooter> </group> <group name="course" isReprintHeaderOnEachPage="true" > <groupExpression><![CDATA[$F{htraining__crsid}]]></groupExpression> <groupHeader> <band height="20" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Opaque" x="0" y="0" width="30" height="20" forecolor="#000000" backcolor="#FFFFFF" key="textField-179"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[(((String.valueOf($V{train_no}).equals("null"))?0:$V{train_no}.intValue())+1)+"."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Opaque" x="30" y="0" width="507" height="20" forecolor="#000000" backcolor="#FFFFFF" key="textField-180"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#999999"/> <textElement textAlignment="Left" verticalAlignment="Middle" 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{mcourse__crsdesc}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="0" isSplitAllowed="true" > </band> </groupFooter> </group> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="61" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Opaque" x="0" y="0" width="537" height="20" forecolor="#000000" backcolor="#FFFFFF" key="textField-67"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="16" isBold="true" isItalic="false" isUnderline="true" 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" hyperlinkTarget="Self" > <reportElement mode="Opaque" x="0" y="41" width="99" height="20" forecolor="#000000" backcolor="#FFFFFF" key="textField-193"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="false" isItalic="false" isUnderline="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["ฝึกยกระดับฝีมือแรงงาน"]]></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="0" isSplitAllowed="true" > </band> </summary> </jasperReport>