<?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="haz_mat_form_sub2" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="792" leftMargin="0" rightMargin="0" topMargin="10" bottomMargin="10">
	<property name="com.jasperassistant.designer.GridHeight" value="12"/>
	<property name="com.jasperassistant.designer.GridWidth" value="12"/>
	<property name="com.jasperassistant.designer.HGuides" value="0"/>
	<property name="com.jasperassistant.designer.DataSource" value="genral_ledger"/>
	<property name="com.jasperassistant.designer.SnapToGrid" value="false"/>
	<property name="com.jasperassistant.designer.Units" value="Inches"/>
	<property name="com.jasperassistant.designer.Grid" value="false"/>
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="371"/>
	<property name="ireport.y" value="0"/>
	<reportFont name="Report_Font" isDefault="false" fontName="Courier New" size="9" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
	<parameter name="GROSS" class="java.lang.Double"/>
	<parameter name="DATE" class="java.util.Date"/>
	<parameter name="TRACK_NO" class="java.lang.String"/>
	<parameter name="SHIP" class="java.lang.String">
		<parameterDescription><![CDATA[]]></parameterDescription>
	</parameter>
	<parameter name="CONSIGNEE" class="java.lang.String"/>
	<queryString>
		<![CDATA[SELECT
DDF_GET_DISPARM_VALUE('ACCOUNT_NUMBER','999999') AS ACCOUNT_NO,
DDF_GET_DISPARM_VALUE('EMG_CONTACT_NUMBER','999999') AS CONTACT_NO,
'' AS REF_NO,
DDF_GET_DISPARM_VALUE('HAZ_MAT_DESC','999999') AS HAZ_MAT_DESC,
DDF_GET_DISPARM_VALUE('HAZ_MAT_CLASS','999999') AS HAZ_MAT_CLASS,
DDF_GET_DISPARM_VALUE('HAZ_MAT_QTY','999999') AS HAZ_MAT_QTY,
'BOX x,' AS BOX,
'' AS GROSS_WT,
DDF_GET_DISPARM_VALUE('SIGNATURE_NAME','999999') AS SIGNATURE,
'' AS SHIP_DATE,
'Air' AS TRANSPORT,
'150' AS REFERENCE_NO
FROM
DUAL]]>
	</queryString>
	<field name="ACCOUNT_NO" class="java.lang.String"/>
	<field name="CONTACT_NO" class="java.lang.String"/>
	<field name="REF_NO" class="java.lang.String"/>
	<field name="HAZ_MAT_QTY" class="java.lang.String"/>
	<field name="GROSS_WT" class="java.lang.Double"/>
	<field name="SHIP_DATE" class="java.util.Date"/>
	<field name="HAZ_MAT_CLASS" class="java.lang.String"/>
	<field name="HAZ_MAT_DESC" class="java.lang.String"/>
	<field name="REFERENCE_NO" class="java.lang.String"/>
	<field name="TRANSPORT" class="java.lang.String"/>
	<variable name="varPage01" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[new java.lang.String("Page " + ($V{PAGE_NUMBER}).intValue())]]></variableExpression>
	</variable>
	<variable name="varPgCount02" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[new java.lang.String(""+ " of " + ($V{PAGE_NUMBER}).intValue())]]></variableExpression>
	</variable>
	<variable name="variable1" class="java.lang.String">
		<variableExpression><![CDATA[new java.lang.String("N/A Ltd Qty  :  "+$P{GROSS}.doubleValue()+" KG")]]></variableExpression>
	</variable>
	<variable name="variable2" class="java.lang.String">
		<variableExpression><![CDATA[new java.lang.String("Emergency number  :  "+$F{CONTACT_NO})]]></variableExpression>
	</variable>
	<variable name="variable3" class="java.lang.String">
		<variableExpression><![CDATA[$P{SHIP}]]></variableExpression>
	</variable>
	<pageHeader>
		<band height="183" splitType="Stretch">
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="25" y="125" width="742" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[------------------------------------------------------------------------------------------------------------------------------------]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="25" y="167" width="745" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[------------------------------------------------------------------------------------------------------------------------------------]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="25" y="149" width="203" height="15">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left" verticalAlignment="Bottom">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[Proper Name/Technical Description]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="251" y="149" width="37" height="15">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left" verticalAlignment="Bottom">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[Class]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="342" y="140" width="18" height="24">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[UN
ID]]></text>
			</staticText>
			<textField evaluationTime="Page" pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="646" y="111" width="64" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="Courier New" size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{varPage01}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="710" y="111" width="49" height="13"/>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{varPgCount02}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="25" y="111" width="83" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[Date Shipped: ]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="25" y="0" width="734" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[UPS Shipping Manifest]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="535" y="149" width="69" height="15">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[Transport]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="630" y="140" width="137" height="24">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[Tracking
Number]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="25" y="13" width="734" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[Shipper's Certification for Hazardous Material]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="25" y="27" width="125" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10" isBold="false" isUnderline="true"/>
				</textElement>
				<text><![CDATA[Shipper Information]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="572" y="27" width="97" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[Shipper Number : ]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="572" y="40" width="112" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[Reference Number : ]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="303" y="140" width="26" height="15">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left" verticalAlignment="Bottom">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[Sub]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="371" y="140" width="21" height="24">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[Pck
Grp]]></text>
			</staticText>
			<textField pattern="MM/dd/yy" isBlankWhenNull="true">
				<reportElement positionType="Float" x="110" y="111" width="63" height="13"/>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$P{DATE}]]></textFieldExpression>
			</textField>
			<textField pattern="0.000" isBlankWhenNull="true">
				<reportElement positionType="Float" x="668" y="26" width="91" height="13"/>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ACCOUNT_NO}]]></textFieldExpression>
			</textField>
			<textField pattern="0" isBlankWhenNull="true">
				<reportElement positionType="Float" x="686" y="39" width="49" height="13"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New" size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{REFERENCE_NO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="45" y="43" width="258" height="68"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{SHIP}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<detail>
		<band height="105" splitType="Stretch">
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement positionType="Float" x="25" y="0" width="203" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{HAZ_MAT_DESC}]]></textFieldExpression>
			</textField>
			<textField pattern="0.000" isBlankWhenNull="true">
				<reportElement positionType="Float" x="535" y="0" width="69" height="13"/>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TRANSPORT}]]></textFieldExpression>
			</textField>
			<textField pattern="0.000" isBlankWhenNull="true">
				<reportElement positionType="Float" x="251" y="0" width="52" height="13"/>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{HAZ_MAT_CLASS}]]></textFieldExpression>
			</textField>
			<textField pattern="0.000" isBlankWhenNull="true">
				<reportElement positionType="Float" x="630" y="0" width="140" height="13"/>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{TRACK_NO}]]></textFieldExpression>
			</textField>
			<textField pattern="0.000" isBlankWhenNull="true">
				<reportElement positionType="Float" x="371" y="0" width="164" height="13"/>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{variable1}]]></textFieldExpression>
			</textField>
			<textField pattern="0.000" isBlankWhenNull="true">
				<reportElement positionType="Float" x="45" y="14" width="258" height="13"/>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{variable2}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="57" y="47" width="74" height="15">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left" verticalAlignment="Bottom">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[Consignee  :]]></text>
			</staticText>
			<textField>
				<reportElement positionType="Float" x="131" y="50" width="258" height="55"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{CONSIGNEE}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="140">
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="25" y="18" width="755" height="25">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[This is to Certify that the above-named materials are properly classified, described, packaged, marked and are in proper condition for transportation according to the applicable regulations of the Department of Transportation.]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="25" y="5" width="745" height="13">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[------------------------------------------------------------------------------------------------------------------------------------]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="25" y="102" width="113" height="15">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left" verticalAlignment="Bottom">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[Shipper Signature]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" mode="Transparent" x="366" y="102" width="29" height="15">
					<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left" verticalAlignment="Bottom">
					<font fontName="Courier New" size="10" isBold="false"/>
				</textElement>
				<text><![CDATA[Date]]></text>
			</staticText>
			<line>
				<reportElement x="131" y="118" width="226" height="1"/>
			</line>
			<line>
				<reportElement x="395" y="118" width="150" height="1"/>
			</line>
		</band>
	</summary>
</jasperReport>
