<?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="ASPR001" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="842" pageHeight="595" columnWidth="782" columnSpacing="0" leftMargin="30" rightMargin="30" 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="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="COMPANY" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> </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["TRA044"]]></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="TOTHOURS" isForPrompting="true" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Total Hour"]]></defaultValueExpression> </parameter> <parameter name="TRAINING" isForPrompting="true" 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="PREPARED" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Prepared by"]]></defaultValueExpression> </parameter> <parameter name="LANG" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[lang]]></parameterDescription> <defaultValueExpression ><![CDATA["THA"]]></defaultValueExpression> </parameter> <parameter name="REPORTHEADER" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> </parameter> <parameter name="detail" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Detail"]]></defaultValueExpression> </parameter> <parameter name="apsid" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Assess ID"]]></defaultValueExpression> </parameter> <parameter name="start" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Assess date"]]></defaultValueExpression> </parameter> <parameter name="p_start" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Assess period"]]></defaultValueExpression> </parameter> <parameter name="type" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Assess type"]]></defaultValueExpression> </parameter> <parameter name="no" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["No"]]></defaultValueExpression> </parameter> <parameter name="empid" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["EmpID"]]></defaultValueExpression> </parameter> <parameter name="name" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Name Surname"]]></defaultValueExpression> </parameter> <parameter name="bu1" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["BU1"]]></defaultValueExpression> </parameter> <parameter name="bu2" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["BU2"]]></defaultValueExpression> </parameter> <parameter name="bu3" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["BU3"]]></defaultValueExpression> </parameter> <parameter name="position" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Position"]]></defaultValueExpression> </parameter> <parameter name="grade" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Grade"]]></defaultValueExpression> </parameter> <parameter name="score" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Assess score"]]></defaultValueExpression> </parameter> <parameter name="to" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["To"]]></defaultValueExpression> </parameter> <field name="hapstran0__apsid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran0__apsid]]></fieldDescription> </field> <field name="hapstran0__tdesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran0__tdesc]]></fieldDescription> </field> <field name="hapstran0__edesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran0__edesc]]></fieldDescription> </field> <field name="hapstran0__apsstartdate" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran0__apsstartdate]]></fieldDescription> </field> <field name="hapstran0__apsenddate" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran0__apsenddate]]></fieldDescription> </field> <field name="hapstran0__apsperiodstart" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran0__apsperiodstart]]></fieldDescription> </field> <field name="hapstran0__apsperiodend" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran0__apsperiodend]]></fieldDescription> </field> <field name="hapstran0__astid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran0__astid]]></fieldDescription> </field> <field name="hapstran0__apsreference" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran0__apsreference]]></fieldDescription> </field> <field name="hapstran0__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran0__companyid]]></fieldDescription> </field> <field name="hapstran__apsid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran__apsid]]></fieldDescription> </field> <field name="hapstran__apsassessy" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran__apsassessy]]></fieldDescription> </field> <field name="hapstran__apssumscore" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran__apssumscore]]></fieldDescription> </field> <field name="hapstran__apssumscoremax" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran__apssumscoremax]]></fieldDescription> </field> <field name="hapstran__apsscorepc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran__apsscorepc]]></fieldDescription> </field> <field name="hapstran__apsappgrade2" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran__apsappgrade2]]></fieldDescription> </field> <field name="hapstran__emp_group" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran__emp_group]]></fieldDescription> </field> <field name="hapstran__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by hapstran__companyid]]></fieldDescription> </field> <field name="mastype__astid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mastype__astid]]></fieldDescription> </field> <field name="mastype__tdesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mastype__tdesc]]></fieldDescription> </field> <field name="mastype__edesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mastype__edesc]]></fieldDescription> </field> <field name="mastype__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mastype__companyid]]></fieldDescription> </field> <field name="simemp__employeeid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by simemp__employeeid]]></fieldDescription> </field> <field name="simemp__emp_prefix" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by simemp__emp_prefix]]></fieldDescription> </field> <field name="simemp__fname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by simemp__fname]]></fieldDescription> </field> <field name="simemp__lname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by simemp__lname]]></fieldDescription> </field> <field name="simemp__efname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by simemp__efname]]></fieldDescription> </field> <field name="simemp__elname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by simemp__elname]]></fieldDescription> </field> <field name="simemp__emp_position" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by simemp__emp_position]]></fieldDescription> </field> <field name="simemp__bu1" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by simemp__bu1]]></fieldDescription> </field> <field name="simemp__bu2" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by simemp__bu2]]></fieldDescription> </field> <field name="simemp__bu3" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by simemp__bu3]]></fieldDescription> </field> <field name="simemp__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by simemp__companyid]]></fieldDescription> </field> <field name="mbu1__bu1id" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mbu1__bu1id]]></fieldDescription> </field> <field name="mbu1__tdesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mbu1__tdesc]]></fieldDescription> </field> <field name="mbu1__edesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mbu1__edesc]]></fieldDescription> </field> <field name="mbu1__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mbu1__companyid]]></fieldDescription> </field> <field name="mbu2__bu2id" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mbu2__bu2id]]></fieldDescription> </field> <field name="mbu2__tdesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mbu2__tdesc]]></fieldDescription> </field> <field name="mbu2__edesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mbu2__edesc]]></fieldDescription> </field> <field name="mbu2__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mbu2__companyid]]></fieldDescription> </field> <field name="mbu3__bu3id" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mbu3__bu3id]]></fieldDescription> </field> <field name="mbu3__tdesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mbu3__tdesc]]></fieldDescription> </field> <field name="mbu3__edesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mbu3__edesc]]></fieldDescription> </field> <field name="mbu3__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mbu3__companyid]]></fieldDescription> </field> <field name="mposition__positionid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mposition__positionid]]></fieldDescription> </field> <field name="mposition__tdesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mposition__tdesc]]></fieldDescription> </field> <field name="mposition__edesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mposition__edesc]]></fieldDescription> </field> <field name="mposition__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mposition__companyid]]></fieldDescription> </field> <field name="mprefix__prefixid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mprefix__prefixid]]></fieldDescription> </field> <field name="mprefix__tdesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mprefix__tdesc]]></fieldDescription> </field> <field name="mprefix__edesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mprefix__edesc]]></fieldDescription> </field> <variable name="TEST" class="java.lang.String" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA["A"]]></variableExpression> <initialValueExpression><![CDATA["A"]]></initialValueExpression> </variable> <variable name="hapstran" class="java.lang.Integer" resetType="Group" resetGroup="hapstran0" calculation="Count"> <variableExpression><![CDATA[$F{hapstran__apsassessy}]]></variableExpression> </variable> <group name="hapstran0" isReprintHeaderOnEachPage="true" > <groupExpression><![CDATA[$F{hapstran0__apsid}]]></groupExpression> <groupHeader> <band height="80" isSplitAllowed="true" > <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="90" height="16" key="textField-66" stretchType="RelativeToTallestObject" isPrintWhenDetailOverflows="true"/> <box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{apsid}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="90" y="0" width="692" height="16" key="textField-67" stretchType="RelativeToTallestObject" isPrintWhenDetailOverflows="true"/> <box topBorder="Thin" topBorderColor="#000000" leftBorder="None" leftBorderColor="#CCCCCC" leftPadding="4" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#999999"/> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{hapstran0__apsid}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="16" width="90" height="16" key="textField-68" stretchType="RelativeToTallestObject" isPrintWhenDetailOverflows="true"/> <box topBorder="None" topBorderColor="#CCCCCC" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{detail}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="90" y="16" width="692" height="16" key="textField-69" stretchType="RelativeToTallestObject" isPrintWhenDetailOverflows="true"/> <box topBorder="None" topBorderColor="#CCCCCC" leftBorder="None" leftBorderColor="#CCCCCC" leftPadding="4" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#999999"/> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{hapstran0__tdesc}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="270" y="32" width="90" height="16" key="textField-70" stretchType="RelativeToTallestObject" isPrintWhenDetailOverflows="true"/> <box topBorder="None" topBorderColor="#CCCCCC" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{start}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="360" y="32" width="422" height="16" key="textField-71" stretchType="RelativeToTallestObject" isPrintWhenDetailOverflows="true"/> <box topBorder="None" topBorderColor="#CCCCCC" leftBorder="None" leftBorderColor="#CCCCCC" leftPadding="4" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#999999"/> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new com.csc.library.report.ReportUDF().getFullLongDate($P{LANG},$F{hapstran0__apsstartdate}) +" - "+ new com.csc.library.report.ReportUDF().getFullLongDate($P{LANG},$F{hapstran0__apsenddate})]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="48" width="90" height="16" key="textField-80" stretchType="RelativeToTallestObject" isPrintWhenDetailOverflows="true"/> <box topBorder="None" topBorderColor="#CCCCCC" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{type}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="90" y="48" width="692" height="16" key="textField-81" stretchType="RelativeToTallestObject" isPrintWhenDetailOverflows="true"/> <box topBorder="None" topBorderColor="#CCCCCC" leftBorder="None" leftBorderColor="#CCCCCC" leftPadding="4" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#999999"/> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{mastype__tdesc}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="64" width="30" height="16" key="textField"/> <box topBorder="Thin" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#666666"/> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="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 x="90" y="64" width="121" height="16" key="textField-49"/> <box topBorder="Thin" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#666666"/> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{name}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="211" y="64" width="115" height="16" key="textField-50"/> <box topBorder="Thin" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#666666"/> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{bu1}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="30" y="64" width="60" height="16" key="textField-65"/> <box topBorder="Thin" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#666666"/> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{empid}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="326" y="64" width="115" height="16" key="textField-82"/> <box topBorder="Thin" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#666666"/> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{bu2}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="441" y="64" width="115" height="16" key="textField-83"/> <box topBorder="Thin" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#666666"/> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{bu3}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="556" y="64" width="115" height="16" key="textField-84"/> <box topBorder="Thin" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#666666"/> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{position}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="671" y="64" width="40" height="16" key="textField-85"/> <box topBorder="Thin" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#666666"/> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{grade}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="711" y="64" width="71" height="16" key="textField-86"/> <box topBorder="Thin" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#666666"/> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{score}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="32" width="90" height="16" key="textField-96" stretchType="RelativeToTallestObject" isPrintWhenDetailOverflows="true"/> <box topBorder="None" topBorderColor="#CCCCCC" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{p_start}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="90" y="32" width="180" height="16" key="textField-97" stretchType="RelativeToTallestObject" isPrintWhenDetailOverflows="true"/> <box topBorder="None" topBorderColor="#CCCCCC" leftBorder="None" leftBorderColor="#CCCCCC" leftPadding="4" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#999999"/> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new com.csc.library.report.ReportUDF().getFullLongDate($P{LANG},$F{hapstran0__apsperiodstart}) +" - "+ new com.csc.library.report.ReportUDF().getFullLongDate($P{LANG},$F{hapstran0__apsperiodend})]]></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="32" isSplitAllowed="true" > <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="0" y="16" width="782" height="16" forecolor="#000000" backcolor="#FFFFFF" key="textField"/> <box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{REPORTHEADER}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="674" y="0" width="83" height="16" forecolor="#000000" backcolor="#FFFFFF" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right" 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().getDDMMYYYY()+" - "+$P{Page}+" "+$V{PAGE_NUMBER} + " / "]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Report" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="757" y="0" width="25" height="16" forecolor="#000000" backcolor="#FFFFFF" key="textField"/> <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="12" 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="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="0" y="0" width="79" height="16" forecolor="#000000" backcolor="#FFFFFF" key="textField" isPrintInFirstWholeBand="true"/> <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="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{SCREEN}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="16" isSplitAllowed="true" > <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="30" height="16" key="textField-87" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#CCCCCC"/> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{hapstran}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="90" y="0" width="121" height="16" key="textField-88" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#CCCCCC"/> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{mprefix__tdesc}+$F{simemp__fname}+" "+$F{simemp__lname}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="211" y="0" width="115" height="16" key="textField-89" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#CCCCCC"/> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{mbu1__tdesc}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="30" y="0" width="60" height="16" key="textField-90" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#CCCCCC"/> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{hapstran__apsassessy}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="326" y="0" width="115" height="16" key="textField-91" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#CCCCCC"/> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{mbu2__tdesc}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="441" y="0" width="115" height="16" key="textField-92" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#CCCCCC"/> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{mbu3__tdesc}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="556" y="0" width="115" height="16" key="textField-93" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" leftPadding="2" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#CCCCCC"/> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{mposition__tdesc}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="671" y="0" width="40" height="16" key="textField-94" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#CCCCCC"/> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{hapstran__apsappgrade2}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="711" y="0" width="71" height="16" key="textField-95" stretchType="RelativeToTallestObject" positionType="Float"/> <box topBorder="None" topBorderColor="#666666" leftBorder="Thin" leftBorderColor="#666666" rightBorder="Thin" rightBorderColor="#000000" rightPadding="4" bottomBorder="Thin" bottomBorderColor="#CCCCCC"/> <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[Double.valueOf($F{hapstran__apssumscore})]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="16" isSplitAllowed="true" > <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="0" y="0" width="782" height="16" forecolor="#000000" backcolor="#FFFFFF" key="textField" isPrintInFirstWholeBand="true"/> <box topBorder="Thin" 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="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{PREPARED}+" "+$P{PRINTNAME}]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="16" isSplitAllowed="true" > <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="0" y="0" width="782" height="16" forecolor="#000000" backcolor="#FFFFFF" key="textField"/> <box topBorder="Thin" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <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[$P{TOTAL}+" "+$V{hapstran0_COUNT}+" "+$P{RECORDS}]]></textFieldExpression> </textField> </band> </summary> </jasperReport>