<?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="ParamMany" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<property name="net.sf.jasperreports.export.pdf.tagged" value="true"/>
	<property name="net.sf.jasperreports.export.pdf.tag.language" value="EN-US"/>
	<import value="net.sf.jasperreports.engine.*"/>
	<import value="java.util.*"/>
	<import value="net.sf.jasperreports.engine.data.*"/>
	<style name="evenRow" isDefault="false">
		<conditionalStyle>
			<conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue() % 2 == 1)]]></conditionExpression>
			<style isDefault="false" style="evenRow" mode="Opaque" backcolor="#CCFFFF"/>
		</conditionalStyle>
	</style>
	<parameter name="Country" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["Mexico"]]></defaultValueExpression>
	</parameter>
	<parameter name="RequestDate" class="java.util.Date" isForPrompting="false">
		<defaultValueExpression><![CDATA[new java.util.Date(97, 5, 1)]]></defaultValueExpression>
	</parameter>
	<parameter name="OrderId" class="java.lang.Integer" isForPrompting="false">
		<defaultValueExpression><![CDATA[new Integer(10600)]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select * from ORDERS where SHIPCOUNTRY = $P{Country} and REQUIREDDATE > $P{RequestDate} and ORDERID > $P{OrderId}]]>
	</queryString>
	<field name="ORDERID" class="java.lang.Integer">
		<fieldDescription><![CDATA[Order Id]]></fieldDescription>
	</field>
	<field name="CUSTOMERID" class="java.lang.String">
		<fieldDescription><![CDATA[Customer Id]]></fieldDescription>
	</field>
	<field name="EMPLOYEEID" class="java.lang.Integer">
		<fieldDescription><![CDATA[Employee Id]]></fieldDescription>
	</field>
	<field name="ORDERDATE" class="java.util.Date">
		<fieldDescription><![CDATA[Order Date]]></fieldDescription>
	</field>
	<field name="REQUIREDDATE" class="java.util.Date">
		<fieldDescription><![CDATA[Request Date]]></fieldDescription>
	</field>
	<field name="SHIPPEDDATE" class="java.util.Date">
		<fieldDescription><![CDATA[Ship Date]]></fieldDescription>
	</field>
	<field name="SHIPVIA" class="java.lang.Integer">
		<fieldDescription><![CDATA[Ship Via]]></fieldDescription>
	</field>
	<field name="FREIGHT" class="java.math.BigDecimal">
		<fieldDescription><![CDATA[Freight]]></fieldDescription>
	</field>
	<field name="SHIPNAME" class="java.lang.String">
		<fieldDescription><![CDATA[Ship Name]]></fieldDescription>
	</field>
	<field name="SHIPADDRESS" class="java.lang.String">
		<fieldDescription><![CDATA[Ship Address]]></fieldDescription>
	</field>
	<field name="SHIPCITY" class="java.lang.String">
		<fieldDescription><![CDATA[Ship City]]></fieldDescription>
	</field>
	<field name="SHIPREGION" class="java.lang.String">
		<fieldDescription><![CDATA[Ship Region]]></fieldDescription>
	</field>
	<field name="SHIPPOSTALCODE" class="java.lang.String">
		<fieldDescription><![CDATA[Ship Postal Code]]></fieldDescription>
	</field>
	<field name="SHIPCOUNTRY" class="java.lang.String">
		<fieldDescription><![CDATA[Ship Country]]></fieldDescription>
	</field>
	<title>
		<band height="50" splitType="Stretch">
			<staticText>
				<reportElement key="staticText-1" x="17" y="10" width="501" height="35" forecolor="#3333FF"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center">
					<font fontName="Serif" size="24" isBold="true" isItalic="true" pdfFontName="Helvetica-BoldOblique"/>
				</textElement>
				<text><![CDATA[Shipping Report]]></text>
			</staticText>
		</band>
	</title>
	<columnHeader>
		<band height="30" splitType="Stretch">
			<textField isBlankWhenNull="false">
				<reportElement key="textField-1" mode="Opaque" x="0" y="7" width="100" height="18" backcolor="#66CCFF">
					<property name="net.sf.jasperreports.export.pdf.tag.table" value="start"/>
					<property name="net.sf.jasperreports.export.pdf.tag.tr" value="start"/>
					<property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Order Id"]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-2" mode="Opaque" x="100" y="7" width="100" height="18" backcolor="#66CCFF">
					<property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Order Date"]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-3" mode="Opaque" x="200" y="7" width="100" height="18" backcolor="#66CCFF">
					<property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Required Date"]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-4" mode="Opaque" x="300" y="7" width="100" height="18" backcolor="#66CCFF">
					<property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Ship Country"]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-5" mode="Opaque" x="400" y="7" width="100" height="18" backcolor="#66CCFF">
					<property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/>
					<property name="net.sf.jasperreports.export.pdf.tag.tr" value="end"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Postal Code"]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="18" splitType="Stretch">
			<textField isBlankWhenNull="false">
				<reportElement key="textField" style="evenRow" x="0" y="0" width="100" height="18">
					<property name="net.sf.jasperreports.export.pdf.tag.tr" value="start"/>
					<property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$F{ORDERID}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" style="evenRow" x="100" y="0" width="100" height="18">
					<property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{ORDERDATE}]]></textFieldExpression>
			</textField>
			<textField pattern="dd-MMM-yy" isBlankWhenNull="false">
				<reportElement key="textField" style="evenRow" x="200" y="0" width="100" height="18">
					<property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{REQUIREDDATE}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" style="evenRow" x="300" y="0" width="100" height="18">
					<property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SHIPCOUNTRY}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" style="evenRow" x="400" y="0" width="100" height="18">
					<property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/>
					<property name="net.sf.jasperreports.export.pdf.tag.tr" value="end"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SHIPPOSTALCODE}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="30" splitType="Stretch">
			<frame>
				<reportElement mode="Transparent" x="0" y="0" width="0" height="0">
					<property name="net.sf.jasperreports.export.pdf.tag.table" value="end"/>
				</reportElement>
			</frame>
		</band>
	</columnFooter>
</jasperReport>
