<?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="test08"
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="SCREEN" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[component]]></parameterDescription>
<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
</parameter>
<parameter name="COMPANYSYSTEM" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression><![CDATA["COMPANY SYSTEM"]]></defaultValueExpression>
</parameter>
<parameter name="COMPANY" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[component]]></parameterDescription>
<defaultValueExpression><![CDATA["COMPANY"]]></defaultValueExpression>
</parameter>
<parameter name="REPORTHEADER" isForPrompting="false" 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="CODE" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression><![CDATA["CODE"]]></defaultValueExpression>
</parameter>
<parameter name="DESCRIPTIONTHAI" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression><![CDATA["DESCRIPTION THAI"]]></defaultValueExpression>
</parameter>
<parameter name="DESCRIPTIONENG" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression><![CDATA["DESCRIPTION ENG"]]></defaultValueExpression>
</parameter>
<parameter name="TOTAL" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression><![CDATA["TOTAL"]]></defaultValueExpression>
</parameter>
<parameter name="FROM" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression><![CDATA["FROM"]]></defaultValueExpression>
</parameter>
<parameter name="RECORDS" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression><![CDATA["RECORD(S)"]]></defaultValueExpression>
</parameter>
<parameter name="CERTID" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression><![CDATA["CERTID"]]></defaultValueExpression>
</parameter>
<parameter name="CERTIFICATION" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression><![CDATA["CERTIFICATION"]]></defaultValueExpression>
</parameter>
<parameter name="EXAMDATE" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression><![CDATA["EXAMDATE"]]></defaultValueExpression>
</parameter>
<parameter name="RESULT" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression><![CDATA["CERT-RESULT"]]></defaultValueExpression>
</parameter>
<parameter name="EMPID" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[label]]></parameterDescription>
<defaultValueExpression><![CDATA["EMPID"]]></defaultValueExpression>
</parameter>
<parameter name="LANG" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[lang]]></parameterDescription>
<defaultValueExpression><![CDATA["LANG"]]></defaultValueExpression>
</parameter>
<field name="orderby1desc" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by orderby1desc]]></fieldDescription>
</field>
<field name="orderby1" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by orderby1]]></fieldDescription>
</field>
<field name="memployee__fullname" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__fullname]]></fieldDescription>
</field>
<field name="mcertificate__edesc" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mcertificate__edesc]]></fieldDescription>
</field>
<field name="mcertificate__tdesc" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mcertificate__tdesc]]></fieldDescription>
</field>
<field name="mcertificate__companyid" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mcertificate__companyid]]></fieldDescription>
</field>
<field name="mcertificate__certid" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mcertificate__certid]]></fieldDescription>
</field>
<field name="mprefix__edesc" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mprefix__edesc]]></fieldDescription>
</field>
<field name="mprefix__tdesc" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mprefix__tdesc]]></fieldDescription>
</field>
<field name="mprefix__prefixid" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mprefix__prefixid]]></fieldDescription>
</field>
<field name="mempl_certificate__examdate" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_certificate__examdate]]></fieldDescription>
</field>
<field name="mempl_certificate__expiredate" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_certificate__expiredate]]></fieldDescription>
</field>
<field name="mempl_certificate__result" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_certificate__result]]></fieldDescription>
</field>
<field name="mempl_certificate__other_desc" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_certificate__other_desc]]></fieldDescription>
</field>
<field name="mempl_certificate__other_score" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_certificate__other_score]]></fieldDescription>
</field>
<field name="mempl_certificate__writing" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_certificate__writing]]></fieldDescription>
</field>
<field name="mempl_certificate__reading" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_certificate__reading]]></fieldDescription>
</field>
<field name="mempl_certificate__speak" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_certificate__speak]]></fieldDescription>
</field>
<field name="mempl_certificate__listen" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_certificate__listen]]></fieldDescription>
</field>
<field name="mempl_certificate__companyid" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_certificate__companyid]]></fieldDescription>
</field>
<field name="mempl_certificate__line_no" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_certificate__line_no]]></fieldDescription>
</field>
<field name="mempl_certificate__certid" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_certificate__certid]]></fieldDescription>
</field>
<field name="mempl_certificate__employeeid" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by mempl_certificate__employeeid]]></fieldDescription>
</field>
<field name="memployee__emp_level" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__emp_level]]></fieldDescription>
</field>
<field name="memployee__status" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__status]]></fieldDescription>
</field>
<field name="memployee__elname" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__elname]]></fieldDescription>
</field>
<field name="memployee__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__fname" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__fname]]></fieldDescription>
</field>
<field name="memployee__emp_prefix" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__emp_prefix]]></fieldDescription>
</field>
<field name="memployee__companyid" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__companyid]]></fieldDescription>
</field>
<field name="memployee__employeeid" class="java.lang.String">
<fieldDescription><![CDATA[Field returned by memployee__employeeid]]></fieldDescription>
</field>
<group name="employeeid" isStartNewColumn="false" isStartNewPage="true" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >
<groupExpression><![CDATA[$F{memployee__employeeid}]]></groupExpression>
<groupHeader>
<band height="31" isSplitAllowed="true" >
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="1"
y="7"
width="73"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{EMPID}+" "+$F{memployee__employeeid}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="81"
y="7"
width="292"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{memployee__fullname}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
<groupFooter>
<band height="8" isSplitAllowed="true" >
<line direction="TopDown">
<reportElement
mode="Opaque"
x="0"
y="4"
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>
</band>
</groupFooter>
</group>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="0" isSplitAllowed="true" >
</band>
</title>
<pageHeader>
<band height="102" isSplitAllowed="true" >
<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>
<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>
<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{COMPANYSYSTEM}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="1"
y="75"
width="73"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{CERTID}]]></textFieldExpression>
</textField>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="0"
y="96"
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="98"
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="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="80"
y="75"
width="280"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{CERTIFICATION}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="361"
y="75"
width="103"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{EXAMDATE}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="465"
y="75"
width="65"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{RESULT}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="26" isSplitAllowed="true" >
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="1"
y="2"
width="73"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{mempl_certificate__certid}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="80"
y="2"
width="280"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{mcertificate__tdesc}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="361"
y="2"
width="103"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{mempl_certificate__examdate}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Opaque"
x="465"
y="2"
width="65"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[new com.csc.library.report.ReportUDF().getSystemCode("RESULT",$P{LANG},$F{mempl_certificate__result}) ]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="0" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="29" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Transparent"
x="219"
y="6"
width="49"
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{TOTAL}+" "+$V{REPORT_COUNT}+" "+$P{FROM}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Transparent"
x="269"
y="6"
width="51"
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[" "+$V{REPORT_COUNT}+" "+$P{RECORDS}]]></textFieldExpression>
</textField>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="0"
y="3"
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="1"
y="6"
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="Now" hyperlinkType="None" > <reportElement
mode="Transparent"
x="413"
y="6"
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="6"
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>
</band>
</pageFooter>
<summary>
<band height="40" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement
mode="Transparent"
x="3"
y="7"
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="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{TOTAL}+" "+$V{REPORT_COUNT}+" "+$P{RECORDS}]]></textFieldExpression>
</textField>
<line direction="TopDown">
<reportElement
mode="Opaque"
x="0"
y="3"
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="29"
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="31"
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>
</band>
</summary>
</jasperReport>