<?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="Employees" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="515" leftMargin="40" rightMargin="40" topMargin="50" bottomMargin="50">
	<property name="net.sf.jasperreports.export.pdf.tagged" value="true"/>
	<property name="net.sf.jasperreports.export.pdf.tag.language" value="EN-US"/>
	<style name="Sans_Normal" isDefault="true" fontName="SansSerif" fontSize="12" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
	<style name="Sans_Bold" isDefault="false" fontName="SansSerif" fontSize="12" isBold="true" pdfFontName="Helvetica-Bold" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
	<style name="Sans_Italic" isDefault="false" fontName="SansSerif" fontSize="12" isItalic="true" pdfFontName="Helvetica-Oblique" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
	<style name="PageHeader" isDefault="false" style="Sans_Bold" forecolor="#FFFFFF"/>
	<style name="detail" isDefault="false">
		<conditionalStyle>
			<conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue() % 2 == 0)]]></conditionExpression>
			<style isDefault="false" style="detail" mode="Opaque" backcolor="#E0E0E0"/>
		</conditionalStyle>
	</style>
	<parameter name="EmployeeID" class="java.lang.String"/>
	<queryString>
		<![CDATA[SELECT id, user_name, first_name, last_name, title
		FROM users
		WHERE employee_status = 'Active']]>
	</queryString>
	<field name="id" class="java.lang.String"/>
	<field name="user_name" class="java.lang.String"/>
	<field name="first_name" class="java.lang.String"/>
	<field name="last_name" class="java.lang.String"/>
	<field name="title" class="java.lang.String"/>
	<title>
		<band height="75" splitType="Stretch">
			<image scaleImage="Clip" hAlign="Right">
				<reportElement x="365" y="0" width="150" height="26"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:/images/JRLogo"]]></imageExpression>
				<hyperlinkTooltipExpression><![CDATA["JasperReports Logo"]]></hyperlinkTooltipExpression>
			</image>
			<line>
				<reportElement x="0" y="27" width="515" height="1" forecolor="#000000"/>
			</line>
			<textField isBlankWhenNull="true">
				<reportElement style="Sans_Normal" x="0" y="35" width="515" height="30"/>
				<textElement textAlignment="Center" lineSpacing="Single">
					<font size="22"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Employees"]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="20" splitType="Stretch">
			<frame>
				<reportElement mode="Opaque" x="0" y="4" width="515" height="16" backcolor="#333333">
					<property name="net.sf.jasperreports.export.pdf.tag.table" value="start"/>
					<property name="net.sf.jasperreports.export.pdf.tag.tr" value="full"/>
				</reportElement>
				<staticText>
					<reportElement style="PageHeader" x="30" y="0" width="80" height="16">
						<property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/>
						<property name="net.sf.jasperreports.export.pdf.tag.colspan" value="2"/>
					</reportElement>
					<textElement/>
					<text><![CDATA[User]]></text>
				</staticText>
				<staticText>
					<reportElement style="PageHeader" x="120" y="0" width="120" height="16">
						<property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/>
					</reportElement>
					<textElement/>
					<text><![CDATA[Name]]></text>
				</staticText>
				<staticText>
					<reportElement style="PageHeader" x="250" y="0" width="150" height="16">
						<property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/>
					</reportElement>
					<textElement/>
					<text><![CDATA[Title]]></text>
				</staticText>
				<staticText>
					<reportElement style="PageHeader" x="410" y="0" width="105" height="16">
						<property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/>
					</reportElement>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Accounts]]></text>
				</staticText>
			</frame>
		</band>
	</pageHeader>
	<detail>
		<band height="20" splitType="Prevent">
			<frame>
				<reportElement style="detail" x="0" y="0" width="515" height="20">
					<property name="net.sf.jasperreports.export.pdf.tag.tr" value="full"/>
				</reportElement>
				<box>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#808080"/>
				</box>
				<textField isStretchWithOverflow="true">
					<reportElement x="0" y="4" width="20" height="16">
						<property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/>
					</reportElement>
					<textElement textAlignment="Right"/>
					<textFieldExpression class="java.lang.String"><![CDATA[$V{REPORT_COUNT} + "."]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement x="30" y="4" width="80" height="16">
						<property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/>
					</reportElement>
					<textElement/>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{user_name}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement x="120" y="4" width="120" height="16">
						<property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/>
					</reportElement>
					<textElement/>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{first_name} + ' ' + $F{last_name}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement x="250" y="4" width="150" height="16">
						<property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/>
					</reportElement>
					<textElement/>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{title}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" hyperlinkType="ReportExecution">
					<reportElement x="410" y="4" width="105" height="16">
						<property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/>
					</reportElement>
					<textElement textAlignment="Center"/>
					<textFieldExpression class="java.lang.String"><![CDATA["view"]]></textFieldExpression>
					<hyperlinkParameter name="_report">
						<hyperlinkParameterExpression><![CDATA["/reports/samples/EmployeeAccounts"]]></hyperlinkParameterExpression>
					</hyperlinkParameter>
					<hyperlinkParameter name="EmployeeID">
						<hyperlinkParameterExpression><![CDATA[$F{id}]]></hyperlinkParameterExpression>
					</hyperlinkParameter>
				</textField>
			</frame>
		</band>
	</detail>
	<pageFooter>
		<band height="40" splitType="Stretch">
			<line>
				<reportElement x="0" y="10" width="515" height="1">
					<property name="net.sf.jasperreports.export.pdf.tag.table" value="end"/>
				</reportElement>
			</line>
			<textField isStretchWithOverflow="true">
				<reportElement x="200" y="20" width="80" height="16"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.String"><![CDATA["Page " + String.valueOf($V{PAGE_NUMBER}) + " of"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" evaluationTime="Report">
				<reportElement x="280" y="20" width="75" height="16"/>
				<textElement textAlignment="Left"/>
				<textFieldExpression class="java.lang.String"><![CDATA[" " + String.valueOf($V{PAGE_NUMBER})]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
</jasperReport>
