<?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="BOL_Manual_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="177"/>
	<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="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="479" y="27" width="84" height="1"/>
			</line>
			<line>
				<reportElement x="71" y="13" width="1" height="35"/>
			</line>
			<line>
				<reportElement x="522" y="27" width="1" height="20"/>
			</line>
			<line>
				<reportElement x="38" y="31" width="1" height="17"/>
			</line>
			<staticText>
				<reportElement x="497" 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="190" y="29" width="272" height="17"/>
				<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="175" y="14" width="1" height="34"/>
			</line>
			<staticText>
				<reportElement x="73" y="27" width="63" 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="478" y="13" width="1" height="35"/>
			</line>
			<staticText>
				<reportElement x="143" y="23" width="27" 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="65" height="1"/>
			</line>
			<staticText>
				<reportElement x="523" y="30" width="35" height="15"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[CLASS]]></text>
			</staticText>
			<staticText>
				<reportElement x="483" y="30" width="35" height="15"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[NMFC #]]></text>
			</staticText>
			<line>
				<reportElement x="563" y="13" width="1" height="35"/>
			</line>
			<staticText>
				<reportElement x="216" y="17" width="225" height="13"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[COMMODITY DESCRIPTION]]></text>
			</staticText>
			<line>
				<reportElement x="136" 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="559" 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="15" width="559" 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="136" y="0" width="1" height="15"/>
			</line>
			<line>
				<reportElement x="175" y="0" width="1" height="15"/>
			</line>
			<line>
				<reportElement x="478" y="0" width="1" height="15"/>
			</line>
			<line>
				<reportElement x="522" y="0" width="1" height="15"/>
			</line>
			<line>
				<reportElement x="563" y="0" width="1" height="15"/>
			</line>
			<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 isBlankWhenNull="true">
				<reportElement x="524" y="3" width="39" height="12">
					<printWhenExpression><![CDATA[new Boolean(false)]]></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="72" 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="179" y="2" width="299" 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>
			<line>
				<reportElement x="5" y="-1" width="559" height="1"/>
			</line>
			<textField isBlankWhenNull="true">
				<reportElement x="479" y="2" 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>
		</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="38" y="0" width="33" height="15" backcolor="#AD9CA4"/>
			</rectangle>
			<rectangle>
				<reportElement x="478" y="0" width="44" height="15" backcolor="#AD9CA4"/>
			</rectangle>
			<rectangle>
				<reportElement x="522" y="0" width="41" height="15" backcolor="#AD9CA4"/>
			</rectangle>
			<staticText>
				<reportElement x="378" y="3" width="100" height="12"/>
				<textElement>
					<font fontName="Arial" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[GRAND TOTAL]]></text>
			</staticText>
			<rectangle>
				<reportElement x="136" y="0" width="40" height="15" backcolor="#AD9CA4"/>
			</rectangle>
			<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="73" 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>
