<?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="Laporan_Prestasi_Siswa" language="groovy" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="317b67ab-74cb-47d0-9f74-86c203d587c0">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<style name="Title" fontName="Times New Roman" fontSize="50" isBold="true" pdfFontName="Times-Bold"/>
	<style name="SubTitle" forecolor="#736343" fontName="Arial" fontSize="18"/>
	<style name="Column header" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/>
	<style name="Detail" fontName="Arial" fontSize="12"/>
	<style name="Row" mode="Transparent">
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
			<style backcolor="#E6DAC3"/>
		</conditionalStyle>
	</style>
	<queryString language="SQL">
		<![CDATA[SELECT
     prestasi.`id` AS prestasi_id,
     prestasi.`prestasi` AS prestasi_prestasi,
     prestasi.`keterangan` AS prestasi_keterangan,
     siswa.`no_daftar` AS siswa_no_daftar,
     siswa.`nama_siswa` AS siswa_nama_siswa,
     siswa.`nis` AS siswa_nis
FROM
     `siswa` siswa INNER JOIN `prestasi` prestasi ON siswa.`no_daftar` = prestasi.`id`]]>
	</queryString>
	<field name="siswa_nis" class="java.lang.Integer"/>
	<field name="siswa_nama_siswa" class="java.lang.String"/>
	<field name="prestasi_prestasi" class="java.lang.String"/>
	<field name="prestasi_keterangan" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="136" splitType="Stretch">
			<image>
				<reportElement x="43" y="20" width="114" height="102" uuid="302527fb-db86-4c79-b47f-fabc9885cca1"/>
				<imageExpression><![CDATA["C:\\Users\\user\\Downloads\\10-03-tgl24\\sdit.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="172" y="73" width="298" height="18" uuid="b7c6d8f9-4509-401a-9f4f-09e50a89f36c"/>
				<textElement textAlignment="Center">
					<font size="13" isBold="false"/>
				</textElement>
				<text><![CDATA[Gg. Lurah Muda Blok Gapura No.40, Rt.03/Rw.03, Cimanggis]]></text>
			</staticText>
			<line>
				<reportElement x="0" y="9" width="555" height="1" uuid="8d6e0fb9-411d-495e-8e4c-6344e09c2c7a"/>
				<graphicElement>
					<pen lineWidth="1.25"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement x="157" y="25" width="319" height="48" uuid="a9032c0f-3502-4c22-b147-ab5765d479d6"/>
				<textElement textAlignment="Center">
					<font fontName="SansSerif" size="36" isBold="true"/>
				</textElement>
				<text><![CDATA[SDIT Daarul Fataa]]></text>
			</staticText>
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="131" width="555" height="1" uuid="8a068164-39b8-49c2-a7b7-17f7a3312077"/>
				<graphicElement>
					<pen lineWidth="1.25"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement x="201" y="91" width="227" height="18" uuid="4a0ff39d-9e79-4745-9452-f2bc4e2b61d6"/>
				<textElement textAlignment="Center">
					<font size="13" isBold="false"/>
				</textElement>
				<text><![CDATA[Kec. Bojong Gede, Bogor, Jawa Barat 16920]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band height="67">
			<staticText>
				<reportElement x="86" y="19" width="371" height="33" uuid="9e90d9a2-e137-440a-9184-061314f54d55"/>
				<textElement textAlignment="Center">
					<font size="24" isBold="true"/>
				</textElement>
				<text><![CDATA[Laporan Prestasi Seluruh Siswa]]></text>
			</staticText>
			<line>
				<reportElement x="1" y="13" width="554" height="1" uuid="749d91dd-5a35-4f11-b6fa-39abf38bec4d"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Double" lineColor="#000000"/>
				</graphicElement>
			</line>
			<line>
				<reportElement x="1" y="57" width="554" height="1" uuid="67641960-0828-4b05-8969-26da5fef6fe2"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Double" lineColor="#000000"/>
				</graphicElement>
			</line>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="16" splitType="Stretch">
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="15" width="555" height="1" uuid="fa482e15-1381-4d42-b7e0-26c194878cc0"/>
				<graphicElement>
					<pen lineWidth="0.5" lineColor="#999999"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement style="Column header" mode="Opaque" x="0" y="0" width="138" height="15" forecolor="#736343" backcolor="#CCCCCC" uuid="99b9f47b-0757-441d-921a-2e5ed39cea01"/>
				<textElement textAlignment="Center"/>
				<text><![CDATA[NIS]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" mode="Opaque" x="138" y="0" width="138" height="15" forecolor="#736343" backcolor="#CCCCCC" uuid="e9870471-3986-40a7-9c4b-3b37bfcbdbe1"/>
				<textElement textAlignment="Center"/>
				<text><![CDATA[Nama Siswa]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" mode="Opaque" x="276" y="0" width="138" height="15" forecolor="#736343" backcolor="#CCCCCC" uuid="1a409b67-7e63-42d2-94ac-1b9615b987a2"/>
				<textElement textAlignment="Center"/>
				<text><![CDATA[Prestasi]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" mode="Opaque" x="414" y="0" width="141" height="15" forecolor="#736343" backcolor="#CCCCCC" uuid="24256560-84b7-467a-9c11-d6c6eeae57c8"/>
				<textElement textAlignment="Center"/>
				<text><![CDATA[Keterangan]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="15" splitType="Stretch">
			<frame>
				<reportElement style="Row" mode="Opaque" x="0" y="0" width="555" height="15" uuid="67443d29-4581-4134-b0f2-1d5122e53f09"/>
				<textField isStretchWithOverflow="true">
					<reportElement style="Detail" x="0" y="0" width="138" height="15" uuid="f961dae9-de06-42fb-96b0-c8fa8598634c"/>
					<textElement textAlignment="Center"/>
					<textFieldExpression><![CDATA[$F{siswa_nis}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement style="Detail" x="138" y="0" width="138" height="15" uuid="7598b32d-4520-4a95-be03-9f308fcfd064"/>
					<textElement textAlignment="Center"/>
					<textFieldExpression><![CDATA[$F{siswa_nama_siswa}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement style="Detail" x="276" y="0" width="138" height="15" uuid="96ac87ad-4da8-4c5d-b890-df53e625d1ba"/>
					<textElement textAlignment="Center"/>
					<textFieldExpression><![CDATA[$F{prestasi_prestasi}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement style="Detail" x="414" y="0" width="141" height="15" uuid="9cc01d11-ae2b-43d6-9f9d-c2dc9eef7196"/>
					<textElement textAlignment="Center"/>
					<textFieldExpression><![CDATA[$F{prestasi_keterangan}]]></textFieldExpression>
				</textField>
			</frame>
		</band>
	</detail>
	<columnFooter>
		<band height="157" splitType="Stretch">
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="3" width="555" height="1" uuid="aa2a7785-5926-4989-a578-d81389971c3b"/>
				<graphicElement>
					<pen lineWidth="0.5" lineColor="#999999"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement x="418" y="53" width="93" height="19" uuid="8b8ceef7-4883-49d4-aa16-20d4b693449d"/>
				<textElement>
					<font size="12" isBold="false"/>
				</textElement>
				<text><![CDATA[Kepala Sekolah]]></text>
			</staticText>
			<staticText>
				<reportElement x="390" y="34" width="40" height="19" uuid="5442ce26-b664-4cd0-a3d5-e280a2d96988"/>
				<textElement>
					<font size="12" isBold="false"/>
				</textElement>
				<text><![CDATA[Bogor,]]></text>
			</staticText>
			<staticText>
				<reportElement x="388" y="122" width="151" height="27" uuid="3d939c90-4982-4536-a0db-3b8ddcde156a"/>
				<textElement>
					<font size="12" isBold="false"/>
				</textElement>
				<text><![CDATA[( Siti Zuhriah, SPd, M.Pd.I )]]></text>
			</staticText>
			<textField pattern="EEEEE dd MMMMM yyyy">
				<reportElement x="429" y="34" width="126" height="19" uuid="b48f13a9-814b-4c2a-b386-e3aa7f027a17"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
		</band>
	</columnFooter>
	<pageFooter>
		<band height="25" splitType="Stretch">
			<frame>
				<reportElement mode="Opaque" x="-21" y="1" width="597" height="24" forecolor="#D0B48E" backcolor="#F2EBDF" uuid="8e17e52b-e662-47a6-9151-4d232a8dd22c"/>
				<textField evaluationTime="Report">
					<reportElement style="Column header" x="507" y="0" width="40" height="20" forecolor="#736343" uuid="7da42134-4b75-49bf-a75d-8b880d721fa5"/>
					<textElement verticalAlignment="Middle">
						<font size="10" isBold="false"/>
					</textElement>
					<textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement style="Column header" x="428" y="0" width="80" height="20" forecolor="#736343" uuid="0a62a0b3-2114-44e1-ae96-9c2617a606b1"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="10" isBold="false"/>
					</textElement>
					<textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
				</textField>
			</frame>
		</band>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
