<?xml version="1.0" encoding="UTF-8"?>
<jasperReport name="employee_roster"
              pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="762"
              leftMargin="40" rightMargin="40" topMargin="30" bottomMargin="30">

    <parameter name="EmployeeID" class="java.lang.Integer"/>
    <parameter name="FirstName" class="java.lang.String"/>
    <parameter name="LastName" class="java.lang.String"/>
    <parameter name="Title" class="java.lang.String"/>
    <parameter name="City" class="java.lang.String"/>
    <parameter name="Country" class="java.lang.String"/>

    <title height="50">
        <element kind="staticText" x="0" y="0" width="762" height="30" fontSize="14.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
            <text><![CDATA[Employee Roster]]></text>
        </element>
        <element kind="staticText" x="0" y="30" width="762" height="16" fontSize="9.0" italic="true" hTextAlign="Center" vTextAlign="Middle" forecolor="#666666">
            <text><![CDATA[Generated by DataPallas — JasperReports Excel Export]]></text>
        </element>
    </title>

    <columnHeader height="25">
        <element kind="staticText" x="0" y="0" width="80" height="25" mode="Opaque" backcolor="#4472C4" forecolor="#FFFFFF" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
            <box><pen lineWidth="0.5" lineColor="#FFFFFF"/></box>
            <text><![CDATA[Employee ID]]></text>
        </element>
        <element kind="staticText" x="80" y="0" width="140" height="25" mode="Opaque" backcolor="#4472C4" forecolor="#FFFFFF" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
            <box><pen lineWidth="0.5" lineColor="#FFFFFF"/></box>
            <text><![CDATA[First Name]]></text>
        </element>
        <element kind="staticText" x="220" y="0" width="140" height="25" mode="Opaque" backcolor="#4472C4" forecolor="#FFFFFF" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
            <box><pen lineWidth="0.5" lineColor="#FFFFFF"/></box>
            <text><![CDATA[Last Name]]></text>
        </element>
        <element kind="staticText" x="360" y="0" width="182" height="25" mode="Opaque" backcolor="#4472C4" forecolor="#FFFFFF" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
            <box><pen lineWidth="0.5" lineColor="#FFFFFF"/></box>
            <text><![CDATA[Title]]></text>
        </element>
        <element kind="staticText" x="542" y="0" width="110" height="25" mode="Opaque" backcolor="#4472C4" forecolor="#FFFFFF" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
            <box><pen lineWidth="0.5" lineColor="#FFFFFF"/></box>
            <text><![CDATA[City]]></text>
        </element>
        <element kind="staticText" x="652" y="0" width="110" height="25" mode="Opaque" backcolor="#4472C4" forecolor="#FFFFFF" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
            <box><pen lineWidth="0.5" lineColor="#FFFFFF"/></box>
            <text><![CDATA[Country]]></text>
        </element>
    </columnHeader>

    <detail>
        <band height="20">
            <element kind="textField" x="0" y="0" width="80" height="20" fontSize="9.0" hTextAlign="Center" vTextAlign="Middle">
                <box><pen lineWidth="0.25" lineColor="#D0D0D0"/></box>
                <expression><![CDATA[$P{EmployeeID}]]></expression>
            </element>
            <element kind="textField" x="80" y="0" width="140" height="20" fontSize="9.0" vTextAlign="Middle" blankWhenNull="true">
                <box leftPadding="4"><pen lineWidth="0.25" lineColor="#D0D0D0"/></box>
                <expression><![CDATA[$P{FirstName}]]></expression>
            </element>
            <element kind="textField" x="220" y="0" width="140" height="20" fontSize="9.0" vTextAlign="Middle" blankWhenNull="true">
                <box leftPadding="4"><pen lineWidth="0.25" lineColor="#D0D0D0"/></box>
                <expression><![CDATA[$P{LastName}]]></expression>
            </element>
            <element kind="textField" x="360" y="0" width="182" height="20" fontSize="9.0" vTextAlign="Middle" blankWhenNull="true">
                <box leftPadding="4"><pen lineWidth="0.25" lineColor="#D0D0D0"/></box>
                <expression><![CDATA[$P{Title}]]></expression>
            </element>
            <element kind="textField" x="542" y="0" width="110" height="20" fontSize="9.0" vTextAlign="Middle" blankWhenNull="true">
                <box leftPadding="4"><pen lineWidth="0.25" lineColor="#D0D0D0"/></box>
                <expression><![CDATA[$P{City}]]></expression>
            </element>
            <element kind="textField" x="652" y="0" width="110" height="20" fontSize="9.0" vTextAlign="Middle" blankWhenNull="true">
                <box leftPadding="4"><pen lineWidth="0.25" lineColor="#D0D0D0"/></box>
                <expression><![CDATA[$P{Country}]]></expression>
            </element>
        </band>
    </detail>

</jasperReport>
