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="556" pageHeight="842" whenNoDataType="NoDataSection" columnWidth="556" 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="SEQ_TURMA" class="java.lang.Long">
7 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
8 
	</parameter>
9 
	<queryString>
10 
		<![CDATA[SELECT
11 
pe.dth_data_inicial,
12 
pe.dth_data_final
13 
FROM sc_scs.scs_turma tu
14 
INNER JOIN sc_scs.scs_turma_periodo pe ON tu.seq_turma = pe.seq_turma
15 
WHERE tu.seq_turma = $P{SEQ_TURMA}
16 
ORDER BY pe.dth_data_inicial]]>
17 
	</queryString>
18 
	<field name="dth_data_inicial" class="java.sql.Timestamp"/>
19 
	<field name="dth_data_final" class="java.sql.Timestamp"/>
20 
	<columnHeader>
21 
		<band height="40">
22 
			<rectangle>
23 
				<reportElement uuid="517180ca-ccbe-4e5d-8790-b8dd56a8fff3" x="0" y="20" width="279" height="20" isRemoveLineWhenBlank="true" backcolor="#CCCCCC"/>
24 
			</rectangle>
25 
			<rectangle>
26 
				<reportElement uuid="d36c861b-1edd-46ff-9d75-687d81f14f9c" x="279" y="20" width="277" height="20" isRemoveLineWhenBlank="true" backcolor="#CCCCCC"/>
27 
			</rectangle>
28 
			<staticText>
29 
				<reportElement uuid="8de517ab-c1d1-4b43-aa27-fe310862d014" x="0" y="20" width="279" height="20" isRemoveLineWhenBlank="true"/>
30 
				<textElement textAlignment="Center" verticalAlignment="Middle">
31 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
32 
				</textElement>
33 
				<text><![CDATA[DATA E HORA INICIAL]]></text>
34 
			</staticText>
35 
			<staticText>
36 
				<reportElement uuid="cdf9f858-4462-4786-b22b-8c237db1f422" x="279" y="20" width="277" height="20" isRemoveLineWhenBlank="true"/>
37 
				<textElement textAlignment="Center" verticalAlignment="Middle">
38 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
39 
				</textElement>
40 
				<text><![CDATA[DATA E HORA FINAL]]></text>
41 
			</staticText>
42 
			<rectangle>
43 
				<reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="0" width="556" height="20" isRemoveLineWhenBlank="true" backcolor="#CCCCCC"/>
44 
			</rectangle>
45 
			<staticText>
46 
				<reportElement uuid="7d9c1dd6-2f35-43d8-a3ed-ea5b2af0952a" x="0" y="0" width="556" height="20" isRemoveLineWhenBlank="true"/>
47 
				<textElement textAlignment="Center" verticalAlignment="Middle">
48 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
49 
					<paragraph leftIndent="5"/>
50 
				</textElement>
51 
				<text><![CDATA[PERÍODOS]]></text>
52 
			</staticText>
53 
		</band>
54 
	</columnHeader>
55 
	<detail>
56 
		<band height="20">
57 
			<rectangle>
58 
				<reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="0" width="555" height="20" backcolor="#FFFFFF"/>
59 
			</rectangle>
60 
			<rectangle>
61 
				<reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="279" y="0" width="277" height="20" backcolor="#FFFFFF"/>
62 
			</rectangle>
63 
			<textField isBlankWhenNull="true">
64 
				<reportElement uuid="3c3fb7fa-b427-4fae-afe9-af7a7db43103" x="0" y="0" width="279" height="20"/>
65 
				<textElement textAlignment="Center" verticalAlignment="Middle">
66 
					<font fontName="Arial" isBold="false"/>
67 
					<paragraph leftIndent="5"/>
68 
				</textElement>
69 
				<textFieldExpression><![CDATA[new java.text.SimpleDateFormat("dd'/'MM'/'yyyy 'às' HH:mm", new Locale("pt", "BR")).format($F{dth_data_inicial})]]></textFieldExpression>
70 
			</textField>
71 
			<textField isBlankWhenNull="true">
72 
				<reportElement uuid="103e38a4-442b-4954-b18b-5a293555f50a" x="279" y="0" width="277" height="20"/>
73 
				<textElement textAlignment="Center" verticalAlignment="Middle">
74 
					<font fontName="Arial" isBold="false"/>
75 
					<paragraph leftIndent="5"/>
76 
				</textElement>
77 
				<textFieldExpression><![CDATA[new java.text.SimpleDateFormat("dd'/'MM'/'yyyy 'às' HH:mm", new Locale("pt", "BR")).format($F{dth_data_final})]]></textFieldExpression>
78 
			</textField>
79 
		</band>
80 
	</detail>
81 
	<noData>
82 
		<band height="20">
83 
			<rectangle>
84 
				<reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="0" width="556" height="20" isRemoveLineWhenBlank="true" backcolor="#CCCCCC"/>
85 
			</rectangle>
86 
			<staticText>
87 
				<reportElement uuid="7d9c1dd6-2f35-43d8-a3ed-ea5b2af0952a" x="-1" y="0" width="557" height="20" isRemoveLineWhenBlank="true">
88 
					<printWhenExpression><![CDATA[$F{dth_data_inicial} == null]]></printWhenExpression>
89 
				</reportElement>
90 
				<textElement textAlignment="Center" verticalAlignment="Middle">
91 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
92 
					<paragraph leftIndent="5"/>
93 
				</textElement>
94 
				<text><![CDATA[NÃO POSSUI PERÍODOS ]]></text>
95 
			</staticText>
96 
		</band>
97 
	</noData>
98 
</jasperReport>