modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped.jrxml
author Harpreet Singh <harpreet@openbravo.com>
Fri, 10 Dec 2010 19:47:45 +0100
changeset 9076 c4f1a5c7d7c2
child 22993 5e3c784a43d5
permissions -rw-r--r--
Added 3.0 modules to modules dir and changed the VERSION number
<?xml version="1.0" encoding="UTF-8"  ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
		 name="ReportOrderNotShipped"
		 columnCount="1"
		 printOrder="Vertical"
		 orientation="Portrait"
		 pageWidth="842"
		 pageHeight="595"
		 columnWidth="782"
		 columnSpacing="0"
		 leftMargin="30"
		 rightMargin="30"
		 topMargin="20"
		 bottomMargin="20"
		 whenNoDataType="NoPages"
		 isTitleNewPage="false"
		 isSummaryNewPage="false">
	<property name="ireport.scriptlethandling" value="0" />
	<property name="ireport.encoding" value="UTF-8" />
	<import value="java.util.*" />
	<import value="net.sf.jasperreports.engine.*" />
	<import value="net.sf.jasperreports.engine.data.*" />

	<style 
		name="default"
		isDefault="false"
		vAlign="Middle"
		fontName="Bitstream Vera Sans"
		fontSize="10"
	>
	</style>
	<style 
		name="Report_Title"
		isDefault="false"
		fontName="Bitstream Vera Sans"
		fontSize="18"
	>
					<box leftPadding="5"></box>
	</style>
	<style 
		name="Report_Subtitle"
		isDefault="false"
		forecolor="#555555"
		fontName="Bitstream Vera Sans"
		fontSize="14"
	>
					<box leftPadding="5"></box>
	</style>
	<style 
		name="Total_Field"
		isDefault="false"
		mode="Opaque"
		forecolor="#000000"
		backcolor="#CCCCCC"
		vAlign="Middle"
	>
					<box leftPadding="5"></box>
	</style>
	<style 
		name="Detail_Header"
		isDefault="false"
		mode="Opaque"
		forecolor="#FFFFFF"
		backcolor="#555555"
		vAlign="Middle"
	>
					<box leftPadding="5">					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
