<?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="BOL1_subreport2" pageWidth="612" pageHeight="792" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="DESP_DESP_ID" class="java.lang.String"/>
	<queryString>
		<![CDATA[select count1,	shipment_id, case when no_pallet > 0 then 'P' else 'M' end pick_type, tot_pkt, gross_weigh, NMFC_NO, NMFC_DESCR, FRT_CLASS
from table (BOLTYPEMANUALTBL('$P!{DESP_DESP_ID}','SUB2'))]]>
	</queryString>
	<field name="COUNT1" class="java.lang.Integer"/>
	<field name="PICK_TYPE" class="java.lang.String"/>
	<field name="TOT_PKT" class="java.lang.Double"/>
	<field name="GROSS_WEIGH" class="java.lang.Double"/>
	<field name="NMFC_NO" class="java.lang.String"/>
	<field name="NMFC_DESCR" class="java.lang.String"/>
	<field name="FRT_CLASS" class="java.lang.String"/>
	<field name="shipment_id" class="java.lang.String"/>
	<variable name="TOT_PKT_3" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[new java.lang.Double($F{TOT_PKT}.doubleValue())]]></variableExpression>
	</variable>
	<variable name="COUNT_3" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[new java.lang.Double($F{COUNT1}.doubleValue())]]></variableExpression>
	</variable>
	<variable name="GROSS_WEIGH_2" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[new java.lang.Double($F{GROSS_WEIGH}.doubleValue())]]></variableExpression>
	</variable>
	<variable name="Pick_type" class="java.lang.String">
		<variableExpression><![CDATA[new java.lang.String($F{PICK_TYPE}.equals("M")?"CTN":"PLT")]]></variableExpression>
	</variable>
	<group name="GRAND_TOTAL">
		<groupExpression><![CDATA[$V{GROSS_WEIGH_2}]]></groupExpression>
		<groupFooter>
			<band/>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="48" splitType="Stretch">
			<staticText>
				<reportElement x="107" y="33" width="25" height="15"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[TYPE]]></text>
			</staticText>
			<staticText>
				<reportElement x="13" y="33" width="20" height="15"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[QTY]]></text>
			</staticText>
			<staticText>
				<reportElement x="6" y="18" width="65" height="11"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[HANDLING UNIT]]></text>
			</staticText>
			<line>
				<reportElement x="480" y="27" width="84" height="1"/>
			</line>
			<line>
				<reportElement x="71" y="13" width="1" height="35"/>
			</line>
			<line>
				<reportElement x="523" y="27" width="1" height="20"/>
			</line>
			<line>
				<reportElement x="38" y="31" width="1" height="17"/>
			</line>
			<staticText>
				<reportElement x="80" y="18" width="50" height="15"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[PACKAGE]]></text>
			</staticText>
			<line>
				<reportElement x="104" y="31" width="1" height="17"/>
			</line>
			<staticText>
				<reportElement x="498" y="15" width="50" height="14"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[LTL ONLY]]></text>
			</staticText>
			<staticText>
				<reportElement x="79" y="33" width="20" height="15"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[QTY]]></text>
			</staticText>
			<staticText>
				<reportElement x="256" y="25" width="220" height="23"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Commodities requiring special or additional care or attention in handling or stowing must be so marked and packaged as to ensure safe transportation with ordinary care.]]></text>
			</staticText>
			<line>
				<reportElement x="241" y="14" width="1" height="34"/>
			</line>
			<staticText>
				<reportElement x="144" y="29" width="50" height="15"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[WEIGHT]]></text>
			</staticText>
			<line direction="BottomUp">
				<reportElement x="5" y="13" width="1" height="35"/>
			</line>
			<line>
				<reportElement x="479" y="13" width="1" height="35"/>
			</line>
			<staticText>
				<reportElement x="210" y="23" width="20" height="25"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[H.M. (X)]]></text>
			</staticText>
			<line>
				<reportElement x="5" y="30" width="132" height="1"/>
			</line>
			<staticText>
				<reportElement x="524" y="29" width="35" height="15"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[CLASS]]></text>
			</staticText>
			<staticText>
				<reportElement x="484" y="29" width="35" height="15"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[NMFC #]]></text>
			</staticText>
			<line>
				<reportElement x="564" y="13" width="1" height="35"/>
			</line>
			<line>
				<reportElement x="137" y="13" width="1" height="35"/>
			</line>
			<staticText>
				<reportElement x="282" y="15" width="150" height="13"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[COMMODITY DESCRIPTION]]></text>
			</staticText>
			<line>
				<reportElement x="202" y="13" width="1" height="35"/>
			</line>
			<staticText>
				<reportElement x="42" y="33" width="25" height="15"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[TYPE]]></text>
			</staticText>
			<staticText>
				<reportElement x="257" y="1" width="100" height="20"/>
				<textElement/>
				<text><![CDATA[NMFC_DESCR]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="5" y="0" width="560" height="15" forecolor="#FEFEFE" backcolor="#010101"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[CARRIER INFORMATION]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="16" splitType="Stretch">
			<line>
				<reportElement x="5" y="0" width="560" height="1"/>
			</line>
			<line>
				<reportElement x="5" y="15" width="560" height="1"/>
			</line>
			<line>
				<reportElement x="5" y="0" width="1" height="15"/>
			</line>
			<line>
				<reportElement x="38" y="0" width="1" height="15"/>
			</line>
			<line>
				<reportElement x="71" y="0" width="1" height="15"/>
			</line>
			<line>
				<reportElement x="104" y="0" width="1" height="15"/>
			</line>
			<line>
				<reportElement x="137" y="0" width="1" height="15"/>
			</line>
			<line>
				<reportElement x="202" y="0" width="1" height="15"/>
			</line>
			<line>
				<reportElement x="241" y="0" width="1" height="15"/>
			</line>
			<line>
				<reportElement x="479" y="0" width="1" height="15"/>
			</line>
			<line>
				<reportElement x="523" y="0" width="1" height="15"/>
			</line>
			<line>
				<reportElement x="564" y="0" width="1" height="15"/>
			</line>
			<staticText>
				<reportElement x="106" y="2" width="30" height="12">
					<printWhenExpression><![CDATA[new Boolean($F{COUNT1}.intValue()>0)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial"/>
				</textElement>
				<text><![CDATA[CTN]]></text>
			</staticText>
			<textField pattern="0">
				<reportElement x="5" y="3" width="30" height="12">
					<printWhenExpression><![CDATA[new Boolean($F{COUNT1}.intValue()>0)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$F{COUNT1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="40" y="3" width="30" height="12">
					<printWhenExpression><![CDATA[new Boolean($F{COUNT1}.intValue()>0)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center">
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{Pick_type}]]></textFieldExpression>
			</textField>
			<textField pattern="0" isBlankWhenNull="true">
				<reportElement x="72" y="2" width="30" height="12">
					<printWhenExpression><![CDATA[new Boolean($F{COUNT1}.intValue()>0)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{TOT_PKT}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="525" y="3" width="39" height="12">
					<printWhenExpression><![CDATA[new Boolean($F{COUNT1}.intValue()>0)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FRT_CLASS}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="480" y="3" width="43" height="12">
					<printWhenExpression><![CDATA[new Boolean($F{COUNT1}.intValue()>0)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NMFC_NO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="138" y="2" width="60" height="12">
					<printWhenExpression><![CDATA[new Boolean($F{COUNT1}.intValue()>0)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{GROSS_WEIGH}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="245" y="2" width="230" height="12">
					<printWhenExpression><![CDATA[new Boolean($F{COUNT1}.intValue()>0)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NMFC_DESCR}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="15" splitType="Stretch">
			<line>
				<reportElement x="5" y="0" width="1" height="15"/>
			</line>
			<rectangle>
				<reportElement x="104" y="0" width="33" height="15" backcolor="#AD9CA4"/>
			</rectangle>
			<rectangle>
				<reportElement x="38" y="0" width="33" height="15" backcolor="#AD9CA4"/>
			</rectangle>
			<rectangle>
				<reportElement x="479" y="0" width="44" height="15" backcolor="#AD9CA4"/>
			</rectangle>
			<rectangle>
				<reportElement x="523" y="0" width="41" height="15" backcolor="#AD9CA4"/>
			</rectangle>
			<staticText>
				<reportElement x="297" y="3" width="100" height="12"/>
				<textElement>
					<font fontName="Arial" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[GRAND TOTAL]]></text>
			</staticText>
			<rectangle>
				<reportElement x="202" y="0" width="40" height="15" backcolor="#AD9CA4"/>
			</rectangle>
			<textField pattern="0" isBlankWhenNull="true">
				<reportElement x="73" y="3" width="30" height="12"/>
				<textElement textAlignment="Right">
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{TOT_PKT_3}]]></textFieldExpression>
			</textField>
			<textField pattern="0" isBlankWhenNull="true">
				<reportElement x="5" y="3" width="30" height="12"/>
				<textElement textAlignment="Right">
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{COUNT_3}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="139" y="3" width="60" height="12"/>
				<textElement textAlignment="Right">
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{GROSS_WEIGH_2}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>
