Plandora Project Management Code
Multi-project management, web-based Project Management suite.
Brought to you by:
albertopereto
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="backlog" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" uuid="6236b9b0-7a8c-43b1-ad08-6d6dbb0cadcb">
<property name="ireport.scriptlethandling" value="0"/>
<property name="ireport.encoding" value="UTF-8"/>
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<import value="net.sf.jasperreports.engine.*"/>
<import value="java.util.*"/>
<import value="net.sf.jasperreports.engine.data.*"/>
<queryString>
<![CDATA[select u.id as user_id, u.name, c.name as category_name, c.id as category_id,
ts.name as task_status, ts.id as statusId, t.name as task_name, rt.project_id,
p.name as project_name, rt.start_date, rt.estimated_time, rt.actual_date, rt.actual_time,
date_add(rt.actual_date, INTERVAL rt.actual_time HOUR) as final_date
from resource_task rt, task t, tool_user u, project p, task_status ts, category c
where rt.task_id=t.id and rt.resource_id = u.id
and rt.project_id = p.id
and rt.task_status_id = ts.id
and t.category_id = c.id
and (ts.state_machine_order <> 100 and ts.state_machine_order <> 102) and rt.actual_date is not null
order by rt.project_id, u.id, ts.state_machine_order, c.id]]>
</queryString>
<field name="user_id" class="java.lang.String"/>
<field name="name" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="category_name" class="java.lang.String"/>
<field name="category_id" class="java.lang.String"/>
<field name="task_status" class="java.lang.String"/>
<field name="statusId" class="java.lang.String"/>
<field name="task_name" class="java.lang.String"/>
<field name="project_id" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="project_name" class="java.lang.String"/>
<field name="start_date" class="java.sql.Timestamp">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="estimated_time" class="java.lang.Long">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="actual_date" class="java.sql.Timestamp">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="actual_time" class="java.lang.Long">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="final_date" class="java.sql.Timestamp">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<group name="PROJECT" isStartNewPage="true">
<groupExpression><![CDATA[$F{project_id}]]></groupExpression>
<groupHeader>
<band height="21">
<textField isBlankWhenNull="false">
<reportElement key="textField-5" mode="Opaque" x="5" y="2" width="518" height="16" backcolor="#CCCCCC" uuid="e45b026a-fd55-48c0-b986-0678296a1f6a"/>
<box topPadding="1" leftPadding="10" bottomPadding="1">
<topPen lineWidth="0.25" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.25" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.25" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Tahoma" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{project_name}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
<groupFooter>
<band/>
</groupFooter>
</group>
<group name="USER">
<groupExpression><![CDATA[$F{user_id}]]></groupExpression>
<groupHeader>
<band height="53">
<textField isBlankWhenNull="false">
<reportElement key="textField" x="7" y="3" width="257" height="15" backcolor="#CCCCCC" uuid="482a1659-1c8d-4636-aff1-95e327749b88"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Tahoma" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
</textField>
<staticText>
<reportElement key="staticText-2" mode="Transparent" x="7" y="34" width="51" height="13" backcolor="#CCCCCC" uuid="e2442ce5-2dfa-4617-9c90-32e935ab5d86"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Tahoma" isBold="true"/>
</textElement>
<text><![CDATA[Status]]></text>
</staticText>
<staticText>
<reportElement key="staticText-3" mode="Transparent" x="312" y="34" width="212" height="13" backcolor="#CCCCCC" uuid="b518c27a-0749-4221-bffa-9694721cb89c"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Tahoma" isBold="true"/>
</textElement>
<text><![CDATA[Task Name]]></text>
</staticText>
<staticText>
<reportElement key="staticText-4" mode="Transparent" x="61" y="34" width="72" height="13" backcolor="#CCCCCC" uuid="5974fb18-9d17-4847-8b0b-4f502136ae44"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Tahoma" isBold="true"/>
</textElement>
<text><![CDATA[Category]]></text>
</staticText>
<staticText>
<reportElement key="staticText-5" mode="Transparent" x="140" y="34" width="49" height="13" backcolor="#CCCCCC" uuid="50573457-d8ba-4df6-a509-d2eae441cf04"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Tahoma" isBold="true"/>
</textElement>
<text><![CDATA[Date]]></text>
</staticText>
<staticText>
<reportElement key="staticText-6" mode="Transparent" x="187" y="34" width="38" height="13" backcolor="#CCCCCC" uuid="6018e6f9-92bd-4022-8ea2-134cca416a80"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Tahoma" isBold="true"/>
</textElement>
<text><![CDATA[Time]]></text>
</staticText>
<staticText>
<reportElement key="staticText-9" mode="Transparent" x="137" y="22" width="88" height="13" backcolor="#CCCCCC" uuid="1ec72d03-e894-40d0-9795-a59a2e8f9350"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Tahoma" isBold="true"/>
</textElement>
<text><![CDATA[Estimated]]></text>
</staticText>
<line>
<reportElement key="line-4" x="5" y="18" width="521" height="1" uuid="9b384ca8-aa9f-4ffc-8af1-934a7a3fce1f"/>
</line>
<staticText>
<reportElement key="staticText-10" mode="Transparent" x="228" y="34" width="47" height="13" backcolor="#CCCCCC" uuid="b57f87c9-6a94-4005-a5db-f91a27810923"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Tahoma" isBold="true"/>
</textElement>
<text><![CDATA[Date]]></text>
</staticText>
<staticText>
<reportElement key="staticText-11" mode="Transparent" x="274" y="34" width="38" height="13" backcolor="#CCCCCC" uuid="6f4b8b43-6a58-4480-acaa-d3326b7e4517"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Tahoma" isBold="true"/>
</textElement>
<text><![CDATA[Time]]></text>
</staticText>
<staticText>
<reportElement key="staticText-12" mode="Transparent" x="229" y="22" width="83" height="13" backcolor="#CCCCCC" uuid="1d2e5deb-8222-443d-97a5-b9fcbcf4f046"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Tahoma" isBold="true"/>
</textElement>
<text><![CDATA[Actual]]></text>
</staticText>
</band>
</groupHeader>
<groupFooter>
<band height="121">
<pieChart>
<chart isShowLegend="false">
<reportElement key="element-1" x="3" y="5" width="222" height="110" uuid="72ea63a6-70cd-433d-84e0-04056174a630"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<chartTitle>
<font fontName="Verdana" size="8"/>
</chartTitle>
<chartSubtitle>
<font fontName="Verdana" size="8"/>
</chartSubtitle>
<chartLegend textColor="#000000" backgroundColor="#FFFFFF">
<font fontName="Verdana" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
</chartLegend>
</chart>
<pieDataset>
<dataset resetType="Group" resetGroup="USER"/>
<keyExpression><![CDATA[$F{task_status}]]></keyExpression>
<valueExpression><![CDATA[$V{STATUS_COUNT}]]></valueExpression>
<labelExpression><![CDATA[$F{task_status}]]></labelExpression>
</pieDataset>
<piePlot isCircular="true">
<plot backgroundAlpha="0.5"/>
<itemLabel color="#000000" backgroundColor="#FFFFFF">
<font fontName="Verdana" size="8"/>
</itemLabel>
</piePlot>
</pieChart>
<stackedBarChart>
<chart>
<reportElement key="element-2" x="231" y="5" width="296" height="110" uuid="4d4ec289-971c-4caa-80a4-701ef1d72653"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<chartTitle>
<font fontName="Verdana" size="8"/>
</chartTitle>
<chartSubtitle>
<font fontName="Verdana" size="8"/>
</chartSubtitle>
<chartLegend textColor="#000000" backgroundColor="#FFFFFF">
<font fontName="Verdana" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
</chartLegend>
</chart>
<categoryDataset>
<dataset resetType="Group" resetGroup="USER"/>
<categorySeries>
<seriesExpression><![CDATA[$F{category_name}]]></seriesExpression>
<categoryExpression><![CDATA[$F{category_name}]]></categoryExpression>
<valueExpression><![CDATA[$V{CATEGORY_COUNT}]]></valueExpression>
</categorySeries>
</categoryDataset>
<barPlot isShowTickLabels="false" isShowTickMarks="false">
<plot>
<seriesColor seriesOrder="0" color="#CCCCFF"/>
<seriesColor seriesOrder="1" color="#9999FF"/>
<seriesColor seriesOrder="2" color="#3333FF"/>
<seriesColor seriesOrder="3" color="#6600FF"/>
<seriesColor seriesOrder="4" color="#000099"/>
</plot>
<itemLabel color="#000000" backgroundColor="#FFFFFF">
<font fontName="Verdana" size="8"/>
</itemLabel>
<categoryAxisFormat>
<axisFormat>
<labelFont>
<font fontName="Verdana" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
</labelFont>
<tickLabelFont>
<font fontName="Verdana" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
</tickLabelFont>
</axisFormat>
</categoryAxisFormat>
<valueAxisFormat>
<axisFormat>
<labelFont>
<font fontName="Verdana" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
</labelFont>
<tickLabelFont>
<font fontName="Verdana" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
</tickLabelFont>
</axisFormat>
</valueAxisFormat>
</barPlot>
</stackedBarChart>
</band>
</groupFooter>
</group>
<group name="STATUS">
<groupExpression><![CDATA[]]></groupExpression>
<groupHeader>
<band/>
</groupHeader>
<groupFooter>
<band/>
</groupFooter>
</group>
<group name="CATEGORY">
<groupExpression><![CDATA[$F{category_name}]]></groupExpression>
<groupHeader>
<band/>
</groupHeader>
<groupFooter>
<band/>
</groupFooter>
</group>
<background>
<band/>
</background>
<title>
<band/>
</title>
<pageHeader>
<band height="43">
<staticText>
<reportElement key="staticText-1" x="4" y="5" width="516" height="22" uuid="bfdfdcb9-9f10-4cd3-9ccb-f09cf32ee3a5"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Tahoma" size="18" isBold="true"/>
</textElement>
<text><![CDATA[Backlog Report]]></text>
</staticText>
<line>
<reportElement key="line-1" x="5" y="30" width="521" height="1" uuid="e8f221a1-8e3a-441c-ba64-989fc5c2dc32"/>
</line>
</band>
</pageHeader>
<columnHeader>
<band/>
</columnHeader>
<detail>
<band height="16">
<textField isBlankWhenNull="false">
<reportElement key="textField" x="5" y="2" width="57" height="14" uuid="e9cc1e82-c4d8-4bec-bcce-36143ac2afe3"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{task_status}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="false">
<reportElement key="textField" x="62" y="2" width="76" height="14" uuid="3b2e1dbd-72ff-48de-a048-4f47e2123ff9"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{category_name}]]></textFieldExpression>
</textField>
<textField pattern="dd/MM/yyyy" isBlankWhenNull="false">
<reportElement key="textField" x="145" y="2" width="49" height="14" uuid="ab9bc02e-4c14-495a-9a95-99ab326408df"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{start_date}]]></textFieldExpression>
</textField>
<textField pattern="##0.00" isBlankWhenNull="false">
<reportElement key="textField" x="198" y="2" width="32" height="14" uuid="41d30f4f-1d85-44b5-8a38-44a0cb88e0e4"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression><![CDATA[new Long($F{estimated_time}.longValue()/60)]]></textFieldExpression>
</textField>
<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
<reportElement key="textField" x="231" y="2" width="49" height="14" uuid="4765773d-11d8-4cf9-b90e-b4549c62ab89"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{actual_date}]]></textFieldExpression>
</textField>
<textField pattern="##0.00" isBlankWhenNull="true">
<reportElement key="textField" x="284" y="2" width="32" height="14" uuid="e4726454-2631-41a3-8106-53a739d99bf0"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression><![CDATA[new Long($F{actual_time}.longValue()/60)]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="false">
<reportElement key="textField" x="325" y="2" width="201" height="14" uuid="7cdbef9f-234c-418c-89c8-9643a5bebee0"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{task_name}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band/>
</columnFooter>
<pageFooter>
<band height="33">
<textField evaluationTime="Report" isBlankWhenNull="false">
<reportElement key="textField-1" x="488" y="6" width="39" height="18" uuid="57f4c079-ef65-4a6b-9ceb-3a82755b8a87"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Verdana"/>
</textElement>
<textFieldExpression><![CDATA[" of " + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="false">
<reportElement key="textField-2" x="371" y="6" width="117" height="18" uuid="babcca8b-4a96-49ec-ae35-401e5bd0a8eb"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Right">
<font fontName="Verdana"/>
</textElement>
<textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<line>
<reportElement key="line-2" x="5" y="3" width="522" height="1" uuid="d5c431de-165f-412e-bf7e-890c4c5f53b7"/>
</line>
</band>
</pageFooter>
<lastPageFooter>
<band height="26">
<textField evaluationTime="Report" isBlankWhenNull="false">
<reportElement key="textField-3" x="489" y="6" width="39" height="18" uuid="f0eb2cc1-8cd4-4a10-9df1-ba0e9c24af19"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Verdana"/>
</textElement>
<textFieldExpression><![CDATA[" of " + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="false">
<reportElement key="textField-4" x="372" y="6" width="117" height="18" uuid="8ea725d0-64fa-4985-9014-359f750364b3"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Right">
<font fontName="Verdana"/>
</textElement>
<textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<line>
<reportElement key="line-3" x="6" y="3" width="522" height="1" uuid="9c5bf193-99f0-4a68-bbc4-b245c33d7cc5"/>
</line>
</band>
</lastPageFooter>
<summary>
<band/>
</summary>
</jasperReport>