<?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="792" pageHeight="612" orientation="Landscape" columnWidth="772" leftMargin="15" rightMargin="5" topMargin="10" bottomMargin="10">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="228"/>
	<property name="ireport.y" value="0"/>
	<parameter name="despId" class="java.lang.String"/>
	<queryString>
		<![CDATA[SELECT
	 distinct
	despatch.desp_id as DESP_ID,
        CASE WHEN S1.DESCR IS NULL THEN ' 'ELSE S1.DESCR END AS SITE_DESCR_SHIP,
	CASE WHEN S1.ADD1 IS NULL THEN ' 'ELSE S1.ADD1 END AS SITE_SHIP_ADD1,
	CASE WHEN S1.ADD2 IS NULL THEN ' 'ELSE S1.ADD2 END AS SITE_SHIP_ADD2,
	CASE WHEN S1.ADD3 IS NULL THEN ' 'ELSE S1.ADD3 END AS SITE_SHIP_ADD3,
	CASE WHEN S1.CITY IS NULL THEN ' 'ELSE S1.CITY END AS SITE_SHIP_CITY,
	CASE WHEN S1.PIN IS NULL THEN ' 'ELSE S1.PIN END AS SITE_SHIP_PIN,
     CASE WHEN S1.STATE_CODE IS NULL THEN ' 'ELSE S1.STATE_CODE END AS SITE_SHIP_STATE_CODE,
     DDF_INV_DRUG_LIC('DRUG_LICENSE_1' , S1.FIN_ENTITY , SORDER.SITE_CODE__SHIP) AS SITE_SHIP_DRUGLICNO,
     DDF_INV_LIC_DATE_VALID('DRUG_LICENSE_1' , S1.FIN_ENTITY , SORDER.SITE_CODE__SHIP) AS SITE_SHIP_DRUGLIC_DATE,
     CASE WHEN S2.DESCR IS NULL THEN ' 'ELSE S2.DESCR END AS SITE_DESCR,
     CASE WHEN S2.ADD1 IS NULL THEN ' 'ELSE S2.ADD1 END AS SITE_ADDR1,
     CASE WHEN S2.ADD2 IS NULL THEN ' 'ELSE S2.ADD2 END  AS SITE_ADDR2,
     CASE WHEN S2.ADD3 IS NULL THEN ' 'ELSE S2.ADD3 END AS SITE_ADDR3,
     CASE WHEN S2.CITY IS NULL THEN ' 'ELSE S2.CITY END AS SITE_CITY,
     CASE WHEN S2.PIN IS NULL THEN ' ' ELSE S2.PIN END AS SITE_PIN,
     CASE WHEN S2.STATE_CODE IS NULL THEN ' 'ELSE S2.STATE_CODE END AS SITE_STATE_CODE,
     CASE WHEN C1.CUST_NAME IS NULL THEN ' 'ELSE C1.CUST_NAME END AS SORDER_DLV_TO,
     CASE WHEN SORDER."DLV_ADD1" IS NULL THEN ' 'ELSE SORDER."DLV_ADD1" END AS SORDER_DLV_ADD1,
     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 SORDER."STATE_CODE__DLV" IS NULL THEN ' 'ELSE SORDER."STATE_CODE__DLV" END AS SORDER_STATE_CODE__DLV,
     CASE WHEN C1.DRUG_LIC_NO IS NULL THEN ' ' ELSE C1.DRUG_LIC_NO END AS CUSTOMER_DRUG_LIC_NO,
     C1.DRUG_LICNO_UPTO AS CUSTOMER_DRUG_LICNO_UPTO,
     C2.CUST_NAME AS BILL_TO_CUST_NAME,
     CASE WHEN C2.ADDR1 IS NULL THEN ' 'ELSE C2.ADDR1 END AS BILL_TO_ADD1,
     CASE WHEN C2.ADDR2 IS NULL THEN ' 'ELSE C2.ADDR2 END AS BILL_TO_ADD2,
     CASE WHEN C2.ADDR3 IS NULL THEN ' 'ELSE C2.ADDR3 END AS BILL_TO_ADD3,
     CASE WHEN C2.CITY IS NULL THEN ' 'ELSE C2.CITY END AS BILL_TO_CITY,
     CASE WHEN C2.PIN IS NULL THEN ' 'ELSE C2.PIN END AS BILL_TO_PIN,
     CASE WHEN C2.STATE_CODE IS NULL THEN ' 'ELSE C2.STATE_CODE END AS BILL_TO_STATE_CODE,
     CASE WHEN SORDER."CUST_PORD" IS NULL THEN ' 'ELSE SORDER."CUST_PORD" END AS SORDER_CUST_PORD,
     SORDER."PORD_DATE"  AS SORDER_CUST_PORD_DATE,
     (SELECT WAVE_TASK_DET.PTCN FROM WAVE_TASK_DET WHERE despatch.desp_id = wave_task_det.ref_id and wave_task_det.ref_ser = 'S-DSP') AS  WAVE_TASK_DET_PTCN,
     CASE WHEN SORDER."CUST_CODE__DLV" IS NULL THEN ' 'ELSE SORDER."CUST_CODE__DLV" END AS CUST_CODE__DLV,
     SORDER.ORDER_DATE AS START_DATE,
     DESPATCH.NO_ART as tot_ctns,
     CASE WHEN C1."STORE_NUMBER" IS NULL THEN ' ' ELSE C1."STORE_NUMBER" END AS CUSTOMER_STORE_NUMBER,
     DESPATCH.DESP_DATE AS SHIP_DATE,
     CASE WHEN DESPATCH."GROSS_WEIGHT" IS NULL THEN 0 ELSE DESPATCH."GROSS_WEIGHT" END AS DESPATCH_GROSS_WEIGHT,
     SORDER.DEPT_CODE AS CUST_DEPT,
     (SELECT WAVE_TASK_DET.WAVE_ID FROM WAVE_TASK_DET WHERE despatch.desp_id = wave_task_det.ref_id and wave_task_det.ref_ser = 'S-DSP') AS  WAVE_TASK_DET_WAVE_ID,
     CASE WHEN DESPATCH."SORD_NO" IS NULL THEN ' 'ELSE DESPATCH."SORD_NO" END AS SORD_NO,
     CASE WHEN SORDER."ORDER_STATUS" IS NULL THEN ' 'ELSE SORDER."ORDER_STATUS" END AS SORDER_STATUS
    FROM despatch,
         customer c1,
	 customer c2,
         site s1,
	 site s2,
         sorder
   WHERE
	( sorder.cust_code__dlv = c1.cust_code) and
	( sorder.cust_code__bil = c2.cust_code) and
        ( sorder.site_code = s2.site_code) and
	( sorder.site_code__ship = s1.site_code) and
        ( sorder.sale_order = despatch.sord_no ) and
        (despatch.desp_id) = '$P!{despId}']]>
	</queryString>
	<field name="DESP_ID" class="java.lang.String"/>
	<field name="SITE_SHIP_ADD1" class="java.lang.String"/>
	<field name="SITE_ADDR1" class="java.lang.String"/>
	<field name="CUSTOMER_DRUG_LIC_NO" class="java.lang.String"/>
	<field name="CUSTOMER_DRUG_LICNO_UPTO" class="java.util.Date"/>
	<field name="CUST_CODE__DLV" class="java.lang.String"/>
	<field name="CUSTOMER_STORE_NUMBER" class="java.lang.String"/>
	<field name="SITE_SHIP_DRUGLICNO" class="java.lang.String"/>
	<field name="SITE_SHIP_DRUGLIC_DATE" class="java.util.Date"/>
	<field name="BILL_TO_ADD1" class="java.lang.String"/>
	<field name="SHIP_DATE" class="java.util.Date"/>
	<field name="DESPATCH_GROSS_WEIGHT" class="java.lang.Double"/>
	<field name="SORD_NO" 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_CUST_PORD_DATE" class="java.util.Date"/>
	<field name="CUST_DEPT" class="java.lang.String"/>
	<field name="START_DATE" class="java.util.Date"/>
	<field name="SORDER_STATUS" class="java.lang.String"/>
	<field name="BILL_TO_ADD2" class="java.lang.String"/>
	<field name="BILL_TO_PIN" class="java.lang.String"/>
	<field name="SITE_SHIP_ADD2" class="java.lang.String"/>
	<field name="SITE_SHIP_CITY" class="java.lang.String"/>
	<field name="SITE_SHIP_PIN" class="java.lang.String"/>
	<field name="SITE_ADDR2" class="java.lang.String"/>
	<field name="SITE_ADDR3" class="java.lang.String"/>
	<field name="SITE_CITY" class="java.lang.String"/>
	<field name="SITE_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="BILL_TO_ADD3" class="java.lang.String"/>
	<field name="SITE_SHIP_ADD3" class="java.lang.String"/>
	<field name="tot_ctns" class="java.lang.Integer"/>
	<field name="WAVE_TASK_DET_PTCN" class="java.lang.String"/>
	<field name="WAVE_TASK_DET_WAVE_ID" class="java.lang.String"/>
	<field name="SITE_DESCR_SHIP" class="java.lang.String"/>
	<field name="SITE_SHIP_STATE_CODE" class="java.lang.String"/>
	<field name="SITE_DESCR" class="java.lang.String"/>
	<field name="SITE_STATE_CODE" class="java.lang.String"/>
	<field name="SORDER_STATE_CODE__DLV" class="java.lang.String"/>
	<field name="SORDER_DLV_TO" class="java.lang.String"/>
	<field name="BILL_TO_STATE_CODE" class="java.lang.String"/>
	<field name="BILL_TO_CUST_NAME" class="java.lang.String"/>
	<field name="BILL_TO_CITY" class="java.lang.String"/>
	<variable name="COMPUTE_1" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[new java.lang.String((ibase.webitm.reports.utility.BaseReportMethods.isNull($F{SITE_SHIP_CITY})?" ":($F{SITE_SHIP_CITY}).trim())+" "+(ibase.webitm.reports.utility.BaseReportMethods.isNull($F{SITE_SHIP_STATE_CODE} )?" ":($F{SITE_SHIP_STATE_CODE}).trim())+" "+(ibase.webitm.reports.utility.BaseReportMethods.isNull($F{SITE_SHIP_PIN})?" ":($F{SITE_SHIP_PIN}).trim()))]]></variableExpression>
	</variable>
	<variable name="COMPUTE_2" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[new java.lang.String((ibase.webitm.reports.utility.BaseReportMethods.isNull($F{SORDER_DLV_CITY}) ? " " : ($F{SORDER_DLV_CITY}).trim())+"  "+(ibase.webitm.reports.utility.BaseReportMethods.isNull($F{SORDER_STATE_CODE__DLV} ) ? " " : ($F{SORDER_STATE_CODE__DLV}).trim())+" "+ (ibase.webitm.reports.utility.BaseReportMethods.isNull($F{SORDER_DLV_PIN}) ? " " :($F{SORDER_DLV_PIN}).trim()))]]></variableExpression>
	</variable>
	<variable name="COMPUTE_3" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[new java.lang.String((ibase.webitm.reports.utility.BaseReportMethods.isNull($F{SITE_CITY}) ? " " : ($F{SITE_CITY}).trim())+"  "+(ibase.webitm.reports.utility.BaseReportMethods.isNull($F{SITE_STATE_CODE} ) ? " " : ($F{SITE_STATE_CODE}).trim())+" "+ (ibase.webitm.reports.utility.BaseReportMethods.isNull($F{SITE_PIN}) ? " " :($F{SITE_PIN}).trim()))]]></variableExpression>
	</variable>
	<variable name="COMPUTE_4" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[new java.lang.String((ibase.webitm.reports.utility.BaseReportMethods.isNull($F{BILL_TO_CITY}) ? " " : ($F{BILL_TO_CITY}).trim())+"  "+(ibase.webitm.reports.utility.BaseReportMethods.isNull($F{BILL_TO_STATE_CODE} ) ? " " : ($F{BILL_TO_STATE_CODE}).trim())+" "+ (ibase.webitm.reports.utility.BaseReportMethods.isNull($F{BILL_TO_PIN}) ? " " :($F{BILL_TO_PIN}).trim()))]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="227" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement x="524" y="54" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_ADDR2}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="524" y="35" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_DESCR}]]></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 isBlankWhenNull="true">
				<reportElement x="524" y="108" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{BILL_TO_ADD1}]]></textFieldExpression>
			</textField>
			<textField pattern="MM/dd/yy" isBlankWhenNull="true">
				<reportElement x="378" y="168" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{SORDER_CUST_PORD_DATE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="706" y="13" width="32" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Page :]]></text>
			</staticText>
			<staticText>
				<reportElement x="693" y="23" width="10" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[At ]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="69" y="187" width="72" height="9"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CUSTOMER_STORE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="682" y="186" width="72" height="9"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{DESPATCH_GROSS_WEIGHT}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="98" y="148" width="100" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![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 isBlankWhenNull="true">
				<reportElement x="524" y="72" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{COMPUTE_3}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="71" y="35" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_DESCR_SHIP}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="69" y="168" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![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>
			<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 isBlankWhenNull="true">
				<reportElement x="71" y="108" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SORDER_DLV_ADD1}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="69" y="205" width="72" height="9"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SORD_NO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="23" y="19" width="46" height="10">
					<printWhenExpression><![CDATA[new Boolean(false)]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Wh/Co/Div::]]></text>
			</staticText>
			<staticText>
				<reportElement x="23" y="10" width="75" height="10">
					<printWhenExpression><![CDATA[new Boolean(false)]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[packing_slip_rep]]></text>
			</staticText>
			<textField pattern="MM/dd/yy" isBlankWhenNull="true">
				<reportElement x="378" y="187" width="72" height="9"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{SHIP_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="yyyy-MM-dd" isBlankWhenNull="true">
				<reportElement x="279" y="151" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{CUSTOMER_DRUG_LICNO_UPTO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="69" y="178" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CUST_CODE__DLV}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="682" y="177" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$F{tot_ctns}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="682" y="167" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{WAVE_TASK_DET_PTCN}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="71" y="70" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{COMPUTE_1}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="98" y="82" width="100" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_SHIP_DRUGLICNO}]]></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="yyyy-MM-dd" isBlankWhenNull="true">
				<reportElement x="279" y="82" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{SITE_SHIP_DRUGLIC_DATE}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="71" y="43" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_SHIP_ADD1}]]></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 isBlankWhenNull="true">
				<reportElement x="71" y="98" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SORDER_DLV_TO}]]></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 isBlankWhenNull="true">
				<reportElement x="71" y="126" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SORDER_DLV_ADD3}]]></textFieldExpression>
			</textField>
			<textField pattern="HH:mm:ss">
				<reportElement x="703" y="23" width="51" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="71" y="61" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_SHIP_ADD3}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="737" y="13" width="17" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$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="MM/dd/yy">
				<reportElement x="653" y="23" width="40" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="71" y="52" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_SHIP_ADD2}]]></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="MM/dd/yy" isBlankWhenNull="true">
				<reportElement x="378" y="178" width="72" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{START_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 isBlankWhenNull="true">
				<reportElement x="524" y="126" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{BILL_TO_ADD3}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="682" y="195" width="72" height="9"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{WAVE_TASK_DET_WAVE_ID}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="524" y="117" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{BILL_TO_ADD2}]]></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 isBlankWhenNull="true">
				<reportElement x="71" y="117" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SORDER_DLV_ADD2}]]></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="true">
				<reportElement x="71" y="19" width="39" height="10">
					<printWhenExpression><![CDATA[new Boolean(false)]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_SHIP_STATE_CODE}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="71" y="135" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{COMPUTE_2}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="524" y="135" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{COMPUTE_4}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="228" y="204" width="51" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SORDER_STATUS}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="524" y="63" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_ADDR3}]]></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 isBlankWhenNull="true">
				<reportElement x="524" y="45" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_ADDR1}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="524" y="99" width="170" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{BILL_TO_CUST_NAME}]]></textFieldExpression>
			</textField>
			<subreport>
				<reportElement stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" x="9" y="214" width="753" height="13" isRemoveLineWhenBlank="true"/>
				<parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression>
				<subreportParameter name="despId">
					<subreportParameterExpression><![CDATA[$F{DESP_ID}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.io.InputStream"><![CDATA[new FileInputStream("/data/jboss-5.1.0.GA/server/default/deploy/ibase.ear/ibase.war/webitm/reports/jrxml/packing_slip_rep_subreport1.jasper")]]></subreportExpression>
			</subreport>
		</band>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band splitType="Stretch"/>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="37" splitType="Stretch">
			<line>
				<reportElement x="23" y="15" width="739" 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="739" height="1"/>
			</line>
			<staticText>
				<reportElement x="226" y="18" 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>