</box>
	</style>
	<style 
		name="GroupHeader_DarkGray"
		isDefault="false"
		mode="Opaque"
		forecolor="#FFFFFF"
		backcolor="#555555"
		vAlign="Middle"
		fontName="Bitstream Vera Sans"
		fontSize="14"
	>
					<box leftPadding="5"></box>
	</style>
	<style 
		name="GroupHeader_Gray"
		isDefault="false"
		mode="Opaque"
		backcolor="#999999"
	>
	</style>
	<style 
		name="Detail_Task"
		isDefault="false"
	>

		<conditionalStyle>
			<conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==1)]]></conditionExpression>
			<style 
				name="Detail_Task"
				isDefault="false"
				mode="Opaque"
				backcolor="#CCCCCC"
			>
			</style>
		</conditionalStyle>
	</style>
	<style 
		name="Total_Gray"
		isDefault="false"
		mode="Opaque"
		forecolor="#000000"
		backcolor="#CCCCCC"
	>
	</style>

	<parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String"/>
	<parameter name="REPORT_SUBTITLE" isForPrompting="false" class="java.lang.String"/>
	<queryString><![CDATA[SELECT ORG.NAME AS ORGNAME, BP.NAME AS BPNAME, 
O.DOCUMENTNO, O.POREFERENCE, TO_DATE(O.DATEORDERED) AS DATEORDERED, TO_DATE(O.DATEPROMISED) AS DATEPROMISED, 
REFLISTV.NAME AS DELIVERYRULE, COALESCE(DLOC.NAME, BPADD.NAME) AS DELIVERYLOCATION,
PR.NAME || ' ' || COALESCE(TO_CHAR(ASI.DESCRIPTION), '') AS PRODNAME, OL.M_ATTRIBUTESETINSTANCE_ID,
OL.QTYORDERED || ' ' || COALESCE(TO_CHAR(UO.UOMSYMBOL), '') AS ORDEREDQTY, 
(OL.QTYORDERED-OL.QTYDELIVERED) || ' ' || COALESCE(TO_CHAR(UO.UOMSYMBOL), '') AS PENDINGQTY, 
SUM(SD.QTYONHAND) || ' ' || COALESCE(TO_CHAR(UO.UOMSYMBOL), '') AS QTYINSTOCK
FROM AD_ORG ORG, C_BPARTNER BP, C_BPARTNER_LOCATION BPADD, 
M_PRODUCT PR, C_UOM UO, 
C_ORDER O
LEFT JOIN AD_REF_LIST_V REFLISTV
ON REFLISTV.VALUE = O.DELIVERYRULE
LEFT JOIN C_BPARTNER_LOCATION DLOC
ON DLOC.C_BPARTNER_LOCATION_ID = O.DELIVERY_LOCATION_ID,
C_ORDERLINE OL
LEFT JOIN M_ATTRIBUTESETINSTANCE ASI
ON OL.M_ATTRIBUTESETINSTANCE_ID = ASI.M_ATTRIBUTESETINSTANCE_ID
LEFT JOIN M_STORAGE_DETAIL SD
ON OL.M_PRODUCT_ID = SD.M_PRODUCT_ID
AND OL.C_UOM_ID = SD.C_UOM_ID
AND COALESCE(OL.M_ATTRIBUTESETINSTANCE_ID,'0') = COALESCE(SD.M_ATTRIBUTESETINSTANCE_ID,'0')
AND COALESCE(OL.M_PRODUCT_UOM_ID, '-1') = COALESCE(SD.M_PRODUCT_UOM_ID,'-1')
AND SD.M_LOCATOR_ID IN (SELECT LOC.M_LOCATOR_ID
FROM M_LOCATOR LOC
WHERE LOC.M_WAREHOUSE_ID = OL.M_WAREHOUSE_ID)
WHERE O.AD_ORG_ID = ORG.AD_ORG_ID
AND O.C_BPARTNER_ID = BP.C_BPARTNER_ID
AND O.C_BPARTNER_LOCATION_ID = BPADD.C_BPARTNER_LOCATION_ID
AND O.C_ORDER_ID = OL.C_ORDER_ID
AND O.DOCSTATUS IN ('CO','CL')
AND O.ISSOTRX = 'Y'
AND O.AD_CLIENT_ID IN ('1000000')
AND O.AD_ORG_ID IN ('1000000')
AND OL.M_PRODUCT_ID = PR.M_PRODUCT_ID
AND OL.C_UOM_ID = UO.C_UOM_ID
AND EXISTS (SELECT 1
FROM C_ORDER ORD, C_ORDERLINE ORDL
WHERE ORD.C_ORDER_ID = O.C_ORDER_ID
AND ORD.C_ORDER_ID = ORDL.C_ORDER_ID
AND ORDL.QTYORDERED <> ORDL.QTYDELIVERED)
AND REFLISTV.AD_REFERENCE_ID = '151'
AND REFLISTV.AD_LANGUAGE = 'en_US'
GROUP BY ORG.NAME, BP.NAME, O.DOCUMENTNO, O.POREFERENCE, O.DATEORDERED, O.DATEPROMISED,
REFLISTV.NAME, DLOC.NAME, BPADD.NAME, PR.NAME, ASI.DESCRIPTION, OL.M_ATTRIBUTESETINSTANCE_ID,
OL.QTYORDERED, UO.UOMSYMBOL, OL.QTYDELIVERED
ORDER BY ORGNAME, BPNAME, DOCUMENTNO]]></queryString>

	<field name="orgname" class="java.lang.String"/>
	<field name="bpname" class="java.lang.String"/>
	<field name="documentno" class="java.lang.String"/>
	<field name="poreference" class="java.lang.String"/>
	<field name="dateordered" class="java.util.Date"/>
	<field name="datepromised" class="java.util.Date"/>
	<field name="deliveryrule" class="java.lang.String"/>
	<field name="deliverylocation" class="java.lang.String"/>
	<field name="prodname" class="java.lang.String"/>
	<field name="m_attributesetinstance_id" class="java.lang.String"/>
	<field name="orderedqty" class="java.lang.String"/>
	<field name="pendingqty" class="java.lang.String"/>
	<field name="qtyinstock" class="java.lang.String"/>


		<group  name="orgname" >
			<groupExpression><![CDATA[$F{orgname}]]></groupExpression>
			<groupHeader>
			<band height="20"  isSplitAllowed="true" >
				<staticText>
					<reportElement
						style="GroupHeader_DarkGray"
						x="0"
						y="0"
						width="84"
						height="20"
						forecolor="#FFFFFF"
						key="staticText"/>
					<box leftPadding="5">					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Organization]]></text>
				</staticText>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="GroupHeader_DarkGray"
						x="84"
						y="0"
						width="698"
						height="20"
						forecolor="#FFFFFF"
						key="textField"/>
					<box leftPadding="5">					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10" isBold="true"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{orgname}]]></textFieldExpression>
				</textField>
			</band>
			</groupHeader>
			<groupFooter>
			<band height="10"  isSplitAllowed="true" >
				<line direction="TopDown">
					<reportElement
						x="0"
						y="9"
						width="782"
						height="1"
						forecolor="#555555"
						key="line-6"/>
					<graphicElement stretchType="NoStretch"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="0"
						y="0"
						width="0"
						height="10"
						forecolor="#555555"
						key="line-17"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="781"
						y="0"
						width="0"
						height="10"
						forecolor="#555555"
						key="line-20"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
			</band>
			</groupFooter>
		</group>
		<group  name="bpname" >
			<groupExpression><![CDATA[$F{bpname}]]></groupExpression>
			<groupHeader>
			<band height="40"  isSplitAllowed="true" >
				<staticText>
					<reportElement
						style="GroupHeader_DarkGray"
						x="20"
						y="10"
						width="105"
						height="20"
						forecolor="#FFFFFF"
						key="staticText"/>
					<box leftPadding="5">					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Business Partner]]></text>
				</staticText>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="GroupHeader_DarkGray"
						x="125"
						y="10"
						width="657"
						height="20"
						forecolor="#FFFFFF"
						key="textField"/>
					<box leftPadding="5">					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10" isBold="true"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{bpname}]]></textFieldExpression>
				</textField>
				<line direction="TopDown">
					<reportElement
						x="0"
						y="0"
						width="0"
						height="40"
						forecolor="#555555"
						key="line-3"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="20"
						y="30"
						width="0"
						height="10"
						forecolor="#555555"
						key="line-11"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="781"
						y="0"
						width="0"
						height="10"
						forecolor="#555555"
						key="line-14"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="781"
						y="30"
						width="0"
						height="10"
						forecolor="#555555"
						key="line-28"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
			</band>
			</groupHeader>
			<groupFooter>
			<band height="10"  isSplitAllowed="true" >
				<line direction="TopDown">
					<reportElement
						x="0"
						y="0"
						width="0"
						height="10"
						forecolor="#555555"
						key="line-16"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="781"
						y="0"
						width="0"
						height="10"
						forecolor="#555555"
						key="line-19"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="20"
						y="9"
						width="762"
						height="1"
						forecolor="#555555"
						key="line-21"/>
					<graphicElement stretchType="NoStretch"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="20"
						y="0"
						width="0"
						height="10"
						forecolor="#555555"
						key="line-23"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
			</band>
			</groupFooter>
		</group>
		<group  name="documentno" >
			<groupExpression><![CDATA[$F{documentno}]]></groupExpression>
			<groupHeader>
			<band height="60"  isSplitAllowed="true" >
				<staticText>
					<reportElement
						style="GroupHeader_DarkGray"
						x="39"
						y="0"
						width="159"
						height="20"
						forecolor="#FFFFFF"
						key="staticText"/>
					<box>					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Order Document No.]]></text>
				</staticText>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						x="41"
						y="20"
						width="157"
						height="20"
						forecolor="#000000"
						key="textField"/>
					<box>					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{documentno}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						x="198"
						y="20"
						width="85"
						height="20"
						forecolor="#000000"
						key="textField"/>
					<box>					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10"/>
					</textElement>
				<textFieldExpression   class="java.util.Date"><![CDATA[$F{dateordered}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement
						style="GroupHeader_DarkGray"
						x="198"
						y="0"
						width="85"
						height="20"
						forecolor="#FFFFFF"
						key="staticText"/>
					<box>					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Order Date]]></text>
				</staticText>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						x="283"
						y="20"
						width="93"
						height="20"
						forecolor="#000000"
						key="textField"/>
					<box>					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10"/>
					</textElement>
				<textFieldExpression   class="java.util.Date"><![CDATA[$F{datepromised}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement
						style="GroupHeader_DarkGray"
						x="283"
						y="0"
						width="94"
						height="20"
						forecolor="#FFFFFF"
						key="staticText"/>
					<box>					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Delivery Date]]></text>
				</staticText>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						x="376"
						y="20"
						width="120"
						height="20"
						forecolor="#000000"
						key="textField"/>
					<box>					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{deliveryrule}!=null)?$F{deliveryrule}:new String(" ")]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement
						style="GroupHeader_DarkGray"
						x="377"
						y="0"
						width="119"
						height="20"
						forecolor="#FFFFFF"
						key="staticText"/>
					<box>					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Delivery Terms]]></text>
				</staticText>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						x="496"
						y="20"
						width="283"
						height="20"
						forecolor="#000000"
						key="textField"/>
					<box leftPadding="5">					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{deliverylocation}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement
						style="GroupHeader_DarkGray"
						x="496"
						y="0"
						width="286"
						height="20"
						forecolor="#FFFFFF"
						key="staticText"/>
					<box leftPadding="5">					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Delivery Location]]></text>
				</staticText>
				<staticText>
					<reportElement
						style="GroupHeader_DarkGray"
						x="62"
						y="40"
						width="214"
						height="20"
						forecolor="#FFFFFF"
						key="staticText"/>
					<box leftPadding="5">					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" pdfFontName="Helvetica-Bold" size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Product]]></text>
				</staticText>
				<staticText>
					<reportElement
						style="GroupHeader_DarkGray"
						x="276"
						y="40"
						width="161"
						height="20"
						forecolor="#FFFFFF"
						key="staticText"/>
					<box>					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Ordered Quantity]]></text>
				</staticText>
				<staticText>
					<reportElement
						style="GroupHeader_DarkGray"
						x="437"
						y="40"
						width="151"
						height="20"
						forecolor="#FFFFFF"
						key="staticText"/>
					<box>					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Pending Quantity]]></text>
				</staticText>
				<staticText>
					<reportElement
						style="GroupHeader_DarkGray"
						x="588"
						y="40"
						width="194"
						height="20"
						forecolor="#FFFFFF"
						key="staticText"/>
					<box>					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10" isBold="true"/>
					</textElement>
				<text><![CDATA[Quantity in Stock]]></text>
				</staticText>
				<line direction="TopDown">
					<reportElement
						x="0"
						y="0"
						width="0"
						height="60"
						forecolor="#555555"
						key="line-4"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="39"
						y="20"
						width="0"
						height="40"
						forecolor="#555555"
						key="line-7"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="20"
						y="0"
						width="0"
						height="60"
						forecolor="#555555"
						key="line-10"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="781"
						y="20"
						width="0"
						height="20"
						forecolor="#555555"
						key="line-13"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
			</band>
			</groupHeader>
			<groupFooter>
			<band height="10"  isSplitAllowed="true" >
				<line direction="TopDown">
					<reportElement
						x="0"
						y="0"
						width="0"
						height="10"
						forecolor="#555555"
						key="line-15"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="781"
						y="0"
						width="0"
						height="10"
						forecolor="#555555"
						key="line-18"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="20"
						y="0"
						width="0"
						height="10"
						forecolor="#555555"
						key="line-22"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="39"
						y="0"
						width="0"
						height="10"
						forecolor="#555555"
						key="line-24"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="39"
						y="9"
						width="742"
						height="1"
						forecolor="#555555"
						key="line-25"/>
					<graphicElement stretchType="NoStretch"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="60"
						y="0"
						width="722"
						height="1"
						forecolor="#555555"
						key="line-27"/>
					<graphicElement stretchType="NoStretch"/>
				</line>
			</band>
			</groupFooter>
		</group>
		<background>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</background>
		<title>
			<band height="56"  isSplitAllowed="true" >
				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="Report_Title"
						x="0"
						y="0"
						width="782"
						height="26"
						key="textField-2"/>
					<box leftPadding="5">					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Left">
						<font/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$P{REPORT_TITLE}]]></textFieldExpression>
				</textField>
				<line direction="TopDown">
					<reportElement
						x="0"
						y="26"
						width="782"
						height="0"
						key="line-2"/>
					<graphicElement stretchType="NoStretch"/>
				</line>
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="Report_Subtitle"
						x="0"
						y="31"
						width="782"
						height="18"
						key="textField-3"/>
					<box leftPadding="5">					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Left">
						<font/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$P{REPORT_SUBTITLE}]]></textFieldExpression>
				</textField>
				<line direction="TopDown">
					<reportElement
						x="0"
						y="49"
						width="782"
						height="0"
						key="line-1"/>
					<graphicElement stretchType="NoStretch"/>
				</line>
			</band>
		</title>
		<pageHeader>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</pageHeader>
		<columnHeader>
			<band height="2"  isSplitAllowed="true" >
			</band>
		</columnHeader>
		<detail>
			<band height="20"  isSplitAllowed="true" >
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="Detail_Task"
						x="62"
						y="0"
						width="214"
						height="20"
						forecolor="#000000"
						key="textField"/>
					<box leftPadding="5">					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{prodname}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="Detail_Task"
						x="276"
						y="0"
						width="161"
						height="20"
						forecolor="#000000"
						key="textField"/>
					<box rightPadding="5">					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{orderedqty}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="Detail_Task"
						x="437"
						y="0"
						width="151"
						height="20"
						forecolor="#000000"
						key="textField"/>
					<box rightPadding="5">					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{pendingqty}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						style="Detail_Task"
						x="588"
						y="0"
						width="192"
						height="20"
						forecolor="#000000"
						key="textField"/>
					<box rightPadding="5">					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="10"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{qtyinstock}!=null)?$F{qtyinstock}:new String(" ")]]></textFieldExpression>
				</textField>
				<line direction="TopDown">
					<reportElement
						x="0"
						y="-2"
						width="0"
						height="22"
						forecolor="#555555"
						key="line-5"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="39"
						y="0"
						width="0"
						height="20"
						forecolor="#555555"
						key="line-8"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="60"
						y="-20"
						width="0"
						height="40"
						forecolor="#555555"
						key="line-9"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="20"
						y="-2"
						width="0"
						height="22"
						forecolor="#555555"
						key="line-12"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
				<line direction="TopDown">
					<reportElement
						x="781"
						y="0"
						width="0"
						height="20"
						forecolor="#555555"
						key="line-26"
						stretchType="RelativeToBandHeight"/>
					<graphicElement stretchType="RelativeToBandHeight"/>
				</line>
			</band>
		</detail>
		<columnFooter>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</columnFooter>
		<pageFooter>
			<band height="20"  isSplitAllowed="true" >
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						x="573"
						y="5"
						width="171"
						height="15"
						forecolor="#000000"
						key="textField-4"/>
					<box>					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Right" verticalAlignment="Bottom">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						mode="Transparent"
						x="746"
						y="5"
						width="36"
						height="15"
						forecolor="#000000"
						backcolor="#FFFFFF"
						key="textField-5"/>
					<box>					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Left" verticalAlignment="Bottom">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement
						x="364"
						y="5"
						width="87"
						height="15"
						forecolor="#000000"
						key="textField-6"/>
					<box>					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Left" verticalAlignment="Bottom">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
				<textFieldExpression   class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement
						x="284"
						y="5"
						width="78"
						height="15"
						forecolor="#000000"
						key="staticText-1"/>
					<box topPadding="2">					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
					<textElement textAlignment="Right" verticalAlignment="Bottom">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
				<text><![CDATA[Generated on]]></text>
				</staticText>
			</band>
		</pageFooter>
		<summary>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</summary>
</jasperReport>