<?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="Pré matrícula alocação" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<queryString>
		<![CDATA[SELECT
	*
FROM
	qry_alunos_sem_alocacao]]>
	</queryString>
	<field name="id_pre_matricula" class="java.lang.Integer"/>
	<field name="nome_aluno" class="java.lang.String"/>
	<field name="id_escola_pre_matricula" class="java.lang.Integer"/>
	<field name="nome_curso" class="java.lang.String"/>
	<field name="nome_ano_serie" class="java.lang.String"/>
	<group name="nome_ano_serie" isStartNewPage="true" footerPosition="ForceAtBottom">
		<groupExpression><![CDATA[$F{nome_ano_serie}]]></groupExpression>
		<groupHeader>
			<band height="42">
				<textField>
					<reportElement x="2" y="3" width="552" height="18"/>
					<textElement>
						<font fontName="Courier New" size="14" isBold="true" isItalic="false"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{nome_ano_serie}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="115" y="26" width="309" height="13"/>
					<textElement>
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Nome do aluno:]]></text>
				</staticText>
				<staticText>
					<reportElement x="2" y="26" width="113" height="13"/>
					<textElement>
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Pré-Matrícula:]]></text>
				</staticText>
				<staticText>
					<reportElement x="438" y="26" width="113" height="13"/>
					<textElement>
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Ano/Série:]]></text>
				</staticText>
			</band>
		</groupHeader>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="86" splitType="Stretch">
			<staticText>
				<reportElement x="2" y="0" width="293" height="17"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Estado do Rio de Janeiro]]></text>
			</staticText>
			<staticText>
				<reportElement x="2" y="21" width="293" height="17"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[PREFEITURA MUNICIPAL DE TERESÓPOLIS]]></text>
			</staticText>
			<staticText>
				<reportElement x="2" y="41" width="293" height="17"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Secretaria Municipal de Educação]]></text>
			</staticText>
			<staticText>
				<reportElement x="2" y="59" width="293" height="17"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Listagem de alunos sem alocação]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="16" splitType="Stretch">
			<textField>
				<reportElement x="115" y="2" width="309" height="14"/>
				<textElement>
					<font fontName="Courier New" size="8" isBold="false" isItalic="false"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nome_aluno}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="438" y="2" width="84" height="14"/>
				<textElement>
					<font fontName="Courier New" size="8" isBold="false" isItalic="false"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nome_ano_serie}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="2" y="2" width="100" height="14"/>
				<textElement>
					<font fontName="Courier New" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{id_pre_matricula}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="23" splitType="Stretch">
			<textField>
				<reportElement x="438" y="2" width="80" height="20"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report">
				<reportElement x="518" y="2" width="36" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy">
				<reportElement x="2" y="2" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="27" splitType="Stretch"/>
	</summary>
</jasperReport>
