Subversion Repositories Integrator Subversion

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
1 espaco 1 
<?xml version="1.0" encoding="UTF-8"?>
2 
<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">
3 
	<property name="ireport.zoom" value="1.5"/>
4 
	<property name="ireport.x" value="0"/>
5 
	<property name="ireport.y" value="0"/>
6 
	<parameter name="IMAGEM_DIR" class="java.lang.String">
7 
		<defaultValueExpression><![CDATA["C:\\"]]></defaultValueExpression>
8 
	</parameter>
9 
	<parameter name="SEQ_PESSOA_FISICA" class="java.lang.Long">
10 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
11 
	</parameter>
12 
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
13 
		<defaultValueExpression><![CDATA["C:\\Repositorio\\DESENVOLVIMENTO\\SESAU\\JAVA\\Repositorio\\rhcapacitacao\\FONTES\\IMPLEMENTACAO\\DESENVOLVIMENTO\\scs\\scs-core\\src\\main\\resources\\relatorios\\"]]></defaultValueExpression>
14 
	</parameter>
15 
	<parameter name="ANO" class="java.lang.Integer">
16 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
17 
	</parameter>
18 
	<queryString>
19 
		<![CDATA[SELECT
20 
tu.num_ano
21 
FROM sc_scs.scs_turma_participante tp
22 
INNER JOIN sc_scs.scs_turma tu ON tp.seq_turma = tu.seq_turma
23 
WHERE tp.seq_pessoa_participante = $P{SEQ_PESSOA_FISICA} AND (tu.num_ano = $P{ANO} OR $P{ANO} IS NULL)
24 
GROUP BY tu.num_ano ORDER BY tu.num_ano DESC]]>
25 
	</queryString>
26 
	<field name="num_ano" class="java.lang.Integer"/>
27 
	<group name="Ano">
28 
		<groupExpression><![CDATA[$F{num_ano}]]></groupExpression>
29 
		<groupHeader>
30 
			<band height="30">
31 
				<rectangle>
32 
					<reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="10" width="555" height="20" backcolor="#CCCCCC"/>
33 
				</rectangle>
34 
				<textField>
35 
					<reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" x="0" y="10" width="555" height="20" backcolor="#CCCCCC"/>
36 
					<textElement textAlignment="Center" verticalAlignment="Middle">
37 
						<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
38 
						<paragraph leftIndent="10"/>
39 
					</textElement>
40 
					<textFieldExpression><![CDATA["ANO DE EXERCÍCIO: " + $F{num_ano}]]></textFieldExpression>
41 
				</textField>
42 
			</band>
43 
		</groupHeader>
44 
	</group>
45 
	<detail>
46 
		<band height="20">
47 
			<subreport>
48 
				<reportElement uuid="5fecb4d8-f805-452f-8d4a-03759c5b7f31" x="0" y="0" width="555" height="20" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true"/>
49 
				<subreportParameter name="SUBREPORT_DIR">
50 
					<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
51 
				</subreportParameter>
52 
				<subreportParameter name="SEQ_PESSOA_FISICA">
53 
					<subreportParameterExpression><![CDATA[$P{SEQ_PESSOA_FISICA}]]></subreportParameterExpression>
54 
				</subreportParameter>
55 
				<subreportParameter name="ANO">
56 
					<subreportParameterExpression><![CDATA[$F{num_ano}]]></subreportParameterExpression>
57 
				</subreportParameter>
58 
				<subreportParameter name="IMAGEM_DIR">
59 
					<subreportParameterExpression><![CDATA[$P{IMAGEM_DIR}]]></subreportParameterExpression>
60 
				</subreportParameter>
61 
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
62 
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorioCapacitacaoPorParticipante_sub_capacitacao.jasper"]]></subreportExpression>
63 
			</subreport>
64 
		</band>
65 
	</detail>
66 
</jasperReport>