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="relatorioCapacitacaoPorParticipante" pageWidth="555" pageHeight="842" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="85d4a540-608e-4934-8f57-57cec53afb74">
        <property name="ireport.zoom" value="1.5"/>
        <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="SEQ_PESSOA_FISICA" class="java.lang.Long">
                <defaultValueExpression><![CDATA[]]></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="ANO" class="java.lang.Integer">
                <defaultValueExpression><![CDATA[]]></defaultValueExpression>
        </parameter>
        <queryString>
                <![CDATA[SELECT
tu.num_ano
FROM sc_scs.scs_turma_participante tp
INNER JOIN sc_scs.scs_turma tu ON tp.seq_turma = tu.seq_turma
WHERE tp.seq_pessoa_participante = $P{SEQ_PESSOA_FISICA} AND (tu.num_ano = $P{ANO} OR $P{ANO} IS NULL)
GROUP BY tu.num_ano ORDER BY tu.num_ano DESC]]>
        </queryString>
        <field name="num_ano" class="java.lang.Integer"/>
        <group name="Ano">
                <groupExpression><![CDATA[$F{num_ano}]]></groupExpression>
                <groupHeader>
                        <band height="30">
                                <rectangle>
                                        <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="10" width="555" height="20" backcolor="#CCCCCC"/>
                                </rectangle>
                                <textField>
                                        <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" x="0" y="10" width="555" height="20" backcolor="#CCCCCC"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                                <paragraph leftIndent="10"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA["ANO DE EXERCÍCIO: " + $F{num_ano}]]></textFieldExpression>
                                </textField>
                        </band>
                </groupHeader>
        </group>
        <detail>
                <band height="20">
                        <subreport>
                                <reportElement uuid="5fecb4d8-f805-452f-8d4a-03759c5b7f31" x="0" y="0" width="555" height="20" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true"/>
                                <subreportParameter name="SUBREPORT_DIR">
                                        <subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="SEQ_PESSOA_FISICA">
                                        <subreportParameterExpression><![CDATA[$P{SEQ_PESSOA_FISICA}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="ANO">
                                        <subreportParameterExpression><![CDATA[$F{num_ano}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="IMAGEM_DIR">
                                        <subreportParameterExpression><![CDATA[$P{IMAGEM_DIR}]]></subreportParameterExpression>
                                </subreportParameter>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorioCapacitacaoPorParticipante_sub_capacitacao.jasper"]]></subreportExpression>
                        </subreport>
                </band>
        </detail>
</jasperReport>