<?xml version="1.0" encoding="UTF-8"  ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
		 name="QuadrantForRegion"
		 columnCount="1"
		 printOrder="Vertical"
		 orientation="Portrait"
		 pageWidth="612"
		 pageHeight="792"
		 columnWidth="540"
		 columnSpacing="0"
		 leftMargin="36"
		 rightMargin="36"
		 topMargin="36"
		 bottomMargin="36"
		 whenNoDataType="NoPages"
		 isTitleNewPage="false"
		 isSummaryNewPage="false">
	<property name="ireport.scriptlethandling" value="2" />
	<import value="java.util.*" />
	<import value="net.sf.jasperreports.engine.*" />
	<import value="net.sf.jasperreports.engine.data.*" />
	<parameter name="REGION" class="java.lang.String" isForPrompting="true">
	    <parameterDescription>Region to show budget vs actual data for</parameterDescription>
	</parameter>
	<queryString><![CDATA[select QUADRANT_ACTUALS.REGION,
  QUADRANT_ACTUALS.DEPARTMENT,
  QUADRANT_ACTUALS.POSITIONTITLE,
  QUADRANT_ACTUALS.ACTUAL,
  QUADRANT_ACTUALS.BUDGET,
  QUADRANT_ACTUALS.VARIANCE
 from QUADRANT_ACTUALS
 where QUADRANT_ACTUALS.REGION = $P{REGION}
ORDER BY REGION, DEPARTMENT, POSITIONTITLE]]></queryString>
	<field name="REGION" class="java.lang.String"/>
	<field name="DEPARTMENT" class="java.lang.String"/>
	<field name="POSITIONTITLE" class="java.lang.String"/>
	<field name="ACTUAL" class="java.lang.Double"/>
	<field name="BUDGET" class="java.lang.Double"/>
	<field name="VARIANCE" class="java.lang.Double"/>
	<variable name="department_actual" class="java.lang.Double" resetType="Group" resetGroup="Department" calculation="Sum">
		<variableExpression><![CDATA[$F{ACTUAL}]]></variableExpression>
	</variable>
	<variable name="department_budget" class="java.lang.Double" resetType="Group" resetGroup="Department" calculation="Sum">
		<variableExpression><![CDATA[$F{BUDGET}]]></variableExpression>
	</variable>
	<variable name="department_variance" class="java.lang.Double" resetType="Group" resetGroup="Department" calculation="Sum">
		<variableExpression><![CDATA[$F{VARIANCE}]]></variableExpression>
	</variable>
	<variable name="region_actual" class="java.lang.Double" resetType="Group" resetGroup="Region" calculation="Sum">
		<variableExpression><![CDATA[$F{ACTUAL}]]></variableExpression>
	</variable>
	<variable name="region_budget" class="java.lang.Double" resetType="Group" resetGroup="Region" calculation="Sum">
		<variableExpression><![CDATA[$F{BUDGET}]]></variableExpression>
	</variable>
	<variable name="region_variance" class="java.lang.Double" resetType="Group" resetGroup="Region" calculation="Sum">
		<variableExpression><![CDATA[$F{VARIANCE}]]></variableExpression>
	</variable>
	<variable name="total_actual" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[$F{ACTUAL}]]></variableExpression>
	</variable>
	<variable name="total_budget" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[$F{BUDGET}]]></variableExpression>
	</variable>
	<variable name="total_variance" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[$F{VARIANCE}]]></variableExpression>
	</variable>
	<variable name="short_dep_name" class="java.lang.String" resetType="Report">
	    <!-- Map the department name to a shorter form for use with the chart.  -->
	    <!-- Ideally this would be read from the db, or done in the query with  -->
	    <!-- a CASE statement in the select.  This logic does not belong in a   -->
	    <!-- report.                                                            -->
		<variableExpression><![CDATA[
		    $F{DEPARTMENT}.equals("Executive Management") ? "Executive" :
		        $F{DEPARTMENT}.equals("Human Resource") ? "HR" : 
		        $F{DEPARTMENT}.startsWith("Marketing") ? "Marketing" :
		        $F{DEPARTMENT}.equals("Product Development") ? "Dev" : 
		        $F{DEPARTMENT}.equals("Professional Services") ? "Services" : 
		        $F{DEPARTMENT}]]></variableExpression>
	</variable>
		<group  name="Region" isStartNewColumn="false" isStartNewPage="true" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >
			<groupExpression><![CDATA[$F{REGION}]]></groupExpression>
			<groupHeader>
			<band height="24"  isSplitAllowed="true" >
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="0"
						y="0"
						width="310"
						height="23"
						forecolor="#009999"
						backcolor="#FFFFFF"
						key="textField-3"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="18" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA["Region: " + $F{REGION}]]></textFieldExpression>
				</textField>
			</band>
			</groupHeader>
			<groupFooter>
			<band height="30"  isSplitAllowed="true" >
				<textField isStretchWithOverflow="false" pattern="$#,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="246"
						y="0"
						width="98"
						height="15"
						forecolor="#FFFFFF"
						backcolor="#006666"
						key="textField-2"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.Double"><![CDATA[$V{region_actual}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="$#,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="344"
						y="0"
						width="98"
						height="15"
						forecolor="#FFFFFF"
						backcolor="#006666"
						key="textField-2"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.Double"><![CDATA[$V{region_budget}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="$#,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="442"
						y="0"
						width="98"
						height="15"
						forecolor="#FFFFFF"
						backcolor="#006666"
						key="textField-2"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false">
							<printWhenExpression><![CDATA[new Boolean($V{region_variance}.intValue() >= 0)]]></printWhenExpression>
						</reportElement>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.Double"><![CDATA[$V{region_variance}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="$#,##0" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="442"
						y="0"
						width="98"
						height="15"
						forecolor="#FFFFFF"
						backcolor="#006666"
						key="textField-4"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false">
							<printWhenExpression><![CDATA[new Boolean($V{region_variance}.intValue() < 0)]]></printWhenExpression>
						</reportElement>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.Double"><![CDATA[$V{region_variance}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="0"
						y="0"
						width="246"
						height="15"
						forecolor="#FFFFFF"
						backcolor="#006666"
						key="textField-6"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{REGION} + " Total"]]></textFieldExpression>
				</textField>
			</band>
			</groupFooter>
		</group>
		<group  name="Department" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="100" >
			<groupExpression><![CDATA[$F{DEPARTMENT}]]></groupExpression>
			<groupHeader>
			<band height="40"  isSplitAllowed="true" >
			    <rectangle>
			        <reportElement
			            mode="Opaque"
			            x="0"
			            y="0"
			            width="540"
			            height="40"
			            forecolor="#FF6600"
			            backcolor="#FF6600"
			            positionType="FixRelativeToTop"
			            isRemoveLineWhenBlank="false"
			            isPrintInFirstWholeBand="false"
			            key="rectange-1"/>
			        <graphicElement pen="1Point"/>
			    </rectangle>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="0"
						y="4"
						width="540"
						height="18"
						forecolor="#FFFFFF"
						backcolor="#FF6600"
						key="textField-3"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				    <textFieldExpression   class="java.lang.String"><![CDATA["Department: " + $F{DEPARTMENT}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement
						mode="Opaque"
						x="19"
						y="25"
						width="227"
						height="14"
						forecolor="#FFFFFF"
						backcolor="#FF6600"
						key="staticText-3"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="11" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				    <text><![CDATA[Position]]></text>
				</staticText>
				<staticText>
					<reportElement
						mode="Opaque"
						x="246"
						y="25"
						width="98"
						height="14"
						forecolor="#FFFFFF"
						backcolor="#FF6600"
						key="staticText-3"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="11" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				    <text><![CDATA[Actual]]></text>
				</staticText>
				<staticText>
					<reportElement
						mode="Opaque"
						x="344"
						y="25"
						width="98"
						height="14"
						forecolor="#FFFFFF"
						backcolor="#FF6600"
						key="staticText-3"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="11" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				    <text><![CDATA[Budget]]></text>
				</staticText>
				<staticText>
					<reportElement
						mode="Opaque"
						x="442"
						y="25"
						width="98"
						height="14"
						forecolor="#FFFFFF"
						backcolor="#FF6600"
						key="staticText-3"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="11" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				    <text><![CDATA[Variance]]></text>
				</staticText>
			</band>
			</groupHeader>
			<groupFooter>
			<band height="20"  isSplitAllowed="true" >
				<textField isStretchWithOverflow="false" pattern="$#,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="246"
						y="0"
						width="98"
						height="14"
						forecolor="#000000"
						backcolor="#66FF66"
						key="textField-2"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="11" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.Double"><![CDATA[$V{department_actual}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="$#,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="344"
						y="0"
						width="98"
						height="14"
						forecolor="#000000"
						backcolor="#66FF66"
						key="textField-2"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="11" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.Double"><![CDATA[$V{department_budget}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="$#,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="442"
						y="0"
						width="98"
						height="14"
						forecolor="#000000"
						backcolor="#66FF66"
						key="textField-2"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false">
							<printWhenExpression><![CDATA[new Boolean($V{department_variance}.intValue() >= 0)]]></printWhenExpression>
						</reportElement>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="11" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.Double"><![CDATA[$V{department_variance}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="$#,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="442"
						y="0"
						width="98"
						height="14"
						forecolor="#FF0000"
						backcolor="#66FF66"
						key="textField-4"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false">
							<printWhenExpression><![CDATA[new Boolean($V{department_variance}.intValue() < 0)]]></printWhenExpression>
						</reportElement>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="11" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.Double"><![CDATA[$V{department_variance}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement
						mode="Opaque"
						x="19"
						y="0"
						width="227"
						height="14"
						forecolor="#000000"
						backcolor="#66FF66"
						key="staticText-3"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="11" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<text><![CDATA[Total]]></text>
				</staticText>
			</band>
			</groupFooter>
		</group>
		<background>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</background>
		<title>
			<band height="250"  isSplitAllowed="true" >
				<staticText>
					<reportElement
						mode="Opaque"
						x="0"
						y="0"
						width="540"
						height="50"
						forecolor="#FFFFFF"
						backcolor="#0000CC"
						key="staticText-1"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="18" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<text><![CDATA[Exciting Quadrant Data]]></text>
				</staticText>
				<barChart>
                    <chart isShowLegend="true" evaluationTime="Report">
                        <reportElement positionType="Float" x="0" y="50" width="540" height="200"/>
                        <chartTitle position="Top">
                            <font size="14" isBold="true"/>
                           <titleExpression>"Actual vs Budget"</titleExpression>
                        </chartTitle>
                    </chart>
                    <categoryDataset>
                        <dataset incrementType="None"  resetType="Report" />
                        <categorySeries>
                            <seriesExpression>"Budget"</seriesExpression>
                            <categoryExpression>$V{short_dep_name}</categoryExpression>
                            <valueExpression>$V{department_budget}</valueExpression>
                        </categorySeries>
                        <categorySeries>
                            <seriesExpression>"Actual"</seriesExpression>
                            <categoryExpression>$V{short_dep_name}</categoryExpression>
                            <valueExpression>$V{department_actual}</valueExpression>
                        </categorySeries>
                    </categoryDataset>
                    <barPlot isShowTickMarks="true" isShowTickLabels="true" isShowLabels="false">
                        <plot orientation="Horizontal"/>
                    </barPlot>
 				</barChart>
				<!--
                <pieChart>
                    <chart isShowLegend="false" evaluationTime="Report">
                        <reportElement positionType="Float" x="0" y="50" width="265" height="150"/>
                        <chartTitle position="Top">
                           <titleExpression>"Actual"</titleExpression>
                        </chartTitle>
                    </chart>
                    <pieDataset>
                        <dataset incrementType="None"  resetType="Report" />
                        <keyExpression>$F{DEPARTMENT}</keyExpression>
                        <valueExpression>$V{department_actual}</valueExpression>
                        <labelExpression>$F{DEPARTMENT}</labelExpression>
                    </pieDataset>
                    <piePlot>
                        <plot orientation="Horizontal"/>
                    </piePlot>
                </pieChart>
                <pieChart>
                    <chart isShowLegend="false" evaluationTime="Report">
                        <reportElement positionType="Float" x="275" y="50" width="265" height="150"/>
                        <chartTitle position="Top">
                           <titleExpression>"Budget"</titleExpression>
                        </chartTitle>
                    </chart>
                    <pieDataset>
                        <dataset incrementType="None"  resetType="Report" />
                        <keyExpression>$F{DEPARTMENT}</keyExpression>
                        <valueExpression>$V{department_budget}</valueExpression>
                        <labelExpression>$F{DEPARTMENT}</labelExpression>
                    </pieDataset>
                    <piePlot>
                        <plot orientation="Horizontal"/>
                    </piePlot>
                </pieChart>
                -->
			</band>
		</title>
		<columnHeader>
			<band height="8"  isSplitAllowed="true" >
			</band>
		</columnHeader>
		<detail>
			<band height="13"  isSplitAllowed="false" >
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="19"
						y="0"
						width="227"
						height="12"
						forecolor="#000000"
						backcolor="#FFFFFF"
						key="textField-1"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{POSITIONTITLE}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="$#,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="246"
						y="0"
						width="98"
						height="12"
						forecolor="#000000"
						backcolor="#FFFFFF"
						key="textField-2"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.Double"><![CDATA[$F{ACTUAL}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="$#,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="344"
						y="0"
						width="98"
						height="12"
						forecolor="#000000"
						backcolor="#FFFFFF"
						key="textField-2"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.Double"><![CDATA[$F{BUDGET}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="$#,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="442"
						y="0"
						width="98"
						height="12"
						forecolor="#000000"
						backcolor="#FFFFFF"
						key="textField-2"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false">
							<printWhenExpression><![CDATA[new Boolean($F{VARIANCE}.intValue() >= 0)]]></printWhenExpression>
						</reportElement>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.Double"><![CDATA[$F{VARIANCE}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="$#,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Opaque"
						x="442"
						y="0"
						width="98"
						height="12"
						forecolor="#FF0000"
						backcolor="#FFFFFF"
						key="textField-4"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false">
							<printWhenExpression><![CDATA[new Boolean($F{VARIANCE}.intValue() < 0)]]></printWhenExpression>
						</reportElement>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<textFieldExpression   class="java.lang.Double"><![CDATA[$F{VARIANCE}]]></textFieldExpression>
				</textField>
			</band>
		</detail>
		<columnFooter>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</columnFooter>
		<pageFooter>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</pageFooter>
		<summary>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</summary>
</jasperReport>