<?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="shippers_Expo_subreport1" pageWidth="555" pageHeight="802" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="2.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="DespId" class="java.lang.String"/>
	<queryString>
		<![CDATA[SELECT
     ITEM."ITEM_CODE"  AS ITEM_ITEM_CODE ,
    case when  ITEM."COUNT_CODE__MFG" is null then '0' else  ITEM."COUNT_CODE__MFG" end AS ITEM_COUNT_CODE__MFG,
    case when  ITEM."HARMONIZATION_NO" is null then '0' else  ITEM."HARMONIZATION_NO" end AS ITEM_HARMONIZATION_NO,
    case when DESPATCHDET."QUANTITY" is null then 0 else  DESPATCHDET."QUANTITY" end  AS DESPATCHDET_QUANTITY,
    case when  DESPATCHDET."RATE__STDUOM" is null then 0 else DESPATCHDET."RATE__STDUOM" end AS DESPATCHDET_RATE__STDUOM,
    case when  DESPATCH."GROSS_WEIGHT" is null then 0 else  DESPATCH."GROSS_WEIGHT" end  AS DESPATCH_GROSS_WEIGHT
FROM
     "LCK"."ITEM" ITEM ,
     "LCK"."DESPATCHDET" DESPATCHDET,
     "LCK"."DESPATCH" DESPATCH
WHERE
      ITEM."ITEM_CODE" = DESPATCHDET."ITEM_CODE"
    AND  DESPATCHDET."DESP_ID" = DESPATCH."DESP_ID"
   AND trim(DESPATCH."DESP_ID") = trim($P{DespId})]]>
	</queryString>
	<field name="ITEM_ITEM_CODE" class="java.lang.String"/>
	<field name="ITEM_COUNT_CODE__MFG" class="java.lang.String"/>
	<field name="ITEM_HARMONIZATION_NO" class="java.lang.String"/>
	<field name="DESPATCHDET_QUANTITY" class="java.lang.String"/>
	<field name="DESPATCHDET_RATE__STDUOM" class="java.lang.String"/>
	<field name="DESPATCH_GROSS_WEIGHT" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="21" splitType="Stretch">
			<line>
				<reportElement x="0" y="0" width="555" height="1"/>
			</line>
			<line>
				<reportElement x="0" y="20" width="555" height="1"/>
			</line>
			<line>
				<reportElement x="1" y="0" width="1" height="20"/>
			</line>
			<line>
				<reportElement x="34" y="1" width="1" height="19"/>
			</line>
			<line>
				<reportElement x="259" y="1" width="1" height="19"/>
			</line>
			<line>
				<reportElement x="331" y="1" width="1" height="20"/>
			</line>
			<line>
				<reportElement x="472" y="-1" width="1" height="22"/>
			</line>
			<line>
				<reportElement x="554" y="1" width="1" height="19"/>
			</line>
			<textField>
				<reportElement x="41" y="4" width="80" height="10"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{ITEM_ITEM_CODE}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="153" y="5" width="95" height="9"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{ITEM_HARMONIZATION_NO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="339" y="5" width="55" height="9"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCH_GROSS_WEIGHT}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="482" y="5" width="61" height="9"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCHDET_RATE__STDUOM}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="4" y="5" width="29" height="9"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{ITEM_COUNT_CODE__MFG}.contains("IND")?"D":"F"]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="400" y="0" width="1" height="21"/>
			</line>
			<textField>
				<reportElement x="269" y="5" width="55" height="9"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESPATCHDET_QUANTITY}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
