<?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="CommInvoice" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="782" leftMargin="5" rightMargin="5" topMargin="20" bottomMargin="10">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="284"/>
	<property name="ireport.y" value="25"/>
	<parameter name="InvoiceIdFrom" class="java.lang.String"/>
	<parameter name="InvoiceIdTo" class="java.lang.String"/>
	<parameter name="DateFrom" class="java.util.Date"/>
	<parameter name="DateTo" class="java.util.Date"/>
	<queryString>
		<![CDATA[SELECT	SITE.DESCR SITE_DESCR,
         SITE.ADD1 SITE_ADD1,
         case when SITE.ADD2 is null then ' ' else SITE.ADD2 end SITE_ADD2,
         case when SITE.ADD3 is null then ' ' else SITE.ADD3 end SITE_ADD3,
         case when SITE.CITY is null then ' ' else SITE.CITY end SITE_CITY,
         case when SITE.PIN is null then ' ' else SITE.PIN end SITE_PIN,
         case when SITE.TELE1 is null then ' ' else SITE.TELE1 end SITE_TELE,
			SITE.STATE_CODE SITE_STATE_CODE,
			SITE.DESCR SITE_STATE_DESCR,
			STATE.COUNT_CODE SITE_COUNT_CODE,
			COUNTRY.DESCR SITE_COUNT_DESCR,
			(SELECT CUST_NAME FROM CUSTOMER WHERE CUSTOMER.CUST_CODE = SORDER.CUST_CODE__DLV) CUST_NAME,
         case when CUSTOMER.TELE1 is null then ' ' else CUSTOMER.TELE1 end CUST_TELE,
         case when CUSTOMER.ADDR1 is null then ' ' else CUSTOMER.ADDR1 end CUST_ADD1,
         case when CUSTOMER.ADDR2 is null then ' ' else CUSTOMER.ADDR2 end CUST_ADD2,
         case when CUSTOMER.ADDR3 is null then ' ' else CUSTOMER.ADDR3 end CUST_ADD3,
         case when CUSTOMER.CITY is null then ' ' else CUSTOMER.CITY end CUST_CITY,
         case when CUSTOMER.STATE_CODE is null then ' ' else CUSTOMER.STATE_CODE end CUST_STATE_CODE,
         case when CUSTOMER.PIN is null then ' ' else CUSTOMER.PIN end CUST_PIN,
			CUST_COUNTRY.DESCR CUST_COUNTRY,
			INVOICE.INVOICE_ID,
			INVOICE.TRAN_DATE,
         case when SORDER.CUST_PORD is null then ' ' else SORDER.CUST_PORD end CUST_PORD,
         case when SD.SHIPMENT_ID is null then ' ' else SD.SHIPMENT_ID end SHIPMENT_ID,
			DESPATCH.STAN_CODE__DEST,
			DESPATCH.DESP_ID,
			CASE WHEN DESPATCH.TRANS_MODE = 'A' THEN 'By Air' WHEN DESPATCH.TRANS_MODE = 'R' THEN 'By Road' WHEN DESPATCH.TRANS_MODE = 'L' THEN 'By Rail' WHEN DESPATCH.TRANS_MODE = 'S' THEN 'By Ship' ELSE ' ' END TRAN_MODE,
			INVOICE.CURR_CODE,
			DESPATCH.GROSS_WEIGHT,
			DESPATCH.NO_ART,
			(SELECT sum(INVOICE_TRACE.quantity__stduom * INVOICE_TRACE.rate__stduom)  FROM INVOICE_TRACE WHERE INVOICE_TRACE.INVOICE_ID = INVOICE.INVOICE_ID) AS TOTAL_AMOUNT,
	despatch.tran_code,
	(SELECT PTCN FROM WAVE_TASK_DET WHERE DESPATCH.DESP_ID = WAVE_TASK_DET.REF_ID) AS PTCN,
	(SELECT DISPARM.VAR_VALUE FROM DISPARM WHERE VAR_NAME = 'WMS_DOC_AUTHORITY' AND PRD_CODE = '999999') AS EXPT_NAME
FROM INVOICE, SITE, STATE, COUNTRY, CUSTOMER, COUNTRY CUST_COUNTRY,
SORDER, DESPATCH, SHIP_DOCS SD
WHERE SITE.SITE_CODE = INVOICE.SITE_CODE
AND SORDER.SALE_ORDER = INVOICE.SALE_ORDER
AND DESPATCH.DESP_ID = INVOICE.DESP_ID
AND SD.REF_ID = INVOICE.DESP_ID
AND CUSTOMER.CUST_CODE = SORDER.CUST_CODE__DLV
AND STATE.STATE_CODE = SITE.STATE_CODE
AND COUNTRY.COUNT_CODE = STATE.COUNT_CODE
AND CUST_COUNTRY.COUNT_CODE = SORDER.COUNT_CODE__DLV
AND INVOICE.INVOICE_ID >= '$P!{InvoiceIdFrom}'
AND INVOICE.INVOICE_ID <= '$P!{InvoiceIdTo}'
AND INVOICE.TRAN_DATE >= $P{DateFrom}
AND INVOICE.TRAN_DATE <= $P{DateTo}
ORDER BY INVOICE.INVOICE_ID]]>
	</queryString>
	<field name="SITE_DESCR" class="java.lang.String"/>
	<field name="SITE_ADD1" class="java.lang.String"/>
	<field name="SITE_ADD2" class="java.lang.String"/>
	<field name="SITE_ADD3" class="java.lang.String"/>
	<field name="SITE_CITY" class="java.lang.String"/>
	<field name="SITE_PIN" class="java.lang.String"/>
	<field name="SITE_TELE" class="java.lang.String"/>
	<field name="SITE_STATE_CODE" class="java.lang.String"/>
	<field name="SITE_STATE_DESCR" class="java.lang.String"/>
	<field name="SITE_COUNT_CODE" class="java.lang.String"/>
	<field name="SITE_COUNT_DESCR" class="java.lang.String"/>
	<field name="CUST_NAME" class="java.lang.String"/>
	<field name="CUST_TELE" class="java.lang.String"/>
	<field name="CUST_ADD1" class="java.lang.String"/>
	<field name="CUST_ADD2" class="java.lang.String"/>
	<field name="CUST_ADD3" class="java.lang.String"/>
	<field name="CUST_CITY" class="java.lang.String"/>
	<field name="CUST_STATE_CODE" class="java.lang.String"/>
	<field name="CUST_PIN" class="java.lang.String"/>
	<field name="CUST_COUNTRY" class="java.lang.String"/>
	<field name="INVOICE_ID" class="java.lang.String"/>
	<field name="TRAN_DATE" class="java.util.Date"/>
	<field name="CUST_PORD" class="java.lang.String"/>
	<field name="SHIPMENT_ID" class="java.lang.String"/>
	<field name="STAN_CODE__DEST" class="java.lang.String"/>
	<field name="DESP_ID" class="java.lang.String"/>
	<field name="TRAN_MODE" class="java.lang.String"/>
	<field name="CURR_CODE" class="java.lang.String"/>
	<field name="GROSS_WEIGHT" class="java.lang.Double"/>
	<field name="NO_ART" class="java.lang.Double"/>
	<field name="TOTAL_AMOUNT" class="java.lang.Double"/>
	<field name="tran_code" class="java.lang.String"/>
	<field name="PTCN" class="java.lang.String"/>
	<field name="EXPT_NAME" class="java.lang.String"/>
	<variable name="compute_1" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[new java.lang.String(ibase.webitm.reports.sun.BaseReportGFMethods.gf_bar_code(ibase.webitm.reports.utility.BaseReportMethods.trim( $F{SHIPMENT_ID}) ) )]]></variableExpression>
	</variable>
	<variable name="compute_2" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[new java.lang.String($F{GROSS_WEIGHT}.doubleValue() + " (Lbs)")]]></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{CUST_CITY}) ? " " : ($F{CUST_CITY}).trim())+"  "+(ibase.webitm.reports.utility.BaseReportMethods.isNull($F{CUST_STATE_CODE} ) ? " " : ($F{CUST_STATE_CODE}).trim())+" "+ (ibase.webitm.reports.utility.BaseReportMethods.isNull($F{CUST_PIN}) ? " " :($F{CUST_PIN}).trim()))]]></variableExpression>
	</variable>
	<variable name="COMPUTE_5" class="java.lang.Double" resetType="None">
		<variableExpression><![CDATA[new java.lang.Double($F{TOTAL_AMOUNT}.doubleValue())]]></variableExpression>
	</variable>
	<group name="invoiceId" isStartNewPage="true" isResetPageNumber="true" footerPosition="ForceAtBottom">
		<groupExpression><![CDATA[$F{INVOICE_ID}]]></groupExpression>
		<groupHeader>
			<band height="438" splitType="Stretch">
				<line>
					<reportElement x="0" y="2" width="782" height="1" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<staticText>
					<reportElement x="16" y="3" width="262" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[EXPORTER (Name, Phone Number, Address, Country)]]></text>
				</staticText>
				<textField isBlankWhenNull="true">
					<reportElement x="25" y="24" width="262" height="11" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_TELE}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="25" y="46" width="262" height="11" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_ADD1}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="25" y="57" width="128" height="11" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_ADD2}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="25" y="67" width="264" height="11" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$V{compute_3}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="25" y="77" width="262" height="11" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_COUNT_DESCR}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement x="0" y="87" width="782" height="1" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<line>
					<reportElement x="0" y="241" width="780" height="1" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<line>
					<reportElement x="1" y="213" width="780" height="1" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<line>
					<reportElement x="1" y="195" width="780" height="1" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<staticText>
					<reportElement x="16" y="90" width="264" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[CONSIGNEE (Name, Phone Number, Full Address, Country)]]></text>
				</staticText>
				<textField isBlankWhenNull="true">
					<reportElement x="25" y="100" width="264" height="14" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{CUST_NAME}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="25" y="111" width="264" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{CUST_TELE}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="25" y="121" width="264" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{CUST_ADD1}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="25" y="130" width="128" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{CUST_ADD2}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="25" y="141" width="260" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$V{compute_4}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="25" y="152" width="264" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{CUST_COUNTRY}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement x="304" y="3" width="1" height="193" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<textField pattern="MM/dd/yy" isBlankWhenNull="true">
					<reportElement x="317" y="16" width="100" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.util.Date"><![CDATA[$F{TRAN_DATE}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="430" y="16" width="100" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean(false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{INVOICE_ID}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="306" y="6" width="235" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[INVOICE DATE AND NUMBER]]></text>
				</staticText>
				<line>
					<reportElement x="305" y="34" width="476" height="1" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<line>
					<reportElement x="305" y="52" width="476" height="1" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<staticText>
					<reportElement x="306" y="36" width="100" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[OTHER REFERENCES]]></text>
				</staticText>
				<staticText>
					<reportElement x="563" y="5" width="171" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[CUSTOMER'S ORDER NUMBER]]></text>
				</staticText>
				<staticText>
					<reportElement x="563" y="55" width="100" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[CURRENCY OF SALE]]></text>
				</staticText>
				<staticText>
					<reportElement x="306" y="55" width="100" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[PRESENTING BANK]]></text>
				</staticText>
				<line>
					<reportElement x="562" y="2" width="1" height="33" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<textField isBlankWhenNull="true">
					<reportElement x="644" y="16" width="124" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{CUST_PORD}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement x="562" y="52" width="1" height="144" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<textField isBlankWhenNull="true">
					<reportElement x="578" y="64" width="100" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{CURR_CODE}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="306" y="91" width="189" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[IMPORTER (if other than consignee)]]></text>
				</staticText>
				<staticText>
					<reportElement x="563" y="91" width="59" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[Shipment ID :]]></text>
				</staticText>
				<textField isBlankWhenNull="true">
					<reportElement x="622" y="91" width="145" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean(($V{PAGE_NUMBER}.intValue() == 1 )?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{SHIPMENT_ID}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="16" y="197" width="111" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[PORT OF LOADING]]></text>
				</staticText>
				<line>
					<reportElement x="248" y="196" width="1" height="18" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<line>
					<reportElement x="533" y="196" width="1" height="17" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<staticText>
					<reportElement x="250" y="197" width="251" height="8" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[TERMS AND CONDITIONS OF DELIVERY AND PAYMENT]]></text>
				</staticText>
				<staticText>
					<reportElement x="535" y="197" width="215" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[OTHER TRANSPORTATION INFORMATION]]></text>
				</staticText>
				<staticText>
					<reportElement x="16" y="216" width="137" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[COUNTRY OF FINAL DESTINATION]]></text>
				</staticText>
				<textField isBlankWhenNull="true">
					<reportElement x="22" y="228" width="150" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{CUST_COUNTRY}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement x="177" y="214" width="1" height="27" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<staticText>
					<reportElement x="178" y="216" width="100" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[SHIP / AIR / ETC.]]></text>
				</staticText>
				<textField isBlankWhenNull="true">
					<reportElement x="185" y="228" width="100" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{TRAN_MODE}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement x="291" y="214" width="1" height="27" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<staticText>
					<reportElement x="293" y="216" width="131" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[DESCRIPTION OF GOODS]]></text>
				</staticText>
				<line>
					<reportElement x="437" y="215" width="1" height="27" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<line>
					<reportElement x="622" y="214" width="1" height="27" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
				</line>
				<staticText>
					<reportElement x="439" y="215" width="100" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[GROSS WEIGHT]]></text>
				</staticText>
				<textField pattern="0" isBlankWhenNull="true">
					<reportElement x="652" y="224" width="100" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.Double"><![CDATA[$F{NO_ART}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="16" y="243" width="100" height="10" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[SHIPPER'S NUMBER :]]></text>
				</staticText>
				<textField isBlankWhenNull="true">
					<reportElement x="569" y="107" width="203" height="73" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean(($V{PAGE_NUMBER}.intValue() == 1 )?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Code 128AB" size="40"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$V{compute_1}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="479" y="224" width="100" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$V{compute_2}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="253" y="205" width="121" height="8" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="false"/>
					</textElement>
					<text><![CDATA[DDU Destination]]></text>
				</staticText>
				<textField isBlankWhenNull="true">
					<reportElement x="99" y="245" width="150" height="13" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{PTCN}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="25" y="35" width="262" height="11" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_DESCR}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="25" y="14" width="262" height="11" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{EXPT_NAME}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="623" y="215" width="100" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[Total Cases]]></text>
				</staticText>
				<textField isBlankWhenNull="true">
					<reportElement x="159" y="57" width="128" height="11" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{SITE_ADD3}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="161" y="130" width="128" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
					</reportElement>
					<textElement>
						<font fontName="Courier New" size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{CUST_ADD3}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement stretchType="RelativeToBandHeight" x="417" y="259" width="1" height="178" isRemoveLineWhenBlank="true"/>
				</line>
				<line>
					<reportElement stretchType="RelativeToBandHeight" x="501" y="259" width="1" height="178" isRemoveLineWhenBlank="true"/>
				</line>
				<line>
					<reportElement stretchType="RelativeToBandHeight" x="574" y="259" width="1" height="178" isRemoveLineWhenBlank="true"/>
				</line>
				<line>
					<reportElement stretchType="RelativeToBandHeight" x="653" y="259" width="1" height="178" isRemoveLineWhenBlank="true"/>
				</line>
				<line>
					<reportElement stretchType="RelativeToBandHeight" x="721" y="259" width="1" height="178" isRemoveLineWhenBlank="true"/>
				</line>
				<line>
					<reportElement stretchType="RelativeToBandHeight" x="206" y="259" width="1" height="178"/>
				</line>
				<subreport>
					<reportElement isPrintRepeatedValues="false" x="-1" y="259" width="755" height="151" isRemoveLineWhenBlank="true"/>
					<parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression>
					<subreportParameter name="InvoiceId">
						<subreportParameterExpression><![CDATA[$F{INVOICE_ID}]]></subreportParameterExpression>
					</subreportParameter>
					<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					<subreportExpression class="java.io.InputStream"><![CDATA[new FileInputStream("C:/jboss-5.1.0.GA/server/default/deploy/ibase.ear/ibase.war/webitm/reports/jrxml/CommInvDet.jasper")]]></subreportExpression>
				</subreport>
			</band>
		</groupHeader>
		<groupFooter>
			<band/>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="14">
			<staticText>
				<reportElement x="265" y="0" width="268" height="14"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom">
					<font fontName="Courier New" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[Commercial Invoice]]></text>
			</staticText>
			<staticText>
				<reportElement x="734" y="0" width="33" height="14"/>
				<textElement verticalAlignment="Bottom">
					<font fontName="Courier New" size="8"/>
				</textElement>
				<text><![CDATA[Page :]]></text>
			</staticText>
			<textField evaluationTime="Page" isBlankWhenNull="true">
				<reportElement x="754" y="0" width="14" height="14"/>
				<textElement textAlignment="Right" verticalAlignment="Bottom">
					<font fontName="Courier New" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<pageFooter>
		<band height="130" splitType="Stretch">
			<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
			<staticText>
				<reportElement x="15" y="2" width="522" height="46" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font fontName="Courier New" size="6"/>
				</textElement>
				<text><![CDATA[THESE COMMODITIES ARE LICENSED FOR THE ULTIMATE DESTINATION SHOWN.
THESE COMMODITIES, TECHNOLOGY, OR SOFTWARE WERE EXPORTED FROM THE UNITED STATES IN ACCORDANCE
WITH THE EXPORT ADMINISTRATION REGULATIONS, DIVERSION CONTRARY TO U.S. LAW IS PROHIBITED.

IT IS HEREBY CERTIIFIED THAT THIS INVOICE SHOWS THAT ACTUAL PRICE OF THE GOODS DESCRIBED.
THAT NO OTHER INVOICE HAS BEEN OR WILL BE ISSUED AND THAT ALL PARTICULARS ARE TRUE AND CORRECT.]]></text>
			</staticText>
			<staticText>
				<reportElement x="17" y="83" width="214" height="14" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font fontName="Courier New" size="8"/>
				</textElement>
				<text><![CDATA[SIGNATURE AND STATUS OF AUTHORIZED PERSON]]></text>
			</staticText>
			<staticText>
				<reportElement x="17" y="63" width="8" height="22" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font fontName="Courier New" size="13" isBold="true"/>
				</textElement>
				<text><![CDATA[X]]></text>
			</staticText>
			<line>
				<reportElement x="0" y="99" width="782" height="1" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
			</line>
			<staticText>
				<reportElement x="281" y="83" width="100" height="14" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[DATE]]></text>
			</staticText>
			<staticText>
				<reportElement x="413" y="83" width="100" height="14" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[PLACE]]></text>
			</staticText>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement x="579" y="90" width="93" height="9" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{COMPUTE_5}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="-1" y="81" width="782" height="1" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
			</line>
			<line>
				<reportElement x="574" y="63" width="206" height="1" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
			</line>
			<line>
				<reportElement x="574" y="46" width="206" height="1" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
			</line>
			<line>
				<reportElement x="574" y="28" width="206" height="1" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
			</line>
			<line>
				<reportElement x="-1" y="0" width="782" height="1" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
			</line>
			<staticText>
				<reportElement x="578" y="14" width="100" height="12" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font fontName="Courier New" size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[PACKING COSTS]]></text>
			</staticText>
			<staticText>
				<reportElement x="578" y="32" width="100" height="12" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font fontName="Courier New" size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[FREIGHT COSTS]]></text>
			</staticText>
			<staticText>
				<reportElement x="578" y="49" width="100" height="12" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font fontName="Courier New" size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[OTHER COSTS]]></text>
			</staticText>
			<staticText>
				<reportElement x="578" y="66" width="100" height="12" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font fontName="Courier New" size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[INSURANCE COSTS]]></text>
			</staticText>
			<staticText>
				<reportElement x="578" y="83" width="100" height="14" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font fontName="Courier New" size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL INVOICE COSTS]]></text>
			</staticText>
			<line>
				<reportElement x="574" y="0" width="1" height="99" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[new Boolean($V{PAGE_NUMBER}.intValue() == 1?true:false)]]></printWhenExpression>
				</reportElement>
			</line>
		</band>
	</pageFooter>
</jasperReport>
