Subversion Repositories Integrator Subversion

Rev

Blame | Last modification | View Log | Download | RSS feed 

<?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="relatorio" pageWidth="595" pageHeight="842" columnWidth="556" leftMargin="20" rightMargin="19" topMargin="20" bottomMargin="20" uuid="85d4a540-608e-4934-8f57-57cec53afb74">
        <property name="ireport.zoom" value="1.0"/>
        <property name="ireport.x" value="0"/>
        <property name="ireport.y" value="0"/>
        <parameter name="IMAGEM_DIR" class="java.lang.String">
                <defaultValueExpression><![CDATA["C:\\"]]></defaultValueExpression>
        </parameter>
        <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA["C:\\Repositorio\\DESENVOLVIMENTO\\SESAU\\JAVA\\Repositorio\\rhcapacitacao\\FONTES\\IMPLEMENTACAO\\DESENVOLVIMENTO\\scs\\scs-core\\src\\main\\resources\\relatorios\\"]]></defaultValueExpression>
        </parameter>
        <parameter name="NOM_USUARIO" class="java.lang.String">
                <defaultValueExpression><![CDATA[]]></defaultValueExpression>
        </parameter>
        <parameter name="CPF_USUARIO" class="java.lang.String">
                <defaultValueExpression><![CDATA[]]></defaultValueExpression>
        </parameter>
        <parameter name="MES" class="java.lang.String">
                <defaultValueExpression><![CDATA[]]></defaultValueExpression>
        </parameter>
        <parameter name="ANO" class="java.lang.Integer">
                <defaultValueExpression><![CDATA[2013]]></defaultValueExpression>
        </parameter>
        <queryString>
                <![CDATA[SELECT
tr.num_ano,
cp.dsc_capacitacao,
tr.seq_turma,
uw.dsc_unidade,
po.num_processo,
po.dsc_ano_processo,
po.cod_orgao_processo,
po.dsc_elemento_despesa,
po.dsc_fonte_recurso,
po.val_orcado
FROM sc_scs.scs_turma tr
INNER JOIN sc_scs.scs_capacitacao cp ON tr.seq_capacitacao = cp.seq_capacitacao
LEFT JOIN sc_scs.scs_turma_processo pr ON pr.seq_turma = tr.seq_turma
LEFT JOIN orcamento.vw_processo_orcamento po ON pr.cod_orgao = po.cod_orgao_processo
AND pr.num_processo = po.num_processo
AND pr.num_ano = po.num_periodo_orcamentario
LEFT JOIN sc_srv.vw_unidade uw ON uw.cod_unidade = tr.cod_unidade_solicitante
WHERE tr.num_ano = $P{ANO}
AND
(
   $P{MES} =
   (
      SELECT
      to_char(MIN(tp.dth_data_inicial), 'MM')
      FROM sc_scs.scs_turma_periodo tp
      WHERE tp.seq_turma = tr.seq_turma
   )
   OR
   $P{MES} IS NULL
) ORDER BY tr.seq_turma, po.num_processo]]>
        </queryString>
        <field name="num_ano" class="java.math.BigDecimal"/>
        <field name="dsc_capacitacao" class="java.lang.String"/>
        <field name="seq_turma" class="java.lang.Long"/>
        <field name="dsc_unidade" class="java.lang.String"/>
        <field name="num_processo" class="java.math.BigDecimal"/>
        <field name="dsc_ano_processo" class="java.lang.String"/>
        <field name="cod_orgao_processo" class="java.math.BigDecimal"/>
        <field name="dsc_elemento_despesa" class="java.lang.String"/>
        <field name="dsc_fonte_recurso" class="java.lang.String"/>
        <field name="val_orcado" class="java.lang.Double"/>
        <variable name="TOTAL ORCADO" class="java.lang.Double" resetType="Group" resetGroup="Turma" calculation="Sum">
                <variableExpression><![CDATA[$F{val_orcado}]]></variableExpression>
                <initialValueExpression><![CDATA[0.00]]></initialValueExpression>
        </variable>
        <variable name="TOTAL" class="java.lang.Double" calculation="Sum">
                <variableExpression><![CDATA[$F{val_orcado}]]></variableExpression>
                <initialValueExpression><![CDATA[0.00]]></initialValueExpression>
        </variable>
        <group name="Turma">
                <groupExpression><![CDATA[$F{seq_turma}]]></groupExpression>
                <groupHeader>
                        <band height="60">
                                <rectangle>
                                        <reportElement uuid="ffab1a50-2f09-4649-bfbb-ef67c9ba6df8" x="0" y="0" width="556" height="20" backcolor="#CCCCCC"/>
                                </rectangle>
                                <textField isStretchWithOverflow="true">
                                        <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" x="0" y="0" width="557" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                                <paragraph leftIndent="5" rightIndent="5"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA["CAPACITAÇÃO: " + $F{dsc_capacitacao}]]></textFieldExpression>
                                </textField>
                                <rectangle>
                                        <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="40" width="200" height="20" isPrintWhenDetailOverflows="true" backcolor="#FFFFFF"/>
                                </rectangle>
                                <rectangle>
                                        <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" positionType="Float" stretchType="RelativeToBandHeight" x="200" y="40" width="356" height="20" isPrintWhenDetailOverflows="true" backcolor="#FFFFFF"/>
                                </rectangle>
                                <textField isStretchWithOverflow="true">
                                        <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="40" width="200" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                                <paragraph leftIndent="5" rightIndent="5"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA[$F{seq_turma}]]></textFieldExpression>
                                </textField>
                                <textField isStretchWithOverflow="true">
                                        <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" stretchType="RelativeToBandHeight" x="200" y="40" width="357" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                                <paragraph leftIndent="5" rightIndent="5"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA[$F{dsc_unidade}]]></textFieldExpression>
                                </textField>
                                <rectangle>
                                        <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="200" y="20" width="356" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                </rectangle>
                                <rectangle>
                                        <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="20" width="200" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                </rectangle>
                                <staticText>
                                        <reportElement uuid="1f2a1c8c-bd8a-4d26-9d1c-8fb5b1bd5cba" x="202" y="20" width="355" height="20"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font isBold="true" isPdfEmbedded="false"/>
                                        </textElement>
                                        <text><![CDATA[UNIDADE SOLICITANTE]]></text>
                                </staticText>
                                <staticText>
                                        <reportElement uuid="adf263e6-1fd6-4bdd-81e1-11434eb9de59" x="0" y="20" width="200" height="20"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font isBold="true" isPdfEmbedded="false"/>
                                        </textElement>
                                        <text><![CDATA[TURMA]]></text>
                                </staticText>
                        </band>
                </groupHeader>
                <groupFooter>
                        <band height="40">
                                <printWhenExpression><![CDATA[$F{num_processo} != null]]></printWhenExpression>
                                <staticText>
                                        <reportElement uuid="1f2a1c8c-bd8a-4d26-9d1c-8fb5b1bd5cba" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="10" width="400" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                        <textElement textAlignment="Right" verticalAlignment="Middle">
                                                <font isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                                <paragraph leftIndent="5" rightIndent="5"/>
                                        </textElement>
                                        <text><![CDATA[TOTAL ORÇADO DA CAPACITAÇÃO:]]></text>
                                </staticText>
                                <rectangle>
                                        <reportElement uuid="eb5a69cf-c7a4-484b-ac04-56807475c8ed" positionType="Float" stretchType="RelativeToBandHeight" x="401" y="10" width="155" height="20" isPrintWhenDetailOverflows="true"/>
                                </rectangle>
                                <textField isStretchWithOverflow="true" pattern="¤ #,##0.00" isBlankWhenNull="false">
                                        <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" stretchType="RelativeToBandHeight" x="401" y="10" width="156" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle" markup="styled">
                                                <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                                <paragraph lineSpacing="Single" leftIndent="5" rightIndent="5"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA[$V{TOTAL ORCADO}]]></textFieldExpression>
                                </textField>
                        </band>
                </groupFooter>
        </group>
        <group name="Processos">
                <groupExpression><![CDATA[$F{num_processo}]]></groupExpression>
                <groupHeader>
                        <band height="60">
                                <printWhenExpression><![CDATA[$F{num_processo} != null]]></printWhenExpression>
                                <rectangle>
                                        <reportElement uuid="120af1d1-b316-415f-b102-83ad5f74b889" positionType="Float" x="0" y="20" width="556" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                </rectangle>
                                <rectangle>
                                        <reportElement uuid="8acf1270-ae04-4b1d-9d35-e2676db01f40" positionType="Float" x="200" y="40" width="201" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                </rectangle>
                                <rectangle>
                                        <reportElement uuid="120af1d1-b316-415f-b102-83ad5f74b889" positionType="Float" x="0" y="0" width="556" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                </rectangle>
                                <rectangle>
                                        <reportElement uuid="7399afa6-e12e-4239-b2f7-4d8ab3ebedd2" positionType="Float" x="0" y="40" width="200" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                </rectangle>
                                <staticText>
                                        <reportElement uuid="adf263e6-1fd6-4bdd-81e1-11434eb9de59" positionType="Float" x="0" y="40" width="199" height="20" isPrintWhenDetailOverflows="true"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font isBold="true" isPdfEmbedded="false"/>
                                        </textElement>
                                        <text><![CDATA[ELEMENTO DE DESPESA]]></text>
                                </staticText>
                                <staticText>
                                        <reportElement uuid="68a8ca28-9bab-47ec-8436-06ea9e2e99a1" positionType="Float" mode="Transparent" x="2" y="20" width="555" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font fontName="Arial" isBold="true"/>
                                                <paragraph leftIndent="5" rightIndent="5"/>
                                        </textElement>
                                        <text><![CDATA[DESPESAS]]></text>
                                </staticText>
                                <rectangle>
                                        <reportElement uuid="eb5a69cf-c7a4-484b-ac04-56807475c8ed" positionType="Float" x="401" y="40" width="155" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                </rectangle>
                                <staticText>
                                        <reportElement uuid="1f2a1c8c-bd8a-4d26-9d1c-8fb5b1bd5cba" positionType="Float" x="202" y="40" width="200" height="20" isPrintWhenDetailOverflows="true"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font isBold="true" isPdfEmbedded="false"/>
                                        </textElement>
                                        <text><![CDATA[FONTE DE RECURSO]]></text>
                                </staticText>
                                <staticText>
                                        <reportElement uuid="08d3d480-bdf2-4f5a-b048-c9b7669eef91" positionType="Float" x="402" y="40" width="155" height="20" isPrintWhenDetailOverflows="true"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font isBold="true" isPdfEmbedded="false"/>
                                        </textElement>
                                        <text><![CDATA[VALOR ORÇADO]]></text>
                                </staticText>
                                <textField isStretchWithOverflow="true">
                                        <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" x="2" y="0" width="555" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                        <textElement verticalAlignment="Middle" markup="styled">
                                                <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                                <paragraph lineSpacing="Single" leftIndent="5" rightIndent="5"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA["PROCESSO: " + $F{cod_orgao_processo}.toString()  + " - " + $F{num_processo}.toString() + "/" + $F{dsc_ano_processo}]]></textFieldExpression>
                                </textField>
                        </band>
                </groupHeader>
        </group>
        <pageHeader>
                <band height="128">
                        <staticText>
                                <reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="48" width="557" height="36"/>
                                <textElement textAlignment="Center" verticalAlignment="Top">
                                        <font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica" isPdfEmbedded="true"/>
                                </textElement>
                                <text><![CDATA[Secretaria de Estado da Saúde
Coordenadoria Setorial de Gestão e Desenvolvimento de Pessoas
Gerência de Desenvolvimento e Educação de Pessoas
]]></text>
                        </staticText>
                        <image scaleImage="RealSize" hAlign="Center" vAlign="Middle" onErrorType="Icon">
                                <reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" positionType="Float" mode="Transparent" x="258" y="0" width="33" height="36"/>
                                <imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.png"]]></imageExpression>
                        </image>
                        <staticText>
                                <reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="37" width="557" height="12"/>
                                <textElement textAlignment="Center" verticalAlignment="Top">
                                        <font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                </textElement>
                                <text><![CDATA[Estado de Alagoas]]></text>
                        </staticText>
                        <staticText>
                                <reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="92" width="557" height="12"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                </textElement>
                                <text><![CDATA[Relatório de Despesas]]></text>
                        </staticText>
                        <textField>
                                <reportElement uuid="57d2ab81-9a8b-4a93-90d3-a095ee79ecc4" x="0" y="105" width="557" height="12"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$P{MES} == null ? "Período de Exercício: " + $P{ANO} : "Período de Exercício: " + $P{MES} + "/" + $P{ANO}]]></textFieldExpression>
                        </textField>
                </band>
        </pageHeader>
        <detail>
                <band height="20">
                        <printWhenExpression><![CDATA[$F{num_processo} != null]]></printWhenExpression>
                        <rectangle>
                                <reportElement uuid="7399afa6-e12e-4239-b2f7-4d8ab3ebedd2" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="0" width="200" height="20" isPrintWhenDetailOverflows="true"/>
                        </rectangle>
                        <rectangle>
                                <reportElement uuid="8acf1270-ae04-4b1d-9d35-e2676db01f40" positionType="Float" stretchType="RelativeToBandHeight" x="200" y="0" width="201" height="20" isPrintWhenDetailOverflows="true"/>
                        </rectangle>
                        <rectangle>
                                <reportElement uuid="eb5a69cf-c7a4-484b-ac04-56807475c8ed" positionType="Float" stretchType="RelativeToBandHeight" x="401" y="0" width="155" height="20" isPrintWhenDetailOverflows="true"/>
                        </rectangle>
                        <textField isStretchWithOverflow="true">
                                <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="0" width="200" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                <textElement verticalAlignment="Middle" markup="styled">
                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                        <paragraph lineSpacing="Single" leftIndent="5" rightIndent="5"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{dsc_elemento_despesa}]]></textFieldExpression>
                        </textField>
                        <textField isStretchWithOverflow="true">
                                <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" stretchType="RelativeToBandHeight" x="200" y="0" width="201" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                <textElement verticalAlignment="Middle" markup="styled">
                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                        <paragraph lineSpacing="Single" leftIndent="5" rightIndent="5"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{dsc_fonte_recurso}]]></textFieldExpression>
                        </textField>
                        <textField isStretchWithOverflow="true" pattern="¤ #,##0.00">
                                <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" stretchType="RelativeToBandHeight" x="401" y="0" width="156" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle" markup="styled">
                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                        <paragraph lineSpacing="Single" leftIndent="5" rightIndent="5"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{val_orcado}]]></textFieldExpression>
                        </textField>
                </band>
        </detail>
        <pageFooter>
                <band height="15">
                        <textField isBlankWhenNull="true">
                                <reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="0" width="374" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA["Gerado por " + $P{NOM_USUARIO} + ", CPF: " + $P{CPF_USUARIO} + new java.text.SimpleDateFormat("', em 'dd 'de' MMMMM 'de' yyyy' às 'HH:mm", new Locale("pt", "BR")).format(new java.util.Date()).toUpperCase()]]></textFieldExpression>
                        </textField>
                        <textField isBlankWhenNull="false">
                                <reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="428" y="0" 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 evaluationTime="Report" isBlankWhenNull="false">
                                <reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="502" y="0" width="52" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
                        </textField>
                </band>
        </pageFooter>
        <summary>
                <band height="40">
                        <rectangle>
                                <reportElement uuid="eb5a69cf-c7a4-484b-ac04-56807475c8ed" positionType="Float" stretchType="RelativeToBandHeight" x="401" y="10" width="155" height="20" isPrintWhenDetailOverflows="true"/>
                        </rectangle>
                        <staticText>
                                <reportElement uuid="1f2a1c8c-bd8a-4d26-9d1c-8fb5b1bd5cba" positionType="Float" stretchType="RelativeToBandHeight" x="1" y="10" width="400" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                <textElement textAlignment="Right" verticalAlignment="Middle">
                                        <font isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                        <paragraph leftIndent="5" rightIndent="5"/>
                                </textElement>
                                <text><![CDATA[TOTAL ORÇADO DE DESPESAS:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" pattern="¤ #,##0.00" isBlankWhenNull="false">
                                <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" stretchType="RelativeToBandHeight" x="401" y="10" width="156" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle" markup="styled">
                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                        <paragraph lineSpacing="Single" leftIndent="5" rightIndent="5"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$V{TOTAL} != null ? $V{TOTAL} : 0.00]]></textFieldExpression>
                        </textField>
                </band>
        </summary>
</jasperReport>