<?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="crop" pageWidth="612" pageHeight="792" columnWidth="550" leftMargin="31" rightMargin="31" topMargin="20" bottomMargin="20">
	<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="88"/>
	<property name="ireport.y" value="0"/>
	<import value="usda.weru.weps.reports.*"/>
	<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="DATE_FORMAT" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["MMM/dd/yy"]]></defaultValueExpression>
	</parameter>
	<parameter name="IMAGE_FILENAME" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["C:/usr/joelevin/projects/reporting-rewrite/weps1.install/images/werureport.gif"]]></defaultValueExpression>
	</parameter>
	<parameter name="REPORTS_DIR" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["C:/usr/joelevin/projects/reporting-rewrite/weps1.install/reports/"]]></defaultValueExpression>
	</parameter>
	<parameter name="REPORT_LOADER" class="usda.weru.weps.reports.ReportLoader" isForPrompting="false">
		<defaultValueExpression><![CDATA[new ReportLoader()]]></defaultValueExpression>
	</parameter>
        <parameter name="RELEASE" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA["WEPS unversioned"]]></defaultValueExpression>
        </parameter>
	<queryString>
		<![CDATA[SELECT
	*
FROM
	weps('runs')]]>
	</queryString>
	<field name="runid" class="java.lang.Integer"/>
	<field name="name" class="java.lang.String"/>
	<field name="nameext" class="java.lang.String"/>
	<field name="location" class="java.lang.String"/>
	<field name="client" class="java.lang.String"/>
	<field name="farm" class="java.lang.String"/>
	<field name="tract" class="java.lang.String"/>
	<field name="field" class="java.lang.String"/>
	<field name="manage" class="java.lang.String"/>
	<field name="soil" class="java.lang.String"/>
	<field name="fieldimage" class="java.lang.Object"/>
	<variable name="RUN_FIRST_PAGE" class="java.lang.Boolean" resetType="Group" resetGroup="run">
		<variableExpression><![CDATA[false]]></variableExpression>
		<initialValueExpression><![CDATA[true]]></initialValueExpression>
	</variable>
	<group name="run" isStartNewPage="true" isReprintHeaderOnEachPage="true">
		<groupExpression><![CDATA[$F{runid}]]></groupExpression>
		<groupHeader>
			<band height="25" splitType="Stretch">
				<subreport isUsingCache="true">
					<reportElement key="_header" style="Default" positionType="Float" x="0" y="0" width="550" height="25" printWhenGroupChanges="run"/>
					<parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression>
					<subreportParameter name="REPORT_SUBTITLE">
						<subreportParameterExpression><![CDATA[$F{name}]]></subreportParameterExpression>
					</subreportParameter>
					<subreportParameter name="REPORT_TITLE">
						<subreportParameterExpression><![CDATA["Crop Detail"]]></subreportParameterExpression>
					</subreportParameter>
					<subreportParameter name="PAD_HEADER">
						<subreportParameterExpression><![CDATA[!$V{RUN_FIRST_PAGE}]]></subreportParameterExpression>
					</subreportParameter>
					<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					<subreportExpression class="net.sf.jasperreports.engine.JasperReport"><![CDATA[$P{REPORT_LOADER}.getReport("_header")]]></subreportExpression>
				</subreport>
			</band>
		</groupHeader>
		<groupFooter>
			<band splitType="Stretch"/>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="50" splitType="Stretch">
			<subreport isUsingCache="true">
				<reportElement key="_runheader" style="Default" positionType="Float" x="0" y="0" width="550" height="25" printWhenGroupChanges="run"/>
				<parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression>
				<subreportParameter name="REPORT_SUBTITLE">
					<subreportParameterExpression><![CDATA[$F{name}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="REPORT_TITLE">
					<subreportParameterExpression><![CDATA["Run Summary"]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="RUN_ID">
					<subreportParameterExpression><![CDATA[$F{runid}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="net.sf.jasperreports.engine.JasperReport"><![CDATA[$P{REPORT_LOADER}.getReport("_runheader")]]></subreportExpression>
			</subreport>
			<subreport isUsingCache="true">
				<reportElement key="_harvestsdetail" style="Default" positionType="Float" x="0" y="25" width="550" height="25"/>
				<parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression>
				<subreportParameter name="RUN_ID">
					<subreportParameterExpression><![CDATA[$F{runid}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="net.sf.jasperreports.engine.JasperReport"><![CDATA[$P{REPORT_LOADER}.getReport("_harvestsdetail")]]></subreportExpression>
			</subreport>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="30" splitType="Stretch">
			<textField>
				<reportElement style="Page Number" x="324" y="12" width="194" height="18"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
			</textField>
			<line>
				<reportElement key="line" style="Report Lines" x="0" y="7" width="550" height="1" forecolor="#000000"/>
			</line>
			<textField evaluationTime="Report" isBlankWhenNull="false">
				<reportElement key="textField" style="Page Count" x="518" y="12" width="32" height="18"/>
				<textElement textAlignment="Left">
					<font size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement style="Printed Date" x="186" y="12" width="288" height="18"/>
				<textElement/>
				<textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-1" style="Printed" x="150" y="12" width="36" height="18"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<text><![CDATA[Printed]]></text>
			</staticText>
                        <textField>
                                <reportElement style="Printed Date" x="0" y="12" width="125" height="18"/>
				<textElement/>
				<textFieldExpression class="java.util.String"><![CDATA[$P{RELEASE}]]></textFieldExpression>
                        </textField>
		</band>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>