src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceJR.jrxml
author Armaignac <collazoandy4@gmail.com>
Thu, 05 Dec 2019 16:02:05 -0500
changeset 36865 15ea261d93f9
parent 26741 d2bbde0c3d66
permissions -rw-r--r--
Fixes BUG-42426: Financial account window performance for LASTRECON and
APRM_LASTREC auxiliary inputs

The perfomance for LASTRECON and APRM_LASTREC auxiliary inputs is bad with high
volume of records in fin_reconciliation window because a sequence scan is made
while filtering by created

A new Index for created and fin_financial_account_id columns was created in
fin_reconciliation table
<?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="ReportOrderNotInvoiceJR" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="782" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" uuid="4e35e7d6-9d9f-424c-aa14-e29210dbe636">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<import value="net.sf.jasperreports.engine.*"/>
	<import value="java.util.*"/>
	<import value="net.sf.jasperreports.engine.data.*"/>
	<style name="default" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="10"/>
	<style name="Report_Title" fontName="Bitstream Vera Sans" fontSize="18">
		<box leftPadding="5"/>
	</style>
	<style name="Report_Subtitle" forecolor="#555555" fontName="Bitstream Vera Sans" fontSize="14">
		<box leftPadding="5"/>
	</style>
	<style name="Report_Data_Label" fontName="Bitstream Vera Sans" fontSize="11" isBold="true"/>
	<style name="Report_Data_Field" fontName="Bitstream Vera Sans" fontSize="11" isBold="false"/>
	<style name="Total_Field" mode="Opaque" forecolor="#000000" backcolor="#CCCCCC" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="11" isBold="true">
		<box leftPadding="5"/>
	</style>
	<style name="GroupHeader_DarkGray" mode="Opaque" forecolor="#FFFFFF" backcolor="#555555" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="12" isBold="true">
		<box leftPadding="5"/>
	</style>
	<style name="Group_Data_Label" fontName="Bitstream Vera Sans" fontSize="11" isBold="true"/>
	<style name="Group_Data_Field" fontName="Bitstream Vera Sans" fontSize="11"/>
	<style name="Detail_Header" mode="Opaque" forecolor="#FFFFFF" backcolor="#5D5D5D" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="10" isBold="true">
		<box leftPadding="5">
			<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
			<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
		</box>
	</style>
	<style name="Detail_Line" fontName="Bitstream Vera Sans" fontSize="10">
		<conditionalStyle>
			<conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression>
			<style mode="Opaque" backcolor="#CCCCCC"/>
		</conditionalStyle>
	</style>
	<style name="Total_Gray" mode="Opaque" forecolor="#000000" backcolor="#CCCCCC"/>
	<style name="Detail_Data_Label" mode="Opaque" backcolor="#CCCCCC" fontName="Bitstream Vera Sans" fontSize="10" isBold="true"/>
	<style name="Detail_Data_Field" mode="Opaque" backcolor="#CCCCCC" fontName="Bitstream Vera Sans" fontSize="10"/>
	<style name="Group_Footer" fontName="Bitstream Vera Sans" fontSize="11" isBold="true"/>
	<style name="Report_Footer" isDefault="true" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="11"/>
	<parameter name="ATTACH" class="java.lang.String" isForPrompting="false"/>
	<parameter name="BASE_WEB" class="java.lang.String" isForPrompting="false"/>
	<parameter name="BASE_DESIGN" class="java.lang.String" isForPrompting="false"/>
	<parameter name="LANGUAGE" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["en_US"]]></defaultValueExpression>
	</parameter>
	<parameter name="USER_CLIENT" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["(1000000)"]]></defaultValueExpression>
	</parameter>
	<parameter name="USER_ORG" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["(0)"]]></defaultValueExpression>
	</parameter>
	<parameter name="REPORT_TITLE" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["REPORT TITLE"]]></defaultValueExpression>
	</parameter>
	<parameter name="REPORT_SUBTITLE" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="ReportData" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="DECIMAL_FORMAT" class="java.text.DecimalFormat" isForPrompting="false">
		<defaultValueExpression><![CDATA[new DecimalFormat()]]></defaultValueExpression>
	</parameter>
	<parameter name="NUMBERFORMAT" class="java.text.DecimalFormat" isForPrompting="false"/>
	<parameter name="LOCALE" class="java.util.Locale" isForPrompting="false"/>
	<queryString>
		<![CDATA[SELECT ORGNAME, C_BPARTNER_ID, BPARTNERNAME, C_ORDER_ID, DOCUMENTNO, DATEORDERED, GRANDTOTAL, ISO_CODE, INVOICERULE,
      LINE, PRODUCT, PRICE, QTYORDERED, UOMSYMBOL, TAX, TAXBASE, LINENETAMT
      FROM (
      SELECT AD_ORG.NAME AS ORGNAME, C_BPARTNER.C_BPARTNER_ID, C_BPARTNER.NAME AS BPARTNERNAME, C_ORDER.C_ORDER_ID, C_ORDER.DOCUMENTNO,
      C_ORDER.DATEORDERED, C_ORDER.GRANDTOTAL, C_CURRENCY.ISO_CODE, (CASE C_ORDER.INVOICERULE WHEN 'S' THEN COALESCE(AD_REF_LIST_TRL.NAME, AD_REF_LIST.NAME)||' ('||C_INVOICESCHEDULE.NAME||')' ELSE COALESCE(AD_REF_LIST_TRL.NAME, AD_REF_LIST.NAME) END) AS INVOICERULE,
      C_ORDERLINE.LINE AS LINE, COALESCE(M_PRODUCT.NAME, M_PRODUCT.DESCRIPTION) AS PRODUCT, C_ORDERLINE.PRICEACTUAL AS PRICE,
      C_ORDERLINE.QTYORDERED, C_UOM.UOMSYMBOL, NULL AS TAX, NULL AS TAXBASE, C_ORDERLINE.LINENETAMT
      FROM C_BPARTNER left join C_INVOICESCHEDULE on C_BPARTNER.C_INVOICESCHEDULE_ID = C_INVOICESCHEDULE.C_INVOICESCHEDULE_ID,
           AD_REF_LIST left join AD_REF_LIST_TRL  on AD_REF_LIST.AD_REF_LIST_ID = AD_REF_LIST_TRL.AD_REF_LIST_ID
                                                     and AD_REF_LIST_TRL.AD_LANGUAGE = 'es_ES',
           C_ORDERLINE left join M_PRODUCT on C_ORDERLINE.M_PRODUCT_ID=M_PRODUCT.M_PRODUCT_ID,
           C_ORDER, AD_ORG, C_UOM, C_CURRENCY
      WHERE C_ORDER.C_ORDER_ID=C_ORDERLINE.C_ORDER_ID
      AND C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
      AND C_ORDER.INVOICERULE = AD_REF_LIST.VALUE
      AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID
      AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID
      AND C_ORDER.C_CURRENCY_ID = C_CURRENCY.C_CURRENCY_ID
      AND AD_REF_LIST.AD_REFERENCE_ID = 150
      AND C_ORDER.PROCESSED = 'Y'
      AND C_ORDER.ISSOTRX = 'Y'
      AND C_ORDERLINE.QTYORDERED<>C_ORDERLINE.QTYINVOICED
      AND 1=1
      UNION ALL
      SELECT AD_ORG.NAME AS ORGNAME, C_BPARTNER.C_BPARTNER_ID, C_BPARTNER.NAME AS BPARTNERNAME, C.C_ORDER_ID, C.DOCUMENTNO,
      C.DATEORDERED, C.GRANDTOTAL, C_CURRENCY.ISO_CODE AS ISO_CODE, (CASE C.INVOICERULE WHEN 'S' THEN COALESCE(AD_REF_LIST_TRL.NAME, AD_REF_LIST.NAME)||' ('||C_INVOICESCHEDULE.NAME||')' ELSE COALESCE(AD_REF_LIST_TRL.NAME, AD_REF_LIST.NAME) END) AS INVOICERULE,
      NULL AS LINE , C_TAX.NAME AS PRODUCT, NULL AS PRICE,
      NULL AS QTYORDERED, NULL AS UOMSYMBOL, C_TAX.RATE AS TAX, C_ORDERTAX.TAXBASEAMT AS TAXBASE, C_ORDERTAX.TAXAMT AS LINENETAMT
      FROM C_BPARTNER left join C_INVOICESCHEDULE on C_BPARTNER.C_INVOICESCHEDULE_ID = C_INVOICESCHEDULE.C_INVOICESCHEDULE_ID,
           AD_REF_LIST left join AD_REF_LIST_TRL on AD_REF_LIST.AD_REF_LIST_ID = AD_REF_LIST_TRL.AD_REF_LIST_ID
                                                 AND AD_REF_LIST_TRL.AD_LANGUAGE = 'es_ES' ,
      C_ORDER C ,C_ORDERTAX, AD_ORG,  C_TAX, C_CURRENCY
      WHERE C.C_ORDER_ID=C_ORDERTAX.C_ORDER_ID
      AND C.C_BPARTNER_ID=C_BPARTNER.C_BPARTNER_ID
      AND C.C_CURRENCY_ID = C_CURRENCY.C_CURRENCY_ID
      AND C.INVOICERULE = AD_REF_LIST.VALUE
      AND AD_REF_LIST.AD_REFERENCE_ID = 150
      AND C_ORDERTAX.C_TAX_ID = C_TAX.C_TAX_ID
      AND C.AD_ORG_ID = AD_ORG.AD_ORG_ID
      AND C.PROCESSED = 'Y'
      AND C.ISSOTRX = 'Y'
      AND EXISTS (SELECT 1 FROM C_ORDER C2, C_ORDERLINE CL
                 WHERE C2.c_order_id = C.c_order_id
                 and c2.c_order_id=cl.c_order_id
                 and cl.QTYORDERED<>cl.QTYINVOICED)
      ) AAA
      ORDER BY ORGNAME, BPARTNERNAME, DATEORDERED DESC, DOCUMENTNO, LINE]]>
	</queryString>
	<field name="ORGNAME" class="java.lang.String"/>
	<field name="C_BPARTNER_ID" class="java.lang.String"/>
	<field name="BPARTNERNAME" class="java.lang.String"/>
	<field name="C_ORDER_ID" class="java.lang.String"/>
	<field name="DOCUMENTNO" class="java.lang.String"/>
	<field name="DATEORDERED" class="java.util.Date"/>
	<field name="GRANDTOTAL" class="java.math.BigDecimal"/>
	<field name="INVOICERULE" class="java.lang.String"/>
	<field name="LINE" class="java.math.BigDecimal"/>
	<field name="PRODUCT" class="java.lang.String"/>
	<field name="PRICE" class="java.math.BigDecimal"/>
	<field name="QTYORDERED" class="java.math.BigDecimal"/>
	<field name="UOMSYMBOL" class="java.lang.String"/>
	<field name="TAX" class="java.math.BigDecimal"/>
	<field name="TAXBASE" class="java.math.BigDecimal"/>
	<field name="LINENETAMT" class="java.math.BigDecimal"/>
	<field name="CONVGRANDTOTAL" class="java.math.BigDecimal"/>
	<field name="CONVPRICE" class="java.math.BigDecimal"/>
	<field name="CONVTAXBASE" class="java.math.BigDecimal"/>
	<field name="CONVLINENETAMT" class="java.math.BigDecimal"/>
	<field name="ORDERCURRENCYSYM" class="java.lang.String"/>
	<field name="LINECURRENCYSYM" class="java.lang.String"/>
	<field name="CONVSYM" class="java.lang.String"/>
	<field name="CONVISOSYM" class="java.lang.String"/>
	<variable name="DetailFieldTotal" class="java.lang.String"/>
	<group name="ORGNAME">
		<groupExpression><![CDATA[$F{ORGNAME}]]></groupExpression>
		<groupHeader>
			<band height="32" splitType="Stretch">
				<staticText>
					<reportElement key="staticText" style="GroupHeader_DarkGray" x="0" y="0" width="120" height="18" uuid="ac212499-92d2-40cd-b15b-1399f01396eb"/>
					<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>
					<text><![CDATA[ORGANIZATION]]></text>
				</staticText>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement key="textField" style="GroupHeader_DarkGray" x="120" y="0" width="661" height="18" uuid="c9d40e63-2800-4db9-b4ee-931795498638"/>
					<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>
					<textFieldExpression><![CDATA[$F{ORGNAME}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement key="line-2" stretchType="RelativeToBandHeight" x="0" y="18" width="1" height="14" forecolor="#555555" uuid="a485b89d-e7b1-44ba-9c16-08a67c1cdce2"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-3" stretchType="RelativeToBandHeight" x="781" y="0" width="1" height="32" forecolor="#555555" uuid="6f7a2b41-c331-4d6f-8c50-e2a73852de4a"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="20" splitType="Stretch">
				<line>
					<reportElement key="line-32" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="14" forecolor="#555555" uuid="b8f804c3-16e2-4e9f-aacc-936419be1a01"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-33" stretchType="RelativeToBandHeight" x="781" y="0" width="1" height="14" forecolor="#555555" uuid="1d73a091-ec32-401c-a279-94e485848da7"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-34" x="0" y="14" width="782" height="1" forecolor="#555555" uuid="49e16712-94d7-4349-bcaa-97c6640816f9"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
			</band>
		</groupFooter>
	</group>
	<group name="C_BPARTNER_ID">
		<groupExpression><![CDATA[$F{C_BPARTNER_ID}]]></groupExpression>
		<groupHeader>
			<band height="32" splitType="Stretch">
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement key="textField" style="GroupHeader_DarkGray" x="130" y="0" width="650" height="18" uuid="61ba6636-3ab2-4969-a45a-35eca98d40d4"/>
					<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>
					<textFieldExpression><![CDATA[$F{BPARTNERNAME}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement key="line-4" stretchType="RelativeToBandHeight" x="10" y="18" width="1" height="14" forecolor="#555555" uuid="e1ebc250-2b84-4532-a535-d221cb99bab8"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-6" stretchType="RelativeToBandHeight" x="781" y="0" width="1" height="32" forecolor="#555555" uuid="fbcb45c3-165a-447d-8852-257a63f482c6"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-8" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="32" forecolor="#555555" uuid="c2cdd55c-f216-413f-bc0c-d46279084fd2"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<staticText>
					<reportElement key="staticText-9" style="GroupHeader_DarkGray" x="10" y="0" width="120" height="18" uuid="93dadb6f-40e6-49ef-a5de-24e4f4898014"/>
					<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>
					<text><![CDATA[PARTNER NAME]]></text>
				</staticText>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="20" splitType="Stretch">
				<line>
					<reportElement key="line-28" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="20" forecolor="#555555" uuid="28f46118-3f5b-494a-8d8c-0e5bfa4bee5a"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-29" stretchType="RelativeToBandHeight" x="10" y="0" width="1" height="10" forecolor="#555555" uuid="4844b6e3-efd3-401a-a104-9acc4900e3cb"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-30" stretchType="RelativeToBandHeight" x="781" y="0" width="1" height="20" forecolor="#555555" uuid="3f7a51f6-7343-4370-8180-10a05ad71b88"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-31" x="10" y="10" width="771" height="1" forecolor="#555555" uuid="bb942be9-6338-4b7b-83d4-d02cdf6f8581"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
			</band>
		</groupFooter>
	</group>
	<group name="C_ORDER_ID">
		<groupExpression><![CDATA[$F{C_ORDER_ID}]]></groupExpression>
		<groupHeader>
			<band height="62" splitType="Stretch">
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement key="textField" style="default" stretchType="RelativeToTallestObject" x="20" y="18" width="80" height="18" uuid="be6828f1-de5f-468f-994e-5ec39c1b1703"/>
					<box topPadding="2" leftPadding="5">
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
						<bottomPen lineWidth="0.0" lineColor="#555555"/>
						<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement verticalAlignment="Middle"/>
					<textFieldExpression><![CDATA[$F{DOCUMENTNO}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement key="line-7" stretchType="RelativeToBandHeight" x="781" y="0" width="1" height="62" forecolor="#555555" uuid="e6da47aa-fdf3-4779-b622-c738ed4b743d"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-9" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="62" forecolor="#555555" uuid="70f74567-79a6-468f-b91c-e1de6278471b"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-10" stretchType="RelativeToBandHeight" x="10" y="0" width="1" height="62" forecolor="#555555" uuid="af66a298-133f-46c2-9829-5ed31cc416cf"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<staticText>
					<reportElement key="staticText-10" style="GroupHeader_DarkGray" x="20" y="0" width="80" height="18" uuid="1e3d453a-ffeb-4e09-8466-18c86019e6d8"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement verticalAlignment="Middle"/>
					<text><![CDATA[ORDER]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-11" style="GroupHeader_DarkGray" x="100" y="0" width="100" height="18" uuid="8aa91861-d8b5-4aea-806c-0d0d8c50d383"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle"/>
					<text><![CDATA[ORDER DATE]]></text>
				</staticText>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement key="textField-4" style="default" x="100" y="18" width="100" height="18" uuid="6a511f90-0860-4e59-b6d7-f191da4ea541"/>
					<box topPadding="2" leftPadding="5">
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
						<bottomPen lineWidth="0.0" lineColor="#555555"/>
						<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle"/>
					<textFieldExpression><![CDATA[$F{DATEORDERED}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement key="staticText-12" style="GroupHeader_DarkGray" x="200" y="0" width="165" height="18" uuid="a5646efe-9a1b-49cf-86a2-3bf77ee09928"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[AMOUNT]]></text>
				</staticText>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField-5" style="default" x="200" y="18" width="137" height="18" uuid="19de6b39-1767-49af-b274-8d72b2fafd40"/>
					<box topPadding="2" leftPadding="5" rightPadding="4">
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
						<bottomPen lineWidth="0.0" lineColor="#555555"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle"/>
					<textFieldExpression><![CDATA[($F{GRANDTOTAL}!=null)?$P{NUMBERFORMAT}.format($F{GRANDTOTAL}):new String(" ")]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement key="staticText-14" style="GroupHeader_DarkGray" x="530" y="0" width="250" height="18" uuid="64ee2c26-7ac7-40c1-9645-18a5244603bb"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[TYPE]]></text>
				</staticText>
				<textField pattern="#,##0.00" isBlankWhenNull="true">
					<reportElement key="textField-7" style="default" x="530" y="18" width="250" height="18" uuid="4513dca8-eda4-4891-a47d-c669a305f86d"/>
					<box topPadding="2" leftPadding="5" rightPadding="4">
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
						<bottomPen lineWidth="0.0" lineColor="#555555"/>
						<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#666666"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle"/>
					<textFieldExpression><![CDATA[$F{INVOICERULE}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement key="line-35" stretchType="RelativeToBandHeight" x="20" y="36" width="1" height="26" forecolor="#555555" uuid="f54f67ae-544c-4d41-9e3e-aaa2d6a740b8"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<staticText>
					<reportElement key="staticText-16" style="GroupHeader_DarkGray" x="30" y="46" width="140" height="16" uuid="db2d66be-217b-4642-a9a8-e853b7e72471"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Concept]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-17" style="GroupHeader_DarkGray" x="170" y="46" width="66" height="16" uuid="81ea0331-d456-4349-86db-7ba8c3613847"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Quantity]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-18" style="GroupHeader_DarkGray" x="236" y="46" width="39" height="16" uuid="28bad640-f4f2-4829-923e-4fbe919abc92"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[UOM]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-19" style="GroupHeader_DarkGray" x="405" y="46" width="52" height="16" uuid="414fb527-2a87-44c1-83ec-4c5b4e530851"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[%Tax]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-20" style="GroupHeader_DarkGray" x="537" y="46" width="41" height="16" uuid="ffbaa596-e1bd-4499-8dba-72be014e9c98"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="8" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Base]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-21" style="GroupHeader_DarkGray" x="699" y="46" width="42" height="16" uuid="ba44690f-84d4-4b93-9878-63de5cf301ac"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="8" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Amount]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-22" style="GroupHeader_DarkGray" x="617" y="46" width="82" height="16" uuid="be13c823-71f6-4590-8010-bc143a2dfe69"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Amount]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-23" style="GroupHeader_DarkGray" x="457" y="46" width="80" height="16" uuid="70a5cbec-52ca-4cda-900d-8ec02d0f44a2"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Base]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-24" style="GroupHeader_DarkGray" x="275" y="46" width="65" height="16" uuid="a9f00988-8c9e-449b-b209-b8f49a29b74d"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Price]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-25" style="GroupHeader_DarkGray" x="340" y="46" width="26" height="16" uuid="55d005a1-8e0f-4d6a-ab11-0e3e60ad105e"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="8" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Price]]></text>
				</staticText>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField-14" style="GroupHeader_DarkGray" x="366" y="46" width="39" height="16" uuid="45e5e9c0-bf38-47ab-9370-cfd1a89dc3e1"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#555555"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font size="8" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{CONVISOSYM}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField-19" style="GroupHeader_DarkGray" x="578" y="46" width="39" height="16" uuid="372daab1-b5dd-4013-940d-c6ce460c66ee"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#555555"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font size="8" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{CONVISOSYM}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField-20" style="GroupHeader_DarkGray" x="741" y="46" width="39" height="16" uuid="b4d61bfd-fec1-42de-901b-26ddbf6f8fbb"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#555555"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font size="8" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{CONVISOSYM}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement key="staticText-26" style="GroupHeader_DarkGray" x="365" y="0" width="91" height="18" uuid="767d64a7-d26e-4313-9442-03ae2f4043a2"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[AMOUNT]]></text>
				</staticText>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField-22" style="default" x="365" y="18" width="137" height="18" uuid="c0494ba0-b1bf-4dbe-8b87-46a76ea7ee8b"/>
					<box topPadding="2" leftPadding="5" rightPadding="4">
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
						<bottomPen lineWidth="0.0" lineColor="#555555"/>
						<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle"/>
					<textFieldExpression><![CDATA[($F{CONVGRANDTOTAL}!=null)?$P{NUMBERFORMAT}.format($F{CONVGRANDTOTAL}):new String(" ")]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField-23" style="GroupHeader_DarkGray" x="456" y="0" width="74" height="18" uuid="a322d6cb-662f-4ba5-855d-a5301b9b5705"/>
					<box leftPadding="5">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#555555"/>
						<bottomPen lineWidth="0.0" lineColor="#000000"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font pdfFontName="Helvetica-Bold"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{CONVISOSYM}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField-24" style="default" x="502" y="18" width="28" height="18" uuid="9db9ba6e-f862-4ef2-a1ec-0a665ee8c086"/>
					<box topPadding="2" leftPadding="5" rightPadding="4">
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#555555"/>
						<bottomPen lineWidth="0.0" lineColor="#555555"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle"/>
					<textFieldExpression><![CDATA[$F{CONVSYM}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField-25" style="default" x="337" y="18" width="28" height="18" uuid="a28107b5-1814-469e-8688-3b18adb6dfde"/>
					<box topPadding="2" leftPadding="5" rightPadding="4">
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#555555"/>
						<bottomPen lineWidth="0.0" lineColor="#555555"/>
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle"/>
					<textFieldExpression><![CDATA[$F{ORDERCURRENCYSYM}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="20" splitType="Stretch">
				<line>
					<reportElement key="line-23" stretchType="RelativeToBandHeight" x="20" y="0" width="1" height="10" forecolor="#555555" uuid="c912185a-845b-46bc-b746-ad5371ab9bb2"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-24" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="20" forecolor="#555555" uuid="ad6e1ffc-c3e2-4be2-acd7-f32939bd9ead"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-25" stretchType="RelativeToBandHeight" x="10" y="0" width="1" height="20" forecolor="#555555" uuid="10a63684-4e2b-4d41-aca8-32507fc0e51f"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-26" stretchType="RelativeToBandHeight" x="781" y="0" width="1" height="20" forecolor="#555555" uuid="7431ce3a-83ff-4dbd-83c1-1c3887da758a"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-27" x="20" y="10" width="761" height="1" forecolor="#555555" uuid="794e1636-722a-4bff-9cf5-b62cf168e147"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-36" style="Report_Footer" x="30" y="0" width="750" height="1" forecolor="#555555" uuid="c3831248-8dba-4be3-b90d-c2d5018dcf13"/>
					<graphicElement>
						<pen lineWidth="1.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="20" splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="65" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="false">
				<reportElement key="textField" style="Report_Title" mode="Transparent" x="0" y="4" width="782" height="20" uuid="525f85e0-4508-4282-94db-cd647a950875"/>
				<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>
				<textFieldExpression><![CDATA[$P{REPORT_TITLE}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement key="line-1" x="0" y="24" width="782" height="1" uuid="7d5a3b07-c2c2-4a7c-b69e-eabd08952a7d"/>
				<graphicElement>
					<pen lineWidth="1.0" lineStyle="Solid"/>
				</graphicElement>
			</line>
			<textField isStretchWithOverflow="true" isBlankWhenNull="false">
				<reportElement key="textField" style="Report_Subtitle" x="0" y="27" width="782" height="20" uuid="90f93116-d7ba-4b62-ae0b-b299de25f77c"/>
				<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>
					<font size="14"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{REPORT_SUBTITLE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-2" style="Report_Data_Label" x="402" y="50" width="48" height="15" uuid="55b4718e-0f6c-4e1d-b41f-5ec38d097e52">
					<printWhenExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()==1)]]></printWhenExpression>
				</reportElement>
				<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"/>
				<text><![CDATA[Total:]]></text>
			</staticText>
			<textField evaluationTime="Report" isBlankWhenNull="false">
				<reportElement key="textField-1" style="Total_Field" x="450" y="50" width="332" height="15" uuid="31ab592d-17ca-4695-8671-ba8f7e8af3f2">
					<printWhenExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()==1)]]></printWhenExpression>
				</reportElement>
				<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>
				<textFieldExpression><![CDATA[$V{DetailFieldTotal}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-3" style="Report_Data_Label" x="0" y="50" width="91" height="14" uuid="927e2756-dc77-41a3-924b-4e2d7e88b09e">
					<printWhenExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()==1)]]></printWhenExpression>
				</reportElement>
				<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>
				<text><![CDATA[Conditions:]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-2" style="Report_Data_Field" x="91" y="50" width="88" height="14" uuid="ad80cafd-309a-4418-8b17-c224f6c6d417">
					<printWhenExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()==1)]]></printWhenExpression>
				</reportElement>
				<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>
				<textFieldExpression><![CDATA[$P{ReportData}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="16" splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="14" splitType="Stretch">
			<line>
				<reportElement key="line-15" stretchType="RelativeToBandHeight" x="20" y="0" width="1" height="14" forecolor="#555555" uuid="60e00b30-a419-40db-969b-9cc24b660437"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Solid"/>
				</graphicElement>
			</line>
			<line>
				<reportElement key="line-16" stretchType="RelativeToBandHeight" x="781" y="0" width="1" height="14" forecolor="#555555" uuid="359d6245-0424-4962-a956-1412c6f0d837"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Solid"/>
				</graphicElement>
			</line>
			<line>
				<reportElement key="line-17" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="14" forecolor="#555555" uuid="ff2084c8-53bd-452c-9da5-2fd43aa091ac"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Solid"/>
				</graphicElement>
			</line>
			<line>
				<reportElement key="line-18" stretchType="RelativeToBandHeight" x="10" y="0" width="1" height="14" forecolor="#555555" uuid="14270fbd-7a7d-4e4e-bea2-1845e5b1c77e"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Solid"/>
				</graphicElement>
			</line>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" style="Detail_Line" x="30" y="0" width="140" height="14" uuid="00649927-f55b-43fb-8081-4fa42f2610de"/>
				<box leftPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{PRODUCT}!=null)?$F{PRODUCT}:new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Detail_Line" x="170" y="0" width="66" height="14" uuid="ecd57e9a-0694-4a81-a363-7e3d98ce3927"/>
				<box leftPadding="4" rightPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{QTYORDERED}!=null)?$P{NUMBERFORMAT}.format($F{QTYORDERED}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Detail_Line" x="236" y="0" width="39" height="14" uuid="1e3d936b-0a07-45b6-995f-7f3f6492053d"/>
				<box leftPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{UOMSYMBOL}!=null)?$F{UOMSYMBOL}:new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Detail_Line" x="537" y="0" width="59" height="14" uuid="58f488a1-1c47-4936-bb5c-3c07161fb8e4"/>
				<box leftPadding="5" rightPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{CONVTAXBASE}!=null)?$P{NUMBERFORMAT}.format($F{CONVTAXBASE}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Detail_Line" x="699" y="0" width="60" height="14" uuid="565b7034-4ea2-4e92-8ac1-9ab471ee8320"/>
				<box leftPadding="5" rightPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#555555"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{CONVLINENETAMT}!=null)?$P{NUMBERFORMAT}.format($F{CONVLINENETAMT}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-8" style="Detail_Line" x="617" y="0" width="61" height="14" uuid="0d073c06-d09f-46cf-bcc6-f3d755d36df1"/>
				<box leftPadding="5" rightPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#555555"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{LINENETAMT}!=null)?$P{NUMBERFORMAT}.format($F{LINENETAMT}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-9" style="Detail_Line" x="457" y="0" width="59" height="14" uuid="05aadd71-3db8-4f64-985d-a968a864283a"/>
				<box leftPadding="5" rightPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{TAXBASE}!=null)?$P{NUMBERFORMAT}.format($F{TAXBASE}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-10" style="Detail_Line" x="275" y="0" width="44" height="14" uuid="31adda2f-44ef-4771-aa65-d903b4b5279f"/>
				<box leftPadding="4" rightPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{PRICE}!=null)?$P{NUMBERFORMAT}.format($F{PRICE}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-11" style="Detail_Line" x="340" y="0" width="44" height="14" uuid="89f6a86c-38e6-4aff-9d76-f3367994439b"/>
				<box leftPadding="4" rightPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{CONVPRICE}!=null)?$P{NUMBERFORMAT}.format($F{CONVPRICE}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-12" style="Detail_Line" x="384" y="0" width="21" height="14" uuid="7f6ba4bd-fada-4110-8ea2-e23e22063ac6"/>
				<box leftPadding="4" rightPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{CONVPRICE}!=null)?$F{CONVSYM}:new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-13" style="Detail_Line" x="405" y="0" width="52" height="14" uuid="e2889662-60e7-4b1c-820c-60066f2095c1"/>
				<box leftPadding="5" rightPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{TAX}!=null)?$P{NUMBERFORMAT}.format($F{TAX}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-15" style="Detail_Line" x="319" y="0" width="21" height="14" uuid="9e8669a8-e96e-40f8-b14d-c6ddc2d78806"/>
				<box leftPadding="4" rightPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{PRICE}!=null)?$F{LINECURRENCYSYM}:new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-16" style="Detail_Line" x="516" y="0" width="21" height="14" uuid="d85a820a-68cc-4edb-9815-cd3eec6a71b1"/>
				<box leftPadding="4" rightPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{TAXBASE}!=null)?$F{LINECURRENCYSYM}:new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-17" style="Detail_Line" x="678" y="0" width="21" height="14" uuid="563b0046-adea-4878-bf19-f573e3eb1611"/>
				<box leftPadding="4" rightPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{LINECURRENCYSYM}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-18" style="Detail_Line" x="596" y="0" width="21" height="14" uuid="d9598507-7536-46ef-9698-7b67589ab92c"/>
				<box leftPadding="4" rightPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{CONVTAXBASE}!=null)?$F{CONVSYM}:new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-26" style="Detail_Line" x="759" y="0" width="21" height="14" uuid="a6185ca1-fc63-437a-86f9-3d8ffe4818a1"/>
				<box leftPadding="5" rightPadding="4">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#555555"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#555555"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CONVSYM}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="16" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="20" splitType="Stretch">
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Report_Footer" x="643" y="4" width="95" height="16" uuid="67ac4e5a-f9f6-430e-a0ab-78731a1fdb9b"/>
				<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="Helvetica" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Report_Footer" x="740" y="4" width="36" height="16" forecolor="#000000" backcolor="#FFFFFF" uuid="a0dfa127-e499-475c-b2cd-f94f9f2b16eb"/>
				<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" rotation="None">
					<font fontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="CP1252" isPdfEmbedded="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement key="line" x="0" y="1" width="782" height="1" forecolor="#000000" uuid="3842823c-fbd3-457f-a728-eba02463acd3"/>
				<graphicElement>
					<pen lineWidth="1.0" lineStyle="Solid"/>
				</graphicElement>
			</line>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Report_Footer" x="383" y="4" width="69" height="16" uuid="6ac6bcf6-3a87-468c-892e-cba0ee601246"/>
				<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 verticalAlignment="Bottom">
					<font fontName="Times-Roman" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[new Date()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-1" style="Report_Footer" x="304" y="4" width="78" height="16" uuid="67987058-9b3e-4375-a461-01ce6909af65"/>
				<box topPadding="2" 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="Right" verticalAlignment="Bottom"/>
				<text><![CDATA[Generated on]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-5" style="Report_Footer" x="0" y="4" width="140" height="16" uuid="fc32adec-aa35-47ba-8be6-36710e3b2570">
					<printWhenExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()==1)]]></printWhenExpression>
				</reportElement>
				<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 verticalAlignment="Bottom"/>
				<text><![CDATA[other footer data]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>