<?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="packing_slip_rep" pageWidth="842" pageHeight="555" orientation="Landscape" columnWidth="812" leftMargin="15" rightMargin="15" topMargin="18" bottomMargin="10">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["/home/base/jboss-5.1.0.GA/server/default/deploy/ibase.ear/ibase.war/webitm/reports/jrxml"]]></defaultValueExpression>
	</parameter>
	<parameter name="despId" class="java.lang.String"/>
	<queryString>
		<![CDATA[SELECT
	 distinct
	despatchdet.desp_id as DESP_ID,
     CASE WHEN SITE."ADD1" IS NULL THEN ' 'ELSE SITE."ADD1" END AS SITE_ADD1,
     CASE WHEN CUSTOMER."ADDR1" IS NULL THEN ' 'ELSE CUSTOMER."ADDR1" END AS CUSTOMER_ADDR1,
     CASE WHEN CUSTOMER."DRUG_LIC_NO" IS NULL THEN ' '  ELSE CUSTOMER."DRUG_LIC_NO" END AS CUSTOMER_DRUG_LIC_NO,
	  CUSTOMER."DRUG_LICNO_UPTO"  AS CUSTOMER_DRUG_LICNO_UPTO,
     CASE WHEN CUSTOMER."BANK_ACCT" IS NULL THEN ' 'ELSE CUSTOMER."BANK_ACCT" END AS CUSTOMER_BANK_ACCT,
     CASE WHEN CUSTOMER."STORE_NUMBER" IS NULL THEN ' ' ELSE CUSTOMER."STORE_NUMBER" END AS CUSTOMER_STORE_NUMBER,
     CASE WHEN DESPATCH."LICENCE_NO_1" IS NULL THEN ' 'ELSE DESPATCH."LICENCE_NO_1" END AS DESPATCH_LICENCE_NO_1,
     DESPATCH."LICENCE_DATE_1"  AS DESPATCH_LICENCE_DATE_1,
     CASE WHEN DESPATCH."DLV_ADD1" IS NULL THEN ' 'ELSE DESPATCH."DLV_ADD1" END AS DESPATCH_DLV_ADD1,
     DESPATCH."SORD_DATE"  AS DESPATCH_SORD_DATE,
     CASE WHEN DESPATCH."WAVE_ID" IS NULL THEN ' 'ELSE DESPATCH."WAVE_ID" END AS DESPATCH_WAVE_ID,
     CASE WHEN DESPATCH."GROSS_WEIGHT" IS NULL THEN 0 ELSE DESPATCH."GROSS_WEIGHT" END AS DESPATCH_GROSS_WEIGHT,
     CASE WHEN DESPATCHDET."ITEM_CODE__ORD" IS NULL THEN ' 'ELSE DESPATCHDET."ITEM_CODE__ORD" END AS DESPATCHDET_ITEM_CODE__ORD,
     CASE WHEN SORDER."DLV_ADD1" IS NULL THEN ' 'ELSE SORDER."DLV_ADD1" END AS SORDER_DLV_ADD1,
     CASE WHEN SORDER."CUST_PORD" IS NULL THEN ' 'ELSE SORDER."CUST_PORD" END AS SORDER_CUST_PORD,
     SORDER."ORDER_DATE"  AS SORDER_ORDER_DATE,
     CASE WHEN SORDER."DEPT_CODE" IS NULL THEN ' 'ELSE SORDER."DEPT_CODE" END AS SORDER_DEPT_CODE,
     CASE WHEN SORDER."SALE_ORDER" IS NULL THEN ' 'ELSE SORDER."SALE_ORDER" END AS SORDER_SALE_ORDER,
     STOCK."EXP_DATE"  AS STOCK_EXP_DATE,

     CASE WHEN DESPATCHDET."LINE_NO__SORD" IS NULL THEN ' ' ELSE DESPATCHDET."LINE_NO__SORD" END AS DESPATCHDET_LINE_NO__SORD,
     CASE WHEN SORDER."STATUS" IS NULL THEN ' 'ELSE SORDER."STATUS" END AS SORDER_STATUS,
     CASE WHEN DESPATCH."DLV_ADD2" IS NULL THEN ' 'ELSE DESPATCH."DLV_ADD2" END AS DESPATCH_DLV_ADD2,
     CASE WHEN DESPATCH."DLV_CITY" IS NULL THEN ' 'ELSE DESPATCH."DLV_CITY" END AS DESPATCH_DLV_CITY,
     CASE WHEN DESPATCH."DLV_PIN" IS NULL THEN ' 'ELSE DESPATCH."DLV_PIN" END AS DESPATCH_DLV_PIN,
     CASE WHEN SITE."ADD2" IS NULL THEN ' 'ELSE SITE."ADD2" END AS SITE_ADD2,
     CASE WHEN SITE."CITY" IS NULL THEN ' 'ELSE SITE."CITY" END AS SITE_CITY,
     CASE WHEN SITE."PIN" IS NULL THEN ' 'ELSE SITE."PIN" END AS SITE_PIN,
     CASE WHEN CUSTOMER."ADDR2" IS NULL THEN ' 'ELSE CUSTOMER."ADDR2" END  AS CUSTOMER_ADDR2,
     CASE WHEN CUSTOMER."ADDR3" IS NULL THEN ' 'ELSE CUSTOMER."ADDR3" END AS CUSTOMER_ADDR3,
     CASE WHEN CUSTOMER."CITY" IS NULL THEN ' 'ELSE CUSTOMER."CITY" END AS CUSTOMER_CITY,
     CASE WHEN CUSTOMER."PIN" IS NULL THEN ' ' ELSE CUSTOMER."PIN" END AS CUSTOMER_PIN,
     CASE WHEN SORDER."DLV_ADD2" IS NULL THEN ' 'ELSE SORDER."DLV_ADD2" END AS SORDER_DLV_ADD2,
     CASE WHEN SORDER."DLV_ADD3" IS NULL THEN ' 'ELSE  SORDER."DLV_ADD3" END AS SORDER_DLV_ADD3,
     CASE WHEN SORDER."DLV_CITY" IS NULL THEN ' 'ELSE SORDER."DLV_CITY" END AS SORDER_DLV_CITY,
     CASE WHEN SORDER."DLV_PIN" IS NULL THEN ' 'ELSE SORDER."DLV_PIN" END AS SORDER_DLV_PIN,
     CASE WHEN DESPATCH."DLV_ADD3" IS NULL THEN ' 'ELSE DESPATCH."DLV_ADD3" END AS DESPATCH_DLV_ADD3,
     CASE WHEN SITE."ADD3" IS NULL THEN ' 'ELSE SITE."ADD3" END AS SITE_ADD3,
     CASE WHEN DESPATCH."SITE_CODE" IS NULL THEN ' 'ELSE DESPATCH."SITE_CODE" END AS DESPATCH_SITE_CODE,
	 (

	SELECT
SUM(despatchdet.NO_ART)
    FROM despatch,
         customer,
         despatchdet,
         site ,
         sorder,
         stock
   WHERE
			( despatchdet.desp_id = despatch.desp_id ) and
 			( despatch.site_code = customer.site_code ) and
         ( site.site_code = despatchdet.site_code ) and
         ( site.site_code = customer.site_code ) and
         ( site.site_code = despatch.site_code ) and
         ( sorder.sale_order = despatch.sord_no ) and
         ( stock.site_code = site.site_code ) and
         ( despatchdet.lot_no = stock.lot_no ) and
         ( despatchdet.lot_sl = stock.lot_sl ) and
	trim(despatch.desp_id) = trim($P{despId})

	 )
    FROM despatch,
         customer,
         despatchdet,
         site ,
         sorder,
         stock
   WHERE
	( despatchdet.desp_id = despatch.desp_id ) and
 	( despatch.site_code = customer.site_code ) and
         ( site.site_code = despatchdet.site_code ) and
         ( site.site_code = customer.site_code ) and
         ( site.site_code = despatch.site_code ) and
         ( sorder.sale_order = despatch.sord_no ) and
         ( stock.site_code = site.site_code ) and
         ( despatchdet.lot_no = stock.lot_no ) and
         ( despatchdet.lot_sl = stock.lot_sl ) and
       trim(despatch.desp_id) = trim($P{despId})]]>
	</queryString>
	<field name="DESP_ID" class="java.lang.String"/>
	<field name="SITE_ADD1" class="java.lang.String"/>
	<field name="CUSTOMER_ADDR1" class="java.lang.String"/>
	<field name="CUSTOMER_DRUG_LIC_NO" class="java.lang.String"/>
	<field name="CUSTOMER_DRUG_LICNO_UPTO" class="java.lang.String"/>
	<field name="CUSTOMER_BANK_ACCT" class="java.lang.String"/>
	<field name="CUSTOMER_STORE_NUMBER" class="java.lang.String"/>
	<field name="DESPATCH_LICENCE_NO_1" class="java.lang.String"/>
	<field name="DESPATCH_LICENCE_DATE_1" class="java.lang.String"/>
	<field name="DESPATCH_DLV_ADD1" class="java.lang.String"/>
	<field name="DESPATCH_SORD_DATE" class="java.lang.String"/>
	<field name="DESPATCH_WAVE_ID" class="java.lang.String"/>
	<field name="DESPATCH_GROSS_WEIGHT" class="java.lang.String"/>
	<field name="DESPATCHDET_ITEM_CODE__ORD" class="java.lang.String"/>
	<field name="SORDER_DLV_ADD1" class="java.lang.String"/>
	<field name="SORDER_CUST_PORD" class="java.lang.String"/>
	<field name="SORDER_ORDER_DATE" class="java.lang.String"/>
	<field name="SORDER_DEPT_CODE" class="java.lang.String"/>
	<field name="SORDER_SALE_ORDER" class="java.lang.String"/>
	<field name="STOCK_EXP_DATE" class="java.lang.String"/>
	<field name="DESPATCHDET_LINE_NO__SORD" class="java.lang.String"/>
	<field name="SORDER_STATUS" class="java.lang.String"/>
	<field name="DESPATCH_DLV_ADD2" class="java.lang.String"/>
	<field name="DESPATCH_DLV_CITY" class="java.lang.String"/>
	<field name="DESPATCH_DLV_PIN" class="java.lang.String"/>
	<field name="SITE_ADD2" class="java.lang.String"/>
	<field name="SITE_CITY" class="java.lang.String"/>
	<field name="SITE_PIN" class="java.lang.String"/>
	<field name="CUSTOMER_ADDR2" class="java.lang.String"/>
	<field name="CUSTOMER_ADDR3" class="java.lang.String"/>
	<field name="CUSTOMER_CITY" class="java.lang.String"/>
	<field name="CUSTOMER_PIN" class="java.lang.String"/>
	<field name="SORDER_DLV_ADD2" class="java.lang.String"/>
	<field name="SORDER_DLV_ADD3" class="java.lang.String"/>
	<field name="SORDER_DLV_CITY" class="java.lang.String"/>
	<field name="SORDER_DLV_PIN" class="java.lang.String"/>
	<field name="DESPATCH_DLV_ADD3" class="java.lang.String"/>
	<field name="SITE_ADD3" class="java.lang.String"/>
	<field name="DESPATCH_SITE_CODE" class="java.lang.String"/>
	<field name="(SELECTSUM(DESPATCHDET.NO_ART)FROMDESPATCH,CUSTOMER,DESPATCHDET,SITE,SORDER,STOCKWHERE(DESPATCHDET.DESP_ID=DESPATCH.DESP_ID)AND(DESPATCH.SITE_CODE=CUSTOMER.SITE_CODE)AND(SITE.SITE_CODE=DESPATCHDET.SITE_CODE)AND(SITE.SITE_CODE=CUSTOMER.SITE_CODE)AND(SITE.S" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="218" splitType="Stretch">
			<textField>
				<reportElement x="524" y="54" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CUSTOMER_ADDR3}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="524" y="35" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CUSTOMER_ADDR1}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="23" y="177" width="46" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Customer :]]></text>
			</staticText>
			<staticText>
				<reportElement x="23" y="99" width="46" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Ship TO:]]></text>
			</staticText>
			<textField>
				<reportElement x="524" y="108" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCH_DLV_ADD2}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yy">
				<reportElement x="378" y="168" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SORDER_ORDER_DATE}.equals(null)?"":$F{SORDER_ORDER_DATE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="725" y="13" width="32" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Page :]]></text>
			</staticText>
			<staticText>
				<reportElement x="712" y="23" width="10" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[At ]]></text>
			</staticText>
			<textField>
				<reportElement x="69" y="187" width="72" height="9"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CUSTOMER_STORE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="682" y="186" width="72" height="9"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCH_GROSS_WEIGHT}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="98" y="148" width="100" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CUSTOMER_DRUG_LIC_NO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="329" y="168" width="49" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Order Date:]]></text>
			</staticText>
			<textField>
				<reportElement x="524" y="72" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CUSTOMER_PIN}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="71" y="35" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SITE_ADD1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="69" y="168" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SORDER_CUST_PORD}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="469" y="35" width="55" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Sold From :]]></text>
			</staticText>
			<textField pattern="dd/MM/yy">
				<reportElement x="378" y="196" width="72" height="9"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCHDET_ITEM_CODE__ORD}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="23" y="195" width="46" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Dept . . :]]></text>
			</staticText>
			<staticText>
				<reportElement x="329" y="195" width="49" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Order Nbr :]]></text>
			</staticText>
			<textField>
				<reportElement x="71" y="108" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SORDER_DLV_ADD2}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="69" y="205" width="72" height="9"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCHDET_ITEM_CODE__ORD}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="23" y="19" width="46" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Wh/Co/Div::]]></text>
			</staticText>
			<staticText>
				<reportElement x="23" y="10" width="61" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Packing_Slip
]]></text>
			</staticText>
			<textField pattern="dd/MM/yy">
				<reportElement x="378" y="187" width="72" height="9"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCH_SORD_DATE}.equals(null)?"":$F{DESPATCH_SORD_DATE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="329" y="186" width="49" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Ship Date :]]></text>
			</staticText>
			<staticText>
				<reportElement x="23" y="168" width="46" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[PO# .. . :]]></text>
			</staticText>
			<staticText>
				<reportElement x="635" y="176" width="47" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[# of Ctns :]]></text>
			</staticText>
			<staticText>
				<reportElement x="635" y="185" width="47" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Weight .  :]]></text>
			</staticText>
			<textField pattern="dd/MM/yy">
				<reportElement x="279" y="151" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CUSTOMER_DRUG_LICNO_UPTO}.equals(null)?"":$F{CUSTOMER_DRUG_LICNO_UPTO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="69" y="178" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CUSTOMER_BANK_ACCT}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="682" y="177" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{(SELECTSUM(DESPATCHDET.NO_ART)FROMDESPATCH,CUSTOMER,DESPATCHDET,SITE,SORDER,STOCKWHERE(DESPATCHDET.DESP_ID=DESPATCH.DESP_ID)AND(DESPATCH.SITE_CODE=CUSTOMER.SITE_CODE)AND(SITE.SITE_CODE=DESPATCHDET.SITE_CODE)AND(SITE.SITE_CODE=CUSTOMER.SITE_CODE)AND(SITE.S}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="682" y="167" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SORDER_SALE_ORDER}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="71" y="70" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SITE_PIN}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="98" y="82" width="100" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCH_LICENCE_NO_1}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="469" y="99" width="55" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Sold To:]]></text>
			</staticText>
			<staticText>
				<reportElement x="23" y="148" width="75" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Ship To DEA# :]]></text>
			</staticText>
			<textField pattern="dd/MM/yy">
				<reportElement x="279" y="82" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCH_LICENCE_DATE_1}.equals( null )?"":$F{DESPATCH_LICENCE_DATE_1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="71" y="43" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SITE_ADD2}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="635" y="194" width="47" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Wave # .  :]]></text>
			</staticText>
			<textField>
				<reportElement x="71" y="98" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SORDER_DLV_ADD1}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="23" y="35" width="46" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Ship From:]]></text>
			</staticText>
			<staticText>
				<reportElement x="329" y="177" width="49" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Start Date:]]></text>
			</staticText>
			<textField>
				<reportElement x="71" y="126" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SORDER_DLV_CITY}]]></textFieldExpression>
			</textField>
			<textField pattern="HH.mm.ss">
				<reportElement x="722" y="23" width="51" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.lang.String()]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="71" y="61" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SITE_CITY}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="756" y="13" width="17" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[String.valueOf($V{PAGE_NUMBER})]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="255" y="151" width="24" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Exp :]]></text>
			</staticText>
			<textField pattern="dd/MM/yy">
				<reportElement x="672" y="23" width="40" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.lang.String()]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="71" y="52" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SITE_ADD3}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="635" y="167" width="47" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Pkt Ctl # :]]></text>
			</staticText>
			<staticText>
				<reportElement x="255" y="82" width="24" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Exp :]]></text>
			</staticText>
			<textField pattern="dd/MM/yy">
				<reportElement x="378" y="178" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{STOCK_EXP_DATE}.equals(null)?"":$F{STOCK_EXP_DATE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="23" y="186" width="46" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Store #  :]]></text>
			</staticText>
			<textField>
				<reportElement x="524" y="126" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCH_DLV_CITY}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="682" y="195" width="72" height="9"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCH_WAVE_ID}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="524" y="117" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCH_DLV_ADD3}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="198" y="204" width="31" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[B/O :]]></text>
			</staticText>
			<staticText>
				<reportElement x="361" y="9" width="110" height="14"/>
				<textElement textAlignment="Justified">
					<font fontName="Courier New" size="10"/>
				</textElement>
				<text><![CDATA[PACKING SLIP]]></text>
			</staticText>
			<textField>
				<reportElement x="69" y="196" width="72" height="9"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SORDER_DEPT_CODE}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="71" y="117" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SORDER_DLV_ADD3}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="23" y="82" width="75" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Shipper DEA# :]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement x="71" y="19" width="39" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCH_SITE_CODE}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="71" y="135" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SORDER_DLV_PIN}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="524" y="135" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCH_DLV_PIN}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="228" y="204" width="51" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SORDER_STATUS}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="524" y="63" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CUSTOMER_CITY}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="23" y="204" width="46" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Pkt Nbr .:]]></text>
			</staticText>
			<textField>
				<reportElement x="524" y="45" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CUSTOMER_ADDR2}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="524" y="99" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCH_DLV_ADD1}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="13" splitType="Stretch">
			<subreport>
				<reportElement stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" x="12" y="0" width="777" height="13" isRemoveLineWhenBlank="true"/>
				<subreportParameter name="despId">
					<subreportParameterExpression><![CDATA[$F{DESP_ID}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<!-- <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "packing_slip_rep_subreport1.jasper"]]></subreportExpression>
				-->
				<subreportExpression class="java.io.InputStream"><![CDATA[new FileInputStream($P{SUBREPORT_DIR}+"/packing_slip_rep_subreport1.jasper")]]></subreportExpression>
			</subreport>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="34" splitType="Stretch">
			<line>
				<reportElement x="23" y="18" width="763" height="1"/>
			</line>
			<staticText>
				<reportElement x="24" y="5" width="571" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[For CPSIA compliance documents,search www.TaroUSA.com for "GCC"  or contact Taro USA customer service of 1-800-544-1449.]]></text>
			</staticText>
			<line>
				<reportElement x="23" y="2" width="763" height="1"/>
			</line>
			<staticText>
				<reportElement x="528" y="22" width="261" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[THANK YOU, WE APPRECIATE YOUR BUSINESS.]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
