<?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="PRTR012" 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"> <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="stat" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Status"]]></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="academyid" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Academy Id"]]></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["Tool Detail"]]></defaultValueExpression> </parameter> <parameter name="id" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Tool Id"]]></defaultValueExpression> </parameter> <parameter name="amount" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Expenses per used"]]></defaultValueExpression> </parameter> <parameter name="tool_name" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Tool Name"]]></defaultValueExpression> </parameter> <parameter name="bath" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["bath"]]></defaultValueExpression> </parameter> <field name="mtool__toolid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mtool__toolid]]></fieldDescription> </field> <field name="mtool__tooldesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mtool__tooldesc]]></fieldDescription> </field> <field name="mtool__tooledesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mtool__tooledesc]]></fieldDescription> </field> <field name="mtool__amount" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mtool__amount]]></fieldDescription> </field> <variable name="TEST" class="java.lang.String" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA["A"]]></variableExpression> <initialValueExpression><![CDATA["A"]]></initialValueExpression> </variable> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="76" isSplitAllowed="true" > <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="0" y="32" width="535" 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="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{REPORTHEADER}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="427" 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="false" evaluationTime="Report" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="510" 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="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="109" y="16" width="306" 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="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{COMPANY}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" 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> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="109" y="0" width="306" 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="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{TRAINING}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="60" width="65" height="16" key="textField"/> <box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <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[$P{id}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="65" y="60" width="338" height="16" key="textField"/> <box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <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[$P{tool_name}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="403" y="60" width="132" height="16" key="textField-51"/> <box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{amount}]]></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="65" height="16" key="textField-52" stretchType="RelativeToTallestObject" isPrintWhenDetailOverflows="true"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" 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{mtool__toolid}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="65" y="0" width="338" height="16" key="textField-53" stretchType="RelativeToTallestObject" isPrintWhenDetailOverflows="true"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" 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{mtool__tooldesc}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="403" y="0" width="132" height="16" key="textField-54" stretchType="RelativeToTallestObject" isPrintWhenDetailOverflows="true"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" rightPadding="8" bottomBorder="Thin" bottomBorderColor="#CCCCCC"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[Double.valueOf($F{mtool__amount})]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="16" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="0" y="0" width="535" 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="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="0" y="0" width="535" 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{REPORT_COUNT}+" "+$P{RECORDS}]]></textFieldExpression> </textField> </band> </summary> </jasperReport>