src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.jrxml
author RM packaging bot <staff.rm@openbravo.com>
Wed, 19 Jun 2019 13:47:55 +0000
changeset 36181 5a31264dd0f8
parent 30843 5a80b60636c3
permissions -rw-r--r--
CI: update AD_MODULE to version 36180
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.0.0.final using JasperReports Library version 6.0.0  -->
<!-- 2016-07-12T15:04:28 -->
<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="ReportInvoiceDiscountJR" pageWidth="930" pageHeight="595" orientation="Landscape" columnWidth="870" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" uuid="143e2f91-13e7-4c3a-ac89-f630de85c5f4">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<property name="com.jaspersoft.studio.unit." value="pixel"/>
	<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
	<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="Total_Field" mode="Opaque" forecolor="#000000" backcolor="#CCCCCC" vAlign="Middle">
		<box leftPadding="5"/>
	</style>
	<style name="Detail_Header" 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" mode="Opaque" forecolor="#FFFFFF" backcolor="#555555" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="14">
		<box leftPadding="5"/>
	</style>
	<style name="GroupHeader_Gray" mode="Opaque" backcolor="#999999"/>
	<style name="Detail_Line">
		<conditionalStyle>
			<conditionExpression><![CDATA[new Boolean($V{NAME_COUNT}.intValue()%2==1)]]></conditionExpression>
			<style mode="Opaque" backcolor="#CCCCCC"/>
		</conditionalStyle>
	</style>
	<style name="Total_Gray" mode="Opaque" forecolor="#000000" backcolor="#CCCCCC"/>
	<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"/>
	<parameter name="NUMBERFORMAT" class="java.text.DecimalFormat" isForPrompting="false"/>
	<parameter name="LOCALE" class="java.util.Locale" isForPrompting="false"/>
	<parameter name="isUomManagementEnabled" class="java.lang.Boolean">
		<defaultValueExpression><![CDATA[org.openbravo.materialmgmt.UOMUtil.isUomManagementEnabled()]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT C_BPARTNER_ID as ID, NAME, PRODUCTNAME, QTY,UOM, ROUND(C_DIVIDE(TOTALLINE,QTY),3) AS PRICEACTUAL, TOTALLINE, 
	ROUND(C_DIVIDE(TOTALLINEDISCOUNT,QTY),3) AS REALPRICE, TOTALLINEDISCOUNT,        
	(ROUND(C_DIVIDE((ROUND(C_DIVIDE(TOTALLINE,QTY),3)-ROUND(C_DIVIDE(TOTALLINEDISCOUNT,QTY),3)),ROUND(C_DIVIDE(TOTALLINE,QTY),3)),2))*100 AS DISCOUNT,        
	(CASE (ROUND(C_DIVIDE((ROUND(C_DIVIDE(TOTALLINE,QTY),3)-ROUND(C_DIVIDE(TOTALLINEDISCOUNT,QTY),3)),ROUND(C_DIVIDE(TOTALLINE,QTY),3)),2))*100 WHEN 0 THEN '' ELSE '' END)  AS CLASS_DESIGN,        
	WEIGHT,	TRCURRENCYID AS TRANSCURRENCYID, TRDATE AS TRANSDATE,	TRCLIENTID AS TRANSCLIENTID, TRORGID AS TRANSORGID,
	C_CURRENCY_SYMBOL('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM('102') AS CONVISOSYM
	FROM (SELECT C_BPARTNER.C_BPARTNER_ID, C_BPARTNER.NAME, M_PRODUCT.NAME AS PRODUCTNAME, C_UOM.UOMSYMBOL AS UOM, SUM(C_INVOICELINE.QTYINVOICED) AS QTY, 
	C_CURRENCY_CONVERT(ROUND(SUM(LINENETAMT),2), C_INVOICE.C_CURRENCY_ID, '102',  TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICELINE.AD_CLIENT_ID, C_INVOICELINE.AD_ORG_ID) AS TOTALLINE,         
	C_CURRENCY_CONVERT(ROUND(SUM(LINENETAMT*(1-COALESCE(DISCOUNTPERUNIT,0))),2), C_INVOICE.C_CURRENCY_ID, '102',  TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICELINE.AD_CLIENT_ID, C_INVOICELINE.AD_ORG_ID) AS TOTALLINEDISCOUNT, 
	SUM(C_INVOICELINE.QTYINVOICED)*COALESCE(M_PRODUCT.WEIGHT,0) AS WEIGHT,
	C_INVOICE.C_CURRENCY_ID AS TRCURRENCYID,
	TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS TRDATE,
	C_INVOICELINE.AD_CLIENT_ID AS TRCLIENTID, 
	C_INVOICELINE.AD_ORG_ID AS TRORGID      
	FROM C_INVOICELINE left join          
	(SELECT C_INVOICE_ID, DISCOUNTLINES/(TOTALLINES+DISCOUNTLINES) AS DISCOUNTPERUNIT           
	FROM (SELECT I.C_INVOICE_ID, 
	C_CURRENCY_CONVERT(I.TOTALLINES, I.C_CURRENCY_ID, '102',  TO_DATE(COALESCE(I.DATEINVOICED, NOW())), NULL, I.AD_CLIENT_ID, I.AD_ORG_ID) AS TOTALLINES, 
	C_CURRENCY_CONVERT(-SUM(LINENETAMT), I.C_CURRENCY_ID, '102',  TO_DATE(COALESCE(I.DATEINVOICED, NOW())), NULL, IL.AD_CLIENT_ID, IL.AD_ORG_ID) AS DISCOUNTLINES
	FROM C_INVOICE I, C_INVOICELINE IL           
	WHERE I.C_INVOICE_ID = IL.C_INVOICE_ID AND IL.C_INVOICE_DISCOUNT_ID IS NOT NULL           
	GROUP BY I.C_INVOICE_ID, I.TOTALLINES, I.C_CURRENCY_ID, I.DATEINVOICED, I.AD_CLIENT_ID, I.AD_ORG_ID, IL.AD_CLIENT_ID, IL.AD_ORG_ID) BB) A on C_INVOICELINE.C_INVOICE_ID = A.C_INVOICE_ID
    left join C_INVOICE on C_INVOICELINE.C_INVOICE_ID = C_INVOICE.C_INVOICE_ID,
    M_PRODUCT, C_BPARTNER,  C_UOM
    WHERE  C_INVOICELINE.C_INVOICE_DISCOUNT_ID IS NULL
    AND C_INVOICELINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
    AND M_PRODUCT.C_UOM_ID = C_UOM.C_UOM_ID
    AND C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
    AND C_INVOICE.ISSOTRX='Y'
    AND C_INVOICE.AD_CLIENT_ID IN ('1')
    AND C_INVOICE.AD_ORG_ID IN ('1')
    AND PRICEACTUAL<>0
    AND C_INVOICE.DATEINVOICED >= to_date(?)
    AND C_INVOICE.DATEINVOICED <= to_date(?)
    AND 1=1
    GROUP BY C_BPARTNER.C_BPARTNER_ID, C_BPARTNER.NAME, M_PRODUCT.NAME, C_UOM.UOMSYMBOL, M_PRODUCT.WEIGHT, 
    C_INVOICE.C_CURRENCY_ID, C_INVOICE.DATEINVOICED, C_INVOICELINE.AD_CLIENT_ID, C_INVOICELINE.AD_ORG_ID) AA
    WHERE QTY<>0
    AND 2=2
    ORDER BY NAME]]>
	</queryString>
	<field name="ID" class="java.lang.String"/>
	<field name="NAME" class="java.lang.String"/>
	<field name="PRODUCTNAME" class="java.lang.String"/>
	<field name="QTY" class="java.math.BigDecimal"/>
	<field name="UOM" class="java.lang.String"/>
	<field name="PRICEACTUAL" class="java.math.BigDecimal"/>
	<field name="TOTALLINE" class="java.math.BigDecimal"/>
	<field name="REALPRICE" class="java.math.BigDecimal"/>
	<field name="TOTALLINEDISCOUNT" class="java.math.BigDecimal"/>
	<field name="DISCOUNT" class="java.math.BigDecimal"/>
	<field name="CLASS_DESIGN" class="java.lang.String"/>
	<field name="WEIGHT" class="java.math.BigDecimal"/>
	<field name="CONVSYM" class="java.lang.String"/>
	<field name="CONVISOSYM" class="java.lang.String"/>
	<field name="AUMQTY" class="java.math.BigDecimal"/>
	<field name="AUM" class="java.lang.String"/>
	<variable name="totalWeight" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{WEIGHT}]]></variableExpression>
	</variable>
	<variable name="totalLine" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTALLINE}]]></variableExpression>
	</variable>
	<variable name="totalWeightDetail" class="java.math.BigDecimal" resetType="Group" resetGroup="NAME" calculation="Sum">
		<variableExpression><![CDATA[$F{WEIGHT}]]></variableExpression>
	</variable>
	<variable name="totalLineDetail" class="java.math.BigDecimal" resetType="Group" resetGroup="NAME" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTALLINE}]]></variableExpression>
	</variable>
	<variable name="totalLineDiscountDetail" class="java.math.BigDecimal" resetType="Group" resetGroup="NAME" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTALLINEDISCOUNT}]]></variableExpression>
	</variable>
	<variable name="totalLineDiscount" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTALLINEDISCOUNT}]]></variableExpression>
	</variable>
	<group name="NAME">
		<groupExpression><![CDATA[$F{NAME}]]></groupExpression>
		<groupHeader>
			<band height="66" splitType="Stretch">
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement key="textField" style="GroupHeader_DarkGray" x="1" y="0" width="868" height="23" uuid="e6d28c79-0d54-4667-b908-097cc7d6e075"/>
					<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 fontName="Bitstream Vera Sans" pdfFontName="Helvetica"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" mode="Opaque" x="492" y="50" width="57" height="16" uuid="2bc0b169-d5bd-4f7a-8e68-ebc00e32396e"/>
					<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="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<text><![CDATA[Amt.]]></text>
				</staticText>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="704" y="50" width="57" height="16" uuid="db8a8a51-7094-46c0-9d0a-8243ad778217"/>
					<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="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<text><![CDATA[Real Amt.]]></text>
				</staticText>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="0" y="50" width="156" height="16" uuid="4be254d3-3614-412e-b238-bf02ed9f3553"/>
					<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="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<text><![CDATA[Article]]></text>
				</staticText>
				<line>
					<reportElement key="line-2" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="66" forecolor="#555555" uuid="9e0a858a-8a68-404c-b5a7-8a1eae27edd3"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="156" y="50" width="51" height="16" uuid="95add4c7-df18-4a60-a90d-fbd6a3c9b584">
						<printWhenExpression><![CDATA[$P{isUomManagementEnabled} == true]]></printWhenExpression>
					</reportElement>
					<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="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<text><![CDATA[Quantity]]></text>
				</staticText>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="207" y="50" width="33" height="16" uuid="da63bfad-a47a-47bb-915f-384cbe22bee4">
						<printWhenExpression><![CDATA[$P{isUomManagementEnabled} == true]]></printWhenExpression>
					</reportElement>
					<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="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<text><![CDATA[UOM]]></text>
				</staticText>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="328" y="50" width="58" height="16" uuid="76f881cc-8d45-495b-9657-2e97f56dede8"/>
					<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="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<text><![CDATA[Weight]]></text>
				</staticText>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="386" y="50" width="57" height="16" uuid="187adde8-9526-40c9-9c3c-c9f4cb24ae8f"/>
					<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="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<text><![CDATA[Avg. Pr.]]></text>
				</staticText>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="810" y="50" width="34" height="16" uuid="e26c2376-eea2-41d7-848d-76fd0f415848"/>
					<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="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<text><![CDATA[Disc.]]></text>
				</staticText>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="598" y="50" width="57" height="16" uuid="93c2739b-5fb0-40fe-b027-0a805776157f"/>
					<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="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<text><![CDATA[Avg. Net Pr.]]></text>
				</staticText>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField-8" style="Detail_Header" x="761" y="50" width="49" height="16" uuid="5ea6979e-db22-45b3-a717-dc38b635a3c7"/>
					<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="#555555"/>
						<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{CONVISOSYM}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField-10" style="Detail_Header" x="655" y="50" width="49" height="16" uuid="a6d22be6-4a95-4fc4-bc35-2092e52ffa6a"/>
					<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="#555555"/>
						<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{CONVISOSYM}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField-12" style="Detail_Header" x="549" y="50" width="49" height="16" uuid="20f39efe-64c0-46b3-bafd-60a8d2dd11aa"/>
					<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="#555555"/>
						<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{CONVISOSYM}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement key="element-91" style="Detail_Header" x="844" y="50" width="25" height="16" uuid="48d3c3ed-1e99-487a-a2a7-f1fff6b8a992">
						<property name="local_mesure_unitwidth" value="pixel"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<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="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<text><![CDATA[%]]></text>
				</staticText>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField-14" style="Detail_Header" x="443" y="50" width="49" height="16" uuid="dc816d49-f951-43ea-b77c-14823c2bd97d"/>
					<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="#555555"/>
						<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{CONVISOSYM}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="240" y="50" width="55" height="16" uuid="d1ebca4e-9fd5-43b8-9a7a-78fa2e2a3055">
						<printWhenExpression><![CDATA[$P{isUomManagementEnabled} == true]]></printWhenExpression>
					</reportElement>
					<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="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<text><![CDATA[Qty in AUM]]></text>
				</staticText>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="295" y="50" width="33" height="16" uuid="9cf1b57e-1ff1-46aa-a52d-47b57bccff6e">
						<printWhenExpression><![CDATA[$P{isUomManagementEnabled} == true]]></printWhenExpression>
					</reportElement>
					<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="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<text><![CDATA[AUM]]></text>
				</staticText>
				<line>
					<reportElement key="line-3" stretchType="RelativeToBandHeight" x="869" y="0" width="1" height="66" forecolor="#555555" uuid="9fd2c151-6983-4102-8ba7-a974538fcc41"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="240" y="50" width="88" height="16" uuid="2fb5f766-fb2f-410b-8419-8035630abb01">
						<printWhenExpression><![CDATA[$P{isUomManagementEnabled} == false]]></printWhenExpression>
					</reportElement>
					<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="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<text><![CDATA[UOM]]></text>
				</staticText>
				<staticText>
					<reportElement key="element-90" style="Detail_Header" x="156" y="50" width="84" height="16" uuid="1dd8ba78-ebb7-4455-9e2c-0df6e9bda7ea">
						<printWhenExpression><![CDATA[$P{isUomManagementEnabled} == false]]></printWhenExpression>
					</reportElement>
					<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="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="Bitstream Vera Sans" size="8"/>
					</textElement>
					<text><![CDATA[Quantity]]></text>
				</staticText>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="42" splitType="Stretch">
				<elementGroup/>
				<line>
					<reportElement key="line-33" stretchType="RelativeToBandHeight" x="869" y="0" width="1" height="40" forecolor="#555555" uuid="8e424f86-a83d-4f05-9330-7542e7084eba"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<line>
					<reportElement key="line-34" x="0" y="39" width="870" height="1" forecolor="#555555" uuid="a68f5492-2738-4e32-990c-076ddfb036f1"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
				<staticText>
					<reportElement key="staticText-6" style="GroupHeader_Gray" mode="Transparent" x="232" y="7" width="69" height="16" uuid="29a00cdd-9676-4f81-9906-ae613df8f2da"/>
					<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="Right">
						<font fontName="Bitstream Vera Sans"/>
					</textElement>
					<text><![CDATA[Total:]]></text>
				</staticText>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField" style="Total_Gray" x="385" y="7" width="189" height="16" uuid="46cbdff6-f815-4a14-a341-28e32387c2be"/>
					<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">
						<font fontName="Bitstream Vera Sans"/>
					</textElement>
					<textFieldExpression><![CDATA[($V{totalLineDetail}!=null)?$P{NUMBERFORMAT}.format($V{totalLineDetail}):new String(" ")]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="true">
					<reportElement key="textField" style="Total_Gray" x="304" y="7" width="81" height="16" uuid="1bdf81d4-b12e-412a-b18a-8dc581d3e210"/>
					<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">
						<font fontName="Bitstream Vera Sans"/>
					</textElement>
					<textFieldExpression><![CDATA[($V{totalWeightDetail}!=null)?$P{NUMBERFORMAT}.format($V{totalWeightDetail}):new String(" ")]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField" style="Total_Gray" x="597" y="7" width="188" height="16" uuid="6afa5ac3-232e-4099-b7bc-5fa8a989cff2"/>
					<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">
						<font fontName="Bitstream Vera Sans"/>
					</textElement>
					<textFieldExpression><![CDATA[($V{totalLineDiscountDetail}!=null)?$P{NUMBERFORMAT}.format($V{totalLineDiscountDetail}):new String(" ")]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField-16" style="Total_Gray" x="574" y="7" width="23" height="16" uuid="09378bfe-b883-4705-b4b0-6f0e68f7f0c5"/>
					<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">
						<font fontName="Bitstream Vera Sans"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{CONVSYM}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement key="textField-17" style="Total_Gray" x="785" y="7" width="23" height="16" uuid="fbb555af-6cc6-4c30-9250-783ef98e1881"/>
					<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">
						<font fontName="Bitstream Vera Sans"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{CONVSYM}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement key="staticText-10" style="Total_Gray" x="808" y="7" width="58" height="16" uuid="3ca1236d-e87f-4acf-9f45-e28ce8122070"/>
					<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="Center" verticalAlignment="Bottom">
						<font fontName="Bitstream Vera Sans"/>
					</textElement>
					<text><![CDATA[]]></text>
				</staticText>
				<line>
					<reportElement key="line-35" x="1" y="0" width="868" height="1" uuid="588e020d-1ae5-4a25-a80d-df64cf1590a1"/>
				</line>
				<line>
					<reportElement key="line-17" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="39" forecolor="#555555" uuid="f3cc2e2d-a716-48f1-bfdd-9b86294a4a1b"/>
					<graphicElement>
						<pen lineWidth="2.0" lineStyle="Solid"/>
					</graphicElement>
				</line>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="60" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="false">
				<reportElement key="textField" style="Report_Title" mode="Transparent" x="0" y="7" width="870" height="30" uuid="2dd84320-bf57-44a4-9e62-247caf9bc0f9"/>
				<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 fontName="Bitstream Vera Sans"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{REPORT_TITLE}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement key="line-1" x="0" y="37" width="870" height="2" uuid="105b7d1b-c7ac-4dcc-9183-9bae52e765f3"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Solid"/>
				</graphicElement>
			</line>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" x="0" y="39" width="870" height="21" uuid="21b6d2fa-e16a-4ddd-bad2-a4388f95fc8d"/>
				<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>
					<font fontName="Bitstream Vera Sans"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{REPORT_SUBTITLE}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="20" splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="16" splitType="Stretch">
			<line>
				<reportElement key="line-16" stretchType="RelativeToBandHeight" x="869" y="0" width="1" height="16" forecolor="#555555" uuid="e76f46a1-9d7f-4d26-baf8-9f0b7b3220cd"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Solid"/>
				</graphicElement>
			</line>
			<line>
				<reportElement key="line-17" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="16" forecolor="#555555" uuid="4dddb3dd-b155-496a-b93b-bda32947166b"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Solid"/>
				</graphicElement>
			</line>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Detail_Line" stretchType="RelativeToBandHeight" x="492" y="0" width="82" height="16" uuid="e6fd8531-47ec-4b0d-b6c8-85f7bc8634c6"/>
				<box leftPadding="2" rightPadding="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="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{TOTALLINE}!=null)?$P{NUMBERFORMAT}.format($F{TOTALLINE}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Detail_Line" stretchType="RelativeToBandHeight" x="704" y="0" width="82" height="16" uuid="3db5e07f-a52f-4a7f-8dbb-e64b4a79e5c3"/>
				<box leftPadding="2" rightPadding="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="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{TOTALLINEDISCOUNT}!=null)?$P{NUMBERFORMAT}.format($F{TOTALLINEDISCOUNT}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement key="textField" style="Detail_Line" stretchType="RelativeToBandHeight" x="1" y="0" width="155" height="16" uuid="440e77f0-d7f9-48a0-af7c-faa6cafaa2e0">
					<property name="local_mesure_unitx" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.x" value="px"/>
				</reportElement>
				<box leftPadding="2" rightPadding="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="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{PRODUCTNAME}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Detail_Line" stretchType="RelativeToBandHeight" x="156" y="0" width="51" height="16" uuid="815fd137-b0ea-42a6-8d4a-51dd84bfe788">
					<printWhenExpression><![CDATA[$P{isUomManagementEnabled} == true]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="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="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{QTY}!=null)?$P{NUMBERFORMAT}.format($F{QTY}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement key="textField" style="Detail_Line" stretchType="RelativeToBandHeight" x="207" y="0" width="33" height="16" uuid="db5d5635-6d27-466f-9e8d-407d1c0b61fc">
					<printWhenExpression><![CDATA[$P{isUomManagementEnabled} == true]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="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="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{UOM}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Detail_Line" stretchType="RelativeToBandHeight" x="328" y="0" width="58" height="16" uuid="d3e3bfa6-e5a0-40fb-9fc0-982bd6af277d"/>
				<box leftPadding="2" rightPadding="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="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{WEIGHT}!=null)?$P{NUMBERFORMAT}.format($F{WEIGHT}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Detail_Line" stretchType="RelativeToBandHeight" x="386" y="0" width="82" height="16" uuid="3e776fa6-539f-4a7d-acec-2ba2bc43c956"/>
				<box leftPadding="2" rightPadding="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="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{PRICEACTUAL}!=null)?$P{NUMBERFORMAT}.format($F{PRICEACTUAL}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Detail_Line" stretchType="RelativeToBandHeight" x="810" y="0" width="59" height="16" uuid="886eb021-5cdc-447b-b289-b6200e89bab4">
					<property name="local_mesure_unitwidth" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<box leftPadding="2" rightPadding="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="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{DISCOUNT}!=null)?$P{NUMBERFORMAT}.format($F{DISCOUNT}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Detail_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="598" y="0" width="82" height="16" uuid="5fa7ee22-ad19-4eb3-be97-6e200d2ab6a8"/>
				<box leftPadding="2" rightPadding="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="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{REALPRICE}!=null)?$P{NUMBERFORMAT}.format($F{REALPRICE}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-9" style="Detail_Line" stretchType="RelativeToBandHeight" x="786" y="0" width="24" height="16" uuid="a9d34c5b-97ce-4411-9f38-721ae793ee56"/>
				<box leftPadding="2" rightPadding="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="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CONVSYM}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-11" style="Detail_Line" stretchType="RelativeToBandHeight" x="680" y="0" width="24" height="16" uuid="faea10d2-adf6-4b07-b214-f34323d256d0"/>
				<box leftPadding="2" rightPadding="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="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CONVSYM}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-13" style="Detail_Line" stretchType="RelativeToBandHeight" x="574" y="0" width="24" height="16" uuid="251adf14-d11c-40fa-bc8b-1069f71678f9"/>
				<box leftPadding="2" rightPadding="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="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CONVSYM}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-15" style="Detail_Line" stretchType="RelativeToBandHeight" x="468" y="0" width="24" height="16" uuid="a42d7f5e-3a87-4cfd-8748-f81ff960796e"/>
				<box leftPadding="2" rightPadding="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="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CONVSYM}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Detail_Line" stretchType="RelativeToBandHeight" x="240" y="0" width="55" height="16" uuid="3bd5391a-660e-4aae-8714-6ca898c11f48">
					<printWhenExpression><![CDATA[$P{isUomManagementEnabled} == true]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="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="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{AUMQTY}!=null)?$P{NUMBERFORMAT}.format($F{AUMQTY}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement key="textField" style="Detail_Line" stretchType="RelativeToBandHeight" x="295" y="0" width="33" height="16" uuid="ec7fc12c-c238-4f46-863b-1873519f6b91">
					<printWhenExpression><![CDATA[$P{isUomManagementEnabled} == true]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="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="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{AUM}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" style="Detail_Line" stretchType="RelativeToBandHeight" x="156" y="0" width="84" height="16" uuid="ec7d3aee-da1d-43a7-b860-2adb4358d6ed">
					<printWhenExpression><![CDATA[$P{isUomManagementEnabled} == false]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="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="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{QTY}!=null)?$P{NUMBERFORMAT}.format($F{QTY}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement key="textField" style="Detail_Line" stretchType="RelativeToBandHeight" x="240" y="0" width="88" height="16" uuid="0692ccbf-60e2-4015-acdc-aa9e9607a149">
					<printWhenExpression><![CDATA[$P{isUomManagementEnabled} == false]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="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="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Bitstream Vera Sans" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{UOM}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="16" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="27" splitType="Stretch">
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" x="734" y="4" width="95" height="19" uuid="04507f17-90c1-46e6-8b58-adeeed89f845"/>
				<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" x="833" y="4" width="36" height="19" forecolor="#000000" backcolor="#FFFFFF" uuid="18a1946d-db91-453f-8571-cfc4f2eaf1c8"/>
				<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="0" width="870" height="2" forecolor="#000000" uuid="a5edf652-b2c3-40bb-9670-2aaf240d6219"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Solid"/>
				</graphicElement>
			</line>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" x="468" y="4" width="69" height="19" uuid="5fab59ce-9764-4ab3-b58e-092907d73013"/>
				<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" x="387" y="4" width="78" height="19" uuid="70669d50-2e1a-4a71-9379-441b8144fa13"/>
				<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>
		</band>
	</pageFooter>
	<summary>
		<band height="28" splitType="Stretch">
			<staticText>
				<reportElement key="staticText-7" style="default" mode="Transparent" x="234" y="6" width="69" height="16" uuid="3feaeec9-05d3-4d83-9ff6-a67e9aa15fe6"/>
				<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">
					<font fontName="Bitstream Vera Sans"/>
				</textElement>
				<text><![CDATA[Totals]]></text>
			</staticText>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement key="textField-2" style="Total_Gray" x="306" y="6" width="81" height="16" uuid="7b8f26b8-0283-4a2e-a5a1-1bbdc52e39cc"/>
				<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">
					<font fontName="Bitstream Vera Sans"/>
				</textElement>
				<textFieldExpression><![CDATA[($V{totalWeight}!=null)?$P{NUMBERFORMAT}.format($V{totalWeight}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement key="textField-3" style="Total_Gray" x="387" y="6" width="189" height="16" uuid="430fd02b-cab9-4a47-8754-8a6b2f928a88"/>
				<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">
					<font fontName="Bitstream Vera Sans"/>
				</textElement>
				<textFieldExpression><![CDATA[($V{totalLine}!=null)?$P{NUMBERFORMAT}.format($V{totalLine}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement key="textField-4" style="Total_Gray" x="599" y="6" width="188" height="16" uuid="448082d2-4d8a-41c4-b8f6-9cb98067417f"/>
				<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">
					<font fontName="Bitstream Vera Sans"/>
				</textElement>
				<textFieldExpression><![CDATA[($V{totalLineDetail}!=null)?$P{NUMBERFORMAT}.format($V{totalLineDetail}):new String(" ")]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-19" style="Total_Gray" x="576" y="6" width="23" height="16" uuid="f756d6eb-7e02-444b-ae87-5e6e2e627a5a"/>
				<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">
					<font fontName="Bitstream Vera Sans"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CONVSYM}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-20" style="Total_Gray" x="787" y="6" width="23" height="16" uuid="3f0becab-f954-4276-8948-0b6d632e6021"/>
				<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">
					<font fontName="Bitstream Vera Sans"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CONVSYM}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-9" style="Total_Gray" x="810" y="6" width="60" height="16" uuid="7730f5ee-4f3e-4750-8679-662e3628bfb6"/>
				<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="Center" verticalAlignment="Bottom">
					<font fontName="Bitstream Vera Sans"/>
				</textElement>
				<text><![CDATA[]]></text>
			</staticText>
		</band>
	</summary>
</jasperReport>