Subversion Repositories Integrator Subversion

<?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="Relatório Quatitativo de Função" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="a9bd3a8d-3d73-4ab7-8540-556997aa680b">
        <property name="ireport.zoom" value="1.5"/>
        <property name="ireport.x" value="0"/>
        <property name="ireport.y" value="0"/>
        <style name="table">
                <box>
                        <pen lineWidth="1.0" lineColor="#000000"/>
                </box>
        </style>
        <style name="table_TH" mode="Opaque" backcolor="#F0F8FF">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table_CH" mode="Opaque" backcolor="#CCCCCC">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
                <conditionalStyle>
                        <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression>
                        <style backcolor="#F3F6F8"/>
                </conditionalStyle>
        </style>
        <subDataset name="funcao" uuid="f8c4d4e7-e9fb-43ab-9295-e01767f3bece">
                <queryString>
                        <![CDATA[SELECT
        f.cod_funcao,
        f.dsc_funcao,
        f.tip_funcao,
        f.num_quantidade_vagas,
        f.dsc_nivel_funcao,
        f.ind_ativo,
        (
            SELECT count(cod_funcao) as total FROM
            sc_srv.srv_servdadofunc_matricula sm
            WHERE sm.cod_funcao=f.cod_funcao AND sm.cod_situacao_servidor = 1
        ) as vagas_ocupadas,
        (
            SELECT count(cod_funcao) as total FROM
            sc_srv.srv_servdadofunc_matricula sm
            INNER JOIN sc_srv.srv_servidor_dadofuncional df on (sm.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional)
            INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso)
            WHERE sm.cod_funcao=f.cod_funcao and fi.tip_vinculo_forma_ingresso = 'E' AND sm.cod_situacao_servidor = 1
        )as vagas_ocupadas_efetivo,
        (
            SELECT count(cod_funcao) as total FROM
            sc_srv.srv_servdadofunc_matricula sm
            INNER JOIN sc_srv.srv_servidor_dadofuncional df on (sm.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional)
            INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso)
            WHERE sm.cod_funcao=f.cod_funcao and fi.tip_vinculo_forma_ingresso = 'T' AND sm.cod_situacao_servidor = 1
        )as vagas_ocupadas_contratado,
        (
            SELECT count(cod_funcao) as total FROM
            sc_srv.srv_servdadofunc_matricula sm
            INNER JOIN sc_srv.srv_servidor_dadofuncional df on (sm.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional)
            INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso)
            WHERE sm.cod_funcao=f.cod_funcao and fi.tip_vinculo_forma_ingresso = 'L' AND sm.cod_situacao_servidor = 1
        )as vagas_ocupadas_celetista,
        (
            SELECT count(cod_funcao) as total FROM
            sc_srv.srv_servdadofunc_matricula sm
            INNER JOIN sc_srv.srv_servidor_dadofuncional df on (sm.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional)
            INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso)
            WHERE sm.cod_funcao=f.cod_funcao and fi.tip_vinculo_forma_ingresso = 'C' AND sm.cod_situacao_servidor = 1
        )as vagas_ocupadas_comissionado,
        (
            (num_quantidade_vagas) -
            (
                SELECT count(cod_funcao) as total FROM
                sc_srv.srv_servdadofunc_matricula sm
                WHERE sm.cod_funcao=f.cod_funcao AND sm.cod_situacao_servidor = 1
            )
        )as saldo_vagas,
        (
            SELECT sum(num_quantidade_vagas) as total FROM sc_srv.srv_funcao
        )as total_vagas_disponiveis,
        (
            SELECT count(cod_funcao) as total FROM
            sc_srv.srv_servdadofunc_matricula sm
            WHERE sm.cod_situacao_servidor = 1
        )as total_vagas_ocupadas,
        (
            (SELECT sum(num_quantidade_vagas) as total FROM sc_srv.srv_funcao) -
            (SELECT count(cod_funcao) as total FROM sc_srv.srv_servdadofunc_matricula sm
            WHERE sm.cod_situacao_servidor = 1)
        )as total_saldo_vagas
        FROM sc_srv.srv_funcao f
        ORDER BY f.dsc_funcao]]>
                </queryString>
                <field name="cod_funcao" class="java.math.BigDecimal"/>
                <field name="dsc_funcao" class="java.lang.String"/>
                <field name="tip_funcao" class="java.lang.String"/>
                <field name="num_quantidade_vagas" class="java.math.BigDecimal"/>
                <field name="dsc_nivel_funcao" class="java.lang.String"/>
                <field name="ind_ativo" class="java.lang.Boolean"/>
                <field name="vagas_ocupadas" class="java.lang.Long"/>
                <field name="vagas_ocupadas_efetivo" class="java.lang.Long"/>
                <field name="vagas_ocupadas_contratado" class="java.lang.Long"/>
                <field name="vagas_ocupadas_celetista" class="java.lang.Long"/>
                <field name="vagas_ocupadas_comissionado" class="java.lang.Long"/>
                <field name="saldo_vagas" class="java.math.BigDecimal"/>
                <field name="total_vagas_disponiveis" class="java.math.BigDecimal"/>
                <field name="total_vagas_ocupadas" class="java.lang.Long"/>
                <field name="total_saldo_vagas" class="java.math.BigDecimal"/>
        </subDataset>
        <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA[""]]></defaultValueExpression>
        </parameter>
        <parameter name="IMAGE_DIR" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA[""]]></defaultValueExpression>
        </parameter>
        <queryString>
                <![CDATA[SELECT * FROM sc_srv.srv_funcao limit 1]]>
        </queryString>
        <field name="cod_funcao" class="java.math.BigDecimal"/>
        <field name="dsc_funcao" class="java.lang.String"/>
        <field name="dsc_nivel_funcao" class="java.lang.String"/>
        <field name="tip_funcao" class="java.lang.String"/>
        <field name="num_quantidade_vagas" class="java.math.BigDecimal"/>
        <field name="ind_ativo" class="java.lang.Boolean"/>
        <background>
                <band splitType="Stretch"/>
        </background>
        <pageHeader>
                <band height="110">
                        <image hAlign="Right">
                                <reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" x="253" y="1" width="48" height="59" isPrintWhenDetailOverflows="true"/>
                                <imageExpression><![CDATA[$P{IMAGE_DIR} + "brasao.jpg"]]></imageExpression>
                        </image>
                        <staticText>
                                <reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="62" width="555" height="39" isPrintWhenDetailOverflows="true"/>
                                <textElement textAlignment="Center" verticalAlignment="Top">
                                        <font fontName="Arial" size="10" isBold="true"/>
                                </textElement>
                                <text><![CDATA[ESTADO DE ALAGOAS
SECRETARIA DE ESTADO DA SAÚDE DE ALAGOAS
RELATÓRIO DE ACOMPANHAMENTO DO SERVIDOR - QUANTITATIVO DE FUNÇÃO]]></text>
                        </staticText>
                </band>
        </pageHeader>
        <columnHeader>
                <band height="15">
                        <rectangle>
                                <reportElement uuid="423b9a10-6789-4023-9a4d-1cd8ecd4119f" positionType="Float" x="0" y="0" width="555" height="15" backcolor="#CCCCCC"/>
                        </rectangle>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" positionType="Float" mode="Transparent" x="0" y="0" width="555" height="15" backcolor="#CCCCCC"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[QUANTITATIVO DE FUNÇÃO]]></text>
                        </staticText>
                </band>
        </columnHeader>
        <detail>
                <band height="42">
                        <componentElement>
                                <reportElement uuid="d544b12e-4a9e-4e24-9e16-b3c298778f8d" key="table" style="table" x="0" y="0" width="555" height="40"/>
                                <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
                                        <datasetRun subDataset="funcao" uuid="235e1965-b170-49ae-bff2-1c8ee15bedc5">
                                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                        </datasetRun>
                                        <jr:column uuid="466342e1-bd5b-40fd-b9e7-86fa6a3e83cc" width="168">
                                                <jr:columnHeader style="table_CH" height="31" rowSpan="2">
                                                        <staticText>
                                                                <reportElement uuid="ca9e68fe-16e6-4297-a0fd-2a6397666366" x="0" y="0" width="168" height="30"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <text><![CDATA[FUNÇÃO]]></text>
                                                        </staticText>
                                                </jr:columnHeader>
                                                <jr:columnFooter style="table_TD" height="15" rowSpan="1">
                                                        <staticText>
                                                                <reportElement uuid="ca9e68fe-16e6-4297-a0fd-2a6397666366" x="0" y="0" width="166" height="15"/>
                                                                <textElement textAlignment="Right" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <text><![CDATA[TOTAL GERAL:]]></text>
                                                        </staticText>
                                                </jr:columnFooter>
                                                <jr:detailCell style="table_TD" height="15" rowSpan="1">
                                                        <textField isBlankWhenNull="true">
                                                                <reportElement uuid="50e05625-444b-4c14-b523-aca5062b3efc" x="1" y="0" width="167" height="15"/>
                                                                <textElement verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                        <paragraph leftIndent="5"/>
                                                                </textElement>
                                                                <textFieldExpression><![CDATA[$F{dsc_funcao}]]></textFieldExpression>
                                                        </textField>
                                                </jr:detailCell>
                                        </jr:column>
                                        <jr:column uuid="a3d93193-512d-4a36-a739-0c64b3587cef" width="56">
                                                <jr:columnHeader style="table_CH" height="31" rowSpan="2">
                                                        <staticText>
                                                                <reportElement uuid="022378a9-2a9e-41d3-9fbd-e60fe1843947" x="0" y="0" width="56" height="30"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <text><![CDATA[DISPONÍVEL]]></text>
                                                        </staticText>
                                                </jr:columnHeader>
                                                <jr:columnFooter style="table_TD" height="15" rowSpan="1">
                                                        <textField isBlankWhenNull="true">
                                                                <reportElement uuid="9ff26279-09e1-4679-87f3-d8436412d437" x="0" y="0" width="56" height="15"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <textFieldExpression><![CDATA[$F{total_vagas_disponiveis}]]></textFieldExpression>
                                                        </textField>
                                                </jr:columnFooter>
                                                <jr:detailCell style="table_TD" height="15" rowSpan="1">
                                                        <textField isBlankWhenNull="true">
                                                                <reportElement uuid="9dd9a8dc-00bc-4a5d-89c8-3877f2191563" x="0" y="0" width="56" height="15"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <textFieldExpression><![CDATA[$F{num_quantidade_vagas}==null? "n/a" :$F{num_quantidade_vagas}]]></textFieldExpression>
                                                        </textField>
                                                </jr:detailCell>
                                        </jr:column>
                                        <jr:columnGroup uuid="1dfefb0f-0cdf-4ee5-9a01-c6fbab46ac66" width="278">
                                                <jr:columnHeader style="table_CH" height="15" rowSpan="1">
                                                        <staticText>
                                                                <reportElement uuid="ca9e68fe-16e6-4297-a0fd-2a6397666366" x="0" y="0" width="278" height="15"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <text><![CDATA[OCUPADOS]]></text>
                                                        </staticText>
                                                </jr:columnHeader>
                                                <jr:column uuid="977f3fb9-aa32-4cb2-9715-620b0e1baaec" width="45">
                                                        <jr:columnHeader style="table_CH" height="16" rowSpan="1">
                                                                <staticText>
                                                                        <reportElement uuid="8dc09efc-a62d-4324-b133-f96145a44443" x="0" y="0" width="45" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <text><![CDATA[EFETIVO]]></text>
                                                                </staticText>
                                                        </jr:columnHeader>
                                                        <jr:detailCell style="table_TD" height="15" rowSpan="1">
                                                                <textField isBlankWhenNull="true">
                                                                        <reportElement uuid="c9f994f6-f75b-42e4-a837-d5d1d87b7553" x="0" y="0" width="45" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <textFieldExpression><![CDATA[$F{vagas_ocupadas_efetivo}]]></textFieldExpression>
                                                                </textField>
                                                        </jr:detailCell>
                                                </jr:column>
                                                <jr:column uuid="db7f36bc-dacc-4c52-bc88-03b6a9a5eaa7" width="68">
                                                        <jr:columnHeader style="table_CH" height="16" rowSpan="1">
                                                                <staticText>
                                                                        <reportElement uuid="f8b25834-20bb-4a6c-bf2f-cb7e888f09fe" x="0" y="0" width="68" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <text><![CDATA[CONTRATADO]]></text>
                                                                </staticText>
                                                        </jr:columnHeader>
                                                        <jr:detailCell style="table_TD" height="15" rowSpan="1">
                                                                <textField isBlankWhenNull="true">
                                                                        <reportElement uuid="f02ee07f-553a-441a-8d2a-019c3e3225f7" x="0" y="0" width="68" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <textFieldExpression><![CDATA[$F{vagas_ocupadas_contratado}]]></textFieldExpression>
                                                                </textField>
                                                        </jr:detailCell>
                                                </jr:column>
                                                <jr:column uuid="4c712216-cb8e-4fa5-a5a3-bfd8cfaf04d4" width="55">
                                                        <jr:columnHeader style="table_CH" height="16" rowSpan="1">
                                                                <staticText>
                                                                        <reportElement uuid="8a6b5afd-7c27-4086-89d1-71d1620e8469" x="0" y="0" width="55" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <text><![CDATA[CELETISTA]]></text>
                                                                </staticText>
                                                        </jr:columnHeader>
                                                        <jr:detailCell style="table_TD" height="15" rowSpan="1">
                                                                <textField isBlankWhenNull="true">
                                                                        <reportElement uuid="a03f18df-4094-4e1f-9121-1099f4849489" x="0" y="0" width="55" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <textFieldExpression><![CDATA[$F{vagas_ocupadas_celetista}]]></textFieldExpression>
                                                                </textField>
                                                        </jr:detailCell>
                                                </jr:column>
                                                <jr:column uuid="d83b562b-46a4-43f3-b29f-04abf5e7b32d" width="70">
                                                        <jr:columnHeader style="table_CH" height="16" rowSpan="1">
                                                                <staticText>
                                                                        <reportElement uuid="ec5b3212-4b3a-4a1a-93bc-16668cabbbf6" x="0" y="0" width="70" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <text><![CDATA[COMISSIONADO]]></text>
                                                                </staticText>
                                                        </jr:columnHeader>
                                                        <jr:detailCell style="table_TD" height="15" rowSpan="1">
                                                                <textField isBlankWhenNull="true">
                                                                        <reportElement uuid="5abbdc99-dda5-4bba-b46d-d042b901d759" x="0" y="0" width="70" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <textFieldExpression><![CDATA[$F{vagas_ocupadas_comissionado}]]></textFieldExpression>
                                                                </textField>
                                                        </jr:detailCell>
                                                </jr:column>
                                                <jr:column uuid="b4a29af0-1c36-4b2f-9243-8f4c02f724fa" width="40">
                                                        <jr:columnHeader style="table_CH" height="16" rowSpan="1">
                                                                <staticText>
                                                                        <reportElement uuid="12d87179-a051-4eac-a373-f687ca2b6862" x="0" y="0" width="40" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <text><![CDATA[TOTAL]]></text>
                                                                </staticText>
                                                        </jr:columnHeader>
                                                        <jr:columnFooter style="table_TD" height="15" rowSpan="1">
                                                                <textField isBlankWhenNull="true">
                                                                        <reportElement uuid="6edb0595-d757-44f3-99ae-473526591447" x="0" y="0" width="40" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <textFieldExpression><![CDATA[$F{total_vagas_ocupadas}]]></textFieldExpression>
                                                                </textField>
                                                        </jr:columnFooter>
                                                        <jr:detailCell style="table_TD" height="15" rowSpan="1">
                                                                <textField isBlankWhenNull="true">
                                                                        <reportElement uuid="3e1c696a-025f-4a43-bda6-98f36a8086ab" x="0" y="0" width="40" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <textFieldExpression><![CDATA[$F{vagas_ocupadas}]]></textFieldExpression>
                                                                </textField>
                                                        </jr:detailCell>
                                                </jr:column>
                                        </jr:columnGroup>
                                        <jr:column uuid="7c76de04-8952-478b-9001-7de6181ab5fa" width="53">
                                                <jr:columnHeader style="table_CH" height="31" rowSpan="2">
                                                        <staticText>
                                                                <reportElement uuid="6969a9fe-509d-47d3-b4fd-82ae58e5652f" x="0" y="0" width="49" height="30"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <text><![CDATA[SALDO]]></text>
                                                        </staticText>
                                                </jr:columnHeader>
                                                <jr:columnFooter style="table_TD" height="15" rowSpan="1">
                                                        <textField isBlankWhenNull="true">
                                                                <reportElement uuid="93ac7620-8a6e-4b57-94fc-fdae5bcb023c" x="0" y="0" width="49" height="15"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <textFieldExpression><![CDATA[($F{total_saldo_vagas}.intValue() < 0 ? "n/a":$F{total_saldo_vagas})]]></textFieldExpression>
                                                        </textField>
                                                </jr:columnFooter>
                                                <jr:detailCell style="table_TD" height="15" rowSpan="1">
                                                        <textField isBlankWhenNull="true">
                                                                <reportElement uuid="7bda85e7-ab71-4526-96d9-b45e923fd3ee" x="0" y="0" width="49" height="15"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <textFieldExpression><![CDATA[$F{saldo_vagas}==null? "n/a" :$F{saldo_vagas}]]></textFieldExpression>
                                                        </textField>
                                                </jr:detailCell>
                                        </jr:column>
                                </jr:table>
                        </componentElement>
                </band>
        </detail>
        <pageFooter>
                <band height="33">
                        <textField evaluationTime="Report" isBlankWhenNull="false">
                                <reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="497" y="10" width="52" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
                        </textField>
                        <textField isBlankWhenNull="false">
                                <reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="422" y="10" width="73" height="15"/>
                                <textElement textAlignment="Right" verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
                        </textField>
                        <textField isBlankWhenNull="true">
                                <reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="10" width="289" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA[new java.text.SimpleDateFormat("'Gerado em ' dd 'de' MMMMM 'de' yyyy ' às ' HH:mm", new Locale("pt", "BR")).format(new java.util.Date()).toUpperCase()]]></textFieldExpression>
                        </textField>
                </band>
        </pageFooter>
        <summary>
                <band height="47"/>
        </summary>
</jasperReport>