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.3310000000000004"/>
4 
	<property name="ireport.x" value="0"/>
5 
	<property name="ireport.y" value="0"/>
6 
	<parameter name="SEQ_TURMA" class="java.lang.Long">
7 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
8 
	</parameter>
9 
	<queryString>
10 
		<![CDATA[SELECT
11 
tr.seq_turma,
12 
pe.dth_data_inicial,
13 
pe.dth_data_final
14 
FROM sc_scs.scs_turma tr
15 
LEFT JOIN sc_scs.scs_turma_periodo pe ON tr.seq_turma = pe.seq_turma
16 
WHERE tr.seq_turma = $P{SEQ_TURMA}
17 
ORDER BY pe.dth_data_inicial]]>
18 
	</queryString>
19 
	<field name="seq_turma" class="java.lang.Long"/>
20 
	<field name="dth_data_inicial" class="java.sql.Timestamp"/>
21 
	<field name="dth_data_final" class="java.sql.Timestamp"/>
22 
	<group name="Turma">
23 
		<groupExpression><![CDATA[$F{seq_turma}]]></groupExpression>
24 
		<groupHeader>
25 
			<band height="40">
26 
				<rectangle>
27 
					<reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="0" width="555" height="20" backcolor="#FFFFFF"/>
28 
				</rectangle>
29 
				<textField>
30 
					<reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" mode="Transparent" x="1" y="0" width="554" height="20" backcolor="#FFFFFF"/>
31 
					<textElement verticalAlignment="Middle">
32 
						<font fontName="Arial" isBold="false" isPdfEmbedded="false"/>
33 
						<paragraph leftIndent="5"/>
34 
					</textElement>
35 
					<textFieldExpression><![CDATA["TURMA: " + $F{seq_turma}]]></textFieldExpression>
36 
				</textField>
37 
				<rectangle>
38 
					<reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="20" width="555" height="20" isRemoveLineWhenBlank="true" backcolor="#FFFFFF"/>
39 
				</rectangle>
40 
				<staticText>
41 
					<reportElement uuid="7d9c1dd6-2f35-43d8-a3ed-ea5b2af0952a" x="0" y="20" width="555" height="20" isRemoveLineWhenBlank="true">
42 
						<printWhenExpression><![CDATA[$F{dth_data_inicial} != null]]></printWhenExpression>
43 
					</reportElement>
44 
					<textElement verticalAlignment="Middle">
45 
						<font fontName="Arial"/>
46 
						<paragraph leftIndent="5"/>
47 
					</textElement>
48 
					<text><![CDATA[PERÍODOS:]]></text>
49 
				</staticText>
50 
			</band>
51 
		</groupHeader>
52 
	</group>
53 
	<detail>
54 
		<band height="20">
55 
			<printWhenExpression><![CDATA[$F{dth_data_inicial} != null]]></printWhenExpression>
56 
			<rectangle>
57 
				<reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="0" width="555" height="20" backcolor="#FFFFFF"/>
58 
			</rectangle>
59 
			<rectangle>
60 
				<reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="279" y="0" width="276" height="20" backcolor="#FFFFFF"/>
61 
			</rectangle>
62 
			<textField isBlankWhenNull="true">
63 
				<reportElement uuid="3c3fb7fa-b427-4fae-afe9-af7a7db43103" x="0" y="0" width="279" height="20"/>
64 
				<textElement verticalAlignment="Middle">
65 
					<font fontName="Arial" isBold="false"/>
66 
					<paragraph leftIndent="5"/>
67 
				</textElement>
68 
				<textFieldExpression><![CDATA[new java.text.SimpleDateFormat("'DATA E HORA INICIAL: 'dd'/'MM'/'yyyy 'às' HH:mm", new Locale("pt", "BR")).format($F{dth_data_inicial})]]></textFieldExpression>
69 
			</textField>
70 
			<textField isBlankWhenNull="true">
71 
				<reportElement uuid="103e38a4-442b-4954-b18b-5a293555f50a" x="279" y="0" width="276" height="20"/>
72 
				<textElement verticalAlignment="Middle">
73 
					<font fontName="Arial" isBold="false"/>
74 
					<paragraph leftIndent="5"/>
75 
				</textElement>
76 
				<textFieldExpression><![CDATA[new java.text.SimpleDateFormat("'DATA E HORA FINAL: 'dd'/'MM'/'yyyy 'às' HH:mm", new Locale("pt", "BR")).format($F{dth_data_final})]]></textFieldExpression>
77 
			</textField>
78 
		</band>
79 
	</detail>
80 
</jasperReport>