<?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="pick_task_break" pageWidth="283" pageHeight="425" columnWidth="283" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="REPLORDER" class="java.lang.String"/>
	<queryString language="SQL">
		<![CDATA[select
MIN(T.LOC_CODE) AS LOC_CODE,
SUM(T.NO_ART) AS NO_ART
from  (
select rd.LOC_CODE AS LOC_CODE,
RD.NO_ART AS NO_ART
FROM REPL_ORD_DET rd
WHERE rd.repl_order = '$P!{REPLORDER}'
union all
select pd.LOC_CODE AS LOC_CODE,
pd.NO_ART AS NO_ART
from pick_ord_det pd
WHERE PD.pick_order = '$P!{REPLORDER}'
) t
GROUP BY T.LOC_CODE
ORDER BY T.LOC_CODE]]>
	</queryString>
	<field name="LOC_CODE" class="java.lang.String"/>
	<field name="NO_ART" class="java.lang.Integer"/>
	<variable name="variable1" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[new java.lang.String($F{NO_ART}.intValue()+"   CASE")]]></variableExpression>
	</variable>
	<group name="LOC_CODE">
		<groupExpression><![CDATA[$F{LOC_CODE}]]></groupExpression>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="302" splitType="Stretch">
			<staticText>
				<reportElement x="4" y="19" width="277" height="62"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="18"/>
				</textElement>
				<text><![CDATA[* * * * * * * BREAK * * * * * * * ]]></text>
			</staticText>
			<staticText>
				<reportElement x="33" y="97" width="108" height="41"/>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="12"/>
				</textElement>
				<text><![CDATA[LOCATION:]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="141" y="97" width="108" height="41"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{LOC_CODE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="10" y="138" width="129" height="24"/>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="12"/>
				</textElement>
				<text><![CDATA[Total # of Cartons:]]></text>
			</staticText>
			<line>
				<reportElement x="7" y="89" width="257" height="1"/>
				<graphicElement>
					<pen lineWidth="4.0"/>
				</graphicElement>
			</line>
			<line>
				<reportElement x="7" y="174" width="257" height="1"/>
				<graphicElement>
					<pen lineWidth="4.0"/>
				</graphicElement>
			</line>
			<textField isBlankWhenNull="true">
				<reportElement x="149" y="138" width="127" height="24"/>
				<textElement verticalAlignment="Top">
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{variable1}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band splitType="Stretch"/>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
