<?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="_harvests" pageWidth="550" pageHeight="802" columnWidth="550" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<property name="ireport.zoom" value="2.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<import value="net.sf.jasperreports.engine.*"/>
	<import value="java.util.*"/>
	<import value="usda.weru.weps.reports.query.*"/>
	<import value="net.sf.jasperreports.engine.data.*"/>
	<parameter name="RUN_ID" class="java.lang.Integer" isForPrompting="false">
		<defaultValueExpression><![CDATA[Integer.valueOf(0)]]></defaultValueExpression>
	</parameter>
	<parameter name="DATE_FORMAT" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["dd/MM/yy"]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT
	"harvestdate",
	"crop",
	AVG("residue") AS "residue",
	AVG("yield") AS "yield",
	"yieldunits",
	AVG("moisture") AS "moisture",
        "units"
FROM
	weps('harvests')
WHERE
	"runid"=$P{RUN_ID}
GROUP BY
	"cropindex",
	"harvestdate",
	"crop",
	"yieldunits"
ORDER BY
	"harvestdate",
	"cropindex"]]>
	</queryString>
	<field name="harvestdate" class="java.sql.Date"/>
	<field name="crop" class="java.lang.String"/>
	<field name="residue" class="java.lang.Double"/>
	<field name="yield" class="java.lang.Double"/>
	<field name="yieldunits" class="java.lang.String"/>
	<field name="moisture" class="java.lang.Double"/>
        <field name="units" class="java.lang.Boolean"/>
	<variable name="US_UNITS" class="java.lang.Boolean" resetType="None">
		<variableExpression><![CDATA["US".equals(((WepsConnection)$P{REPORT_CONNECTION}).getUnits())]]></variableExpression>
	</variable>
	<variable name="MASS_UNITS" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[$V{US_UNITS} ? "lb/ac" : "kg/m²"]]></variableExpression>
	</variable>
	<variable name="DATE_FORMAT" class="java.text.DateFormat">
		<variableExpression><![CDATA[new SimpleDateFormat($P{DATE_FORMAT})]]></variableExpression>
	</variable>
	<pageHeader>
		<band height="25" splitType="Stretch">
			<frame>
				<reportElement style="Section Lines Top" stretchType="RelativeToBandHeight" x="0" y="5" width="550" height="20"/>
			</frame>
			<staticText>
				<reportElement key="staticText-2" style="Section Header" x="0" y="5" width="550" height="20"/>
				<textElement/>
				<text><![CDATA[Harvests]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="30" splitType="Stretch">
			<frame>
				<reportElement style="Section Lines Header" stretchType="RelativeToBandHeight" x="0" y="0" width="550" height="30"/>
			</frame>
			<staticText>
				<reportElement key="element-92" style="Label" x="387" y="0" width="81" height="29"/>
				<textElement textAlignment="Right"/>
				<text><![CDATA[Harvest
Yield]]></text>
			</staticText>
			<staticText>
				<reportElement key="element-93" style="Label" x="468" y="0" width="79" height="29"/>
				<textElement textAlignment="Right"/>
				<text><![CDATA[Yield
% Moisture]]></text>
			</staticText>
			<staticText>
				<reportElement key="element-90" style="Label" x="3" y="14" width="81" height="16"/>
				<textElement/>
				<text><![CDATA[Date]]></text>
			</staticText>
			<staticText>
				<reportElement key="element-90" style="Label" x="84" y="14" width="147" height="16"/>
				<textElement/>
				<text><![CDATA[Crop]]></text>
			</staticText>
			<staticText>
				<reportElement key="element-91" style="Label" x="328" y="0" width="60" height="15"/>
				<textElement textAlignment="Right"/>
				<text><![CDATA[Residue]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="false">
				<reportElement key="textField-4" style="Units" x="328" y="14" width="60" height="16"/>
				<textElement textAlignment="Right">
					<font isBold="false" pdfFontName="Helvetica"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{MASS_UNITS}]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="16" splitType="Stretch">
			<rectangle>
				<reportElement style="Detail Row Shaded" stretchType="RelativeToBandHeight" x="0" y="0" width="550" height="16">
					<printWhenExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue() % 2 == 0)]]></printWhenExpression>
				</reportElement>
			</rectangle>
			<frame>
				<reportElement style="Section Lines Sides" stretchType="RelativeToBandHeight" x="0" y="0" width="550" height="16"/>
			</frame>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="textField" style="Value Decimal Large" x="388" y="0" width="60" height="15">
                                     <printWhenExpression><![CDATA[$F{units}]]></printWhenExpression>
                                </reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{yield}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="textField-3" style="Value Decimal Small" x="388" y="0" width="60" height="15">
                                     <printWhenExpression><![CDATA[!$F{units}]]></printWhenExpression>
                                </reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{yield}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement key="textField" style="Units" x="450" y="0" width="37" height="15"/>
				<textElement textAlignment="Left"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{yieldunits}.replace("^2", "²")]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="false">
				<reportElement key="textField" style="Value" x="85" y="1" width="243" height="15">
					<printWhenExpression><![CDATA[$F{crop} != null]]></printWhenExpression>
				</reportElement>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{crop}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement key="textField-3" style="Value Decimal Huge" x="328" y="0" width="60" height="15">
                                     <printWhenExpression><![CDATA[$F{units}]]></printWhenExpression>
                                </reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{residue}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement key="textField-3" style="Value Decimal Small" x="328" y="0" width="60" height="15">
                                     <printWhenExpression><![CDATA[!$F{units}]]></printWhenExpression>
                                </reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{residue}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="textField-6" style="Value Decimal Large" x="488" y="0" width="59" height="15"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{moisture}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" style="Value Mono" x="3" y="1" width="81" height="15"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{DATE_FORMAT}.format($F{harvestdate})]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="1" splitType="Stretch">
			<frame>
				<reportElement style="Section Lines Bottom" stretchType="RelativeToBandHeight" x="0" y="0" width="550" height="1"/>
			</frame>
		</band>
	</columnFooter>
</jasperReport>