Fixes issue 31710: Review XLS reports to apply cell type when required
authorArmaignac <collazoandy4@gmail.com>
Wed, 26 Jul 2017 17:24:11 -0400
changeset 32534 9b2210a5b692
parent 32533 b12d3da979df
child 32535 b74ed74f842a
Fixes issue 31710: Review XLS reports to apply cell type when required

The Journal Entries, Shipments Dimensional, Stock, Purchase Invoice Dimensional,
Sales Invoice Dimensional, and Customer Statement Reports was modified in order
to ensure that all numeric fields can be exported as numeric

The fields defined in jasper report contains a format method call causing the
cell value be of string type

All the format calls was removed and the field now specified the cell value type
and the output format by the jasper patternExpression specification.
src/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalExcel.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesXLS.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartnerJR.jrxml
src/org/openbravo/erpCommon/ad_reports/WeightDimensionalComparative.jrxml
src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml
--- a/src/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml	Tue Aug 01 13:42:56 2017 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml	Wed Jul 26 17:24:11 2017 -0400
@@ -7,6 +7,7 @@
 	<property name="ireport.zoom" value="1.2100000000000006"/>
 	<property name="ireport.x" value="0"/>
 	<property name="ireport.y" value="0"/>
+	<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
 	<import value="net.sf.jasperreports.engine.*"/>
 	<import value="java.util.*"/>
 	<import value="org.openbravo.erpCommon.ReportsUtility"/>
@@ -204,7 +205,8 @@
 						<font fontName="DejaVu Sans" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
 						<paragraph lineSpacing="Single"/>
 					</textElement>
-					<textFieldExpression><![CDATA[$V{customerInitialBalance}.compareTo(BigDecimal.ZERO) < 0 ? "(" + $P{NUMBERFORMAT}.format($V{customerInitialBalance}.abs()) + ")" : $P{NUMBERFORMAT}.format($V{customerInitialBalance})]]></textFieldExpression>
+					<textFieldExpression><![CDATA[$V{customerInitialBalance}.compareTo(BigDecimal.ZERO) < 0 ?  $V{customerInitialBalance}.abs() : $V{customerInitialBalance}]]></textFieldExpression>
+					<patternExpression><![CDATA[$V{customerInitialBalance}.compareTo(BigDecimal.ZERO) < 0 ? ("("+$P{NUMBERFORMAT}.toPattern()+")") : $P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<staticText>
 					<reportElement x="331" y="56" width="115" height="14" forecolor="#000000" backcolor="#FFFFFF" uuid="b7fa0a14-eaf8-4ba3-8f63-b539a95d5c7f"/>
@@ -287,7 +289,8 @@
 						<font fontName="DejaVu Sans" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
 						<paragraph lineSpacing="Single"/>
 					</textElement>
-					<textFieldExpression><![CDATA[$V{vendorInitialBalance}.compareTo(BigDecimal.ZERO) < 0 ? "(" + $P{NUMBERFORMAT}.format($V{vendorInitialBalance}.abs()) + ")" : $P{NUMBERFORMAT}.format($V{vendorInitialBalance})]]></textFieldExpression>
+					<textFieldExpression><![CDATA[$V{vendorInitialBalance}.compareTo(BigDecimal.ZERO) < 0 ? $V{vendorInitialBalance}.abs() : $V{vendorInitialBalance}]]></textFieldExpression>
+					<patternExpression><![CDATA[$V{vendorInitialBalance}.compareTo(BigDecimal.ZERO) < 0 ? ("("+$P{NUMBERFORMAT}.toPattern()+")") : $P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 			</band>
 		</groupHeader>
@@ -302,7 +305,8 @@
 						<font fontName="DejaVu Sans" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
 						<paragraph lineSpacing="Single"/>
 					</textElement>
-					<textFieldExpression><![CDATA[$V{customerBalance}.compareTo(BigDecimal.ZERO) < 0 ? "(" + $P{NUMBERFORMAT}.format($V{customerBalance}.abs()) + ")" : $P{NUMBERFORMAT}.format($V{customerBalance})]]></textFieldExpression>
+					<textFieldExpression><![CDATA[$V{customerBalance}.compareTo(BigDecimal.ZERO) < 0 ? $V{customerBalance}.abs() : $V{customerBalance}]]></textFieldExpression>
+					<patternExpression><![CDATA[$V{customerBalance}.compareTo(BigDecimal.ZERO) < 0 ? ("("+$P{NUMBERFORMAT}.toPattern()+")") : $P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<staticText>
 					<reportElement positionType="Float" mode="Opaque" x="330" y="12" width="115" height="15" isPrintWhenDetailOverflows="true" forecolor="#000000" backcolor="#FFFFFF" uuid="8d228eb8-2fde-4f0a-9bfb-b6ee85f1eb54"/>
@@ -327,7 +331,8 @@
 						<font fontName="DejaVu Sans" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
 						<paragraph lineSpacing="Single"/>
 					</textElement>
-					<textFieldExpression><![CDATA[$V{vendorBalance}.compareTo(BigDecimal.ZERO) < 0 ? "(" + $P{NUMBERFORMAT}.format($V{vendorBalance}.abs()) + ")" : $P{NUMBERFORMAT}.format($V{vendorBalance})]]></textFieldExpression>
+					<textFieldExpression><![CDATA[$V{vendorBalance}.compareTo(BigDecimal.ZERO) < 0 ? $V{vendorBalance}.abs() : $V{vendorBalance}]]></textFieldExpression>
+					<patternExpression><![CDATA[$V{vendorBalance}.compareTo(BigDecimal.ZERO) < 0 ? ("("+$P{NUMBERFORMAT}.toPattern()+")") : $P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 			</band>
 		</groupFooter>
@@ -486,7 +491,8 @@
 					<font fontName="DejaVu Sans" size="8"/>
 					<paragraph lineSpacing="1_1_2"/>
 				</textElement>
-				<textFieldExpression><![CDATA[$F{credit}.compareTo(BigDecimal.ZERO) < 0 ? "(" + $P{NUMBERFORMAT}.format($F{credit}.abs()) + ")" : $P{NUMBERFORMAT}.format($F{credit})]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$F{credit}.compareTo(BigDecimal.ZERO) < 0 ? $F{credit}.abs() : $F{credit}]]></textFieldExpression>
+				<patternExpression><![CDATA[$F{credit}.compareTo(BigDecimal.ZERO) < 0 ? ("("+$P{NUMBERFORMAT}.toPattern()+")") : $P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 				<reportElement stretchType="RelativeToTallestObject" x="330" y="0" width="75" height="14" uuid="b9cb19fe-6b55-4c0c-9089-a3c3c8e88223"/>
@@ -494,7 +500,8 @@
 					<font fontName="DejaVu Sans" size="8"/>
 					<paragraph lineSpacing="1_1_2"/>
 				</textElement>
-				<textFieldExpression><![CDATA[$F{debit}.compareTo(BigDecimal.ZERO) < 0 ? "(" + $P{NUMBERFORMAT}.format($F{debit}.abs()) + ")" : $P{NUMBERFORMAT}.format($F{debit})]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$F{debit}.compareTo(BigDecimal.ZERO) < 0 ? $F{debit}.abs() : $F{debit}]]></textFieldExpression>
+				<patternExpression><![CDATA[$F{debit}.compareTo(BigDecimal.ZERO) < 0 ? ("("+$P{NUMBERFORMAT}.toPattern()+")") : $P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 				<reportElement stretchType="RelativeToTallestObject" x="480" y="0" width="75" height="14" uuid="50a77f9b-8c48-4f56-837c-590c02bf0166"/>
@@ -503,7 +510,8 @@
 					<font fontName="DejaVu Sans" size="8"/>
 					<paragraph lineSpacing="1_1_2"/>
 				</textElement>
-				<textFieldExpression><![CDATA[$V{SUM}.compareTo(BigDecimal.ZERO) < 0 ? "(" + $P{NUMBERFORMAT}.format($V{SUM}.abs()) + ")" : $P{NUMBERFORMAT}.format($V{SUM})]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$V{SUM}.compareTo(BigDecimal.ZERO) < 0 ? $V{SUM}.abs() : $V{SUM}]]></textFieldExpression>
+				<patternExpression><![CDATA[$V{SUM}.compareTo(BigDecimal.ZERO) < 0 ? ("("+$P{NUMBERFORMAT}.toPattern()+")") : $P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 		</band>
 	</detail>
@@ -516,7 +524,8 @@
 					<font fontName="DejaVu Sans" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
 					<paragraph lineSpacing="Single"/>
 				</textElement>
-				<textFieldExpression><![CDATA[$V{totalInitialBalance}.compareTo(BigDecimal.ZERO) < 0 ? "(" + $P{NUMBERFORMAT}.format($V{totalInitialBalance}.abs()) + ")" : $P{NUMBERFORMAT}.format($V{totalInitialBalance})]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$V{totalInitialBalance}.compareTo(BigDecimal.ZERO) < 0 ? $V{totalInitialBalance}.abs() : $V{totalInitialBalance}]]></textFieldExpression>
+				<patternExpression><![CDATA[$V{totalInitialBalance}.compareTo(BigDecimal.ZERO) < 0 ? ("("+$P{NUMBERFORMAT}.toPattern()+")") : $P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<staticText>
 				<reportElement x="235" y="13" width="210" height="14" isPrintWhenDetailOverflows="true" forecolor="#000000" backcolor="#FFFFFF" uuid="62499066-a0e4-46b3-bd28-3e611823c5dd"/>
@@ -546,7 +555,8 @@
 					<font fontName="DejaVu Sans" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
 					<paragraph lineSpacing="Single"/>
 				</textElement>
-				<textFieldExpression><![CDATA[$V{totalBalance}.compareTo(BigDecimal.ZERO) < 0 ? "(" + $P{NUMBERFORMAT}.format($V{totalBalance}.abs()) + ")" : $P{NUMBERFORMAT}.format($V{totalBalance})]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$V{totalBalance}.compareTo(BigDecimal.ZERO) < 0 ? $V{totalBalance}.abs() : $V{totalBalance}]]></textFieldExpression>
+				<patternExpression><![CDATA[$V{totalBalance}.compareTo(BigDecimal.ZERO) < 0 ? ("("+$P{NUMBERFORMAT}.toPattern()+")") : $P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<line>
 				<reportElement x="235" y="57" width="320" height="3" uuid="382bf123-c27c-426b-a320-1a2df3a239e9"/>
--- a/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalExcel.jrxml	Tue Aug 01 13:42:56 2017 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalExcel.jrxml	Wed Jul 26 17:24:11 2017 -0400
@@ -5,6 +5,7 @@
 	<property name="ireport.zoom" value="1.5"/>
 	<property name="ireport.x" value="0"/>
 	<property name="ireport.y" value="0"/>
+	<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
 	<import value="net.sf.jasperreports.engine.*"/>
 	<import value="java.util.*"/>
 	<import value="net.sf.jasperreports.engine.data.*"/>
@@ -260,6 +261,7 @@
 					<font size="10"/>
 				</textElement>
 				<textFieldExpression><![CDATA[$F{AMTACCTDR}]]></textFieldExpression>
+				<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<textField pattern="#,##0.00" isBlankWhenNull="true">
 				<reportElement key="textField" x="875" y="0" width="100" height="16" uuid="3fce8a4b-e1d8-45f8-916b-950c7afaff04"/>
@@ -273,6 +275,7 @@
 					<font size="10"/>
 				</textElement>
 				<textFieldExpression><![CDATA[$F{AMTACCTCR}]]></textFieldExpression>
+				<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<textField isBlankWhenNull="false">
 				<reportElement key="textField-23" x="0" y="0" width="39" height="16" uuid="3d3e32f3-b500-468b-bb60-90d7320f131f"/>
--- a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml	Tue Aug 01 13:42:56 2017 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml	Wed Jul 26 17:24:11 2017 -0400
@@ -238,6 +238,7 @@
 						<font size="8"/>
 					</textElement>
 					<textFieldExpression><![CDATA[$V{totalQty}]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement x="1100" y="0" width="100" height="16" uuid="7a0dc66f-1e1d-4dba-81b7-016d70c9bc69"/>
@@ -246,6 +247,7 @@
 						<font size="8"/>
 					</textElement>
 					<textFieldExpression><![CDATA[$V{totalAmt}]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement x="1200" y="0" width="100" height="16" uuid="6601ab30-4e55-4798-af99-86ac9a0360fa"/>
@@ -254,6 +256,7 @@
 						<font size="8"/>
 					</textElement>
 					<textFieldExpression><![CDATA[$V{totalCost}]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement x="1300" y="0" width="100" height="16" uuid="a95e6755-6bce-4449-8f95-ea982b8a5bef"/>
@@ -262,6 +265,7 @@
 						<font size="8"/>
 					</textElement>
 					<textFieldExpression><![CDATA[$V{totalProfit}]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement x="1400" y="0" width="50" height="16" uuid="a53f8c90-bfaa-4ce7-94dd-033ca0e10da6"/>
@@ -269,7 +273,8 @@
 					<textElement textAlignment="Right">
 						<font size="8"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{totalMargin}!=null)?$P{NUMBERFORMAT}.format($V{totalMargin}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{totalMargin}!=null)?$V{totalMargin}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement x="1450" y="0" width="50" height="16" uuid="e9aaf868-723e-4e05-80df-27c71e96d54e"/>
@@ -278,6 +283,7 @@
 						<font size="8"/>
 					</textElement>
 					<textFieldExpression><![CDATA[$V{totalWeight}]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<staticText>
 					<reportElement x="800" y="0" width="100" height="16" uuid="a30644d0-a0c3-4836-960a-5fb330742476"/>
@@ -743,6 +749,7 @@
 					<font size="8"/>
 				</textElement>
 				<textFieldExpression><![CDATA[$F{QTY}]]></textFieldExpression>
+				<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="false">
 				<reportElement key="textField-8" stretchType="RelativeToBandHeight" x="1100" y="0" width="100" height="13" uuid="09f0aa65-d2eb-4ee4-a68f-a368840c5904"/>
@@ -756,6 +763,7 @@
 					<font size="8"/>
 				</textElement>
 				<textFieldExpression><![CDATA[$F{AMOUNT}]]></textFieldExpression>
+				<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="false">
 				<reportElement key="textField-9" stretchType="RelativeToBandHeight" x="1200" y="0" width="100" height="13" uuid="485e1ead-f9d9-4b7e-9b69-de548e006df9"/>
@@ -769,6 +777,7 @@
 					<font size="8"/>
 				</textElement>
 				<textFieldExpression><![CDATA[$F{COST}]]></textFieldExpression>
+				<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="false">
 				<reportElement key="textField-10" stretchType="RelativeToBandHeight" x="1300" y="0" width="100" height="13" uuid="98e73443-30bf-4370-9c33-c03f18722331"/>
@@ -782,6 +791,7 @@
 					<font size="8"/>
 				</textElement>
 				<textFieldExpression><![CDATA[$F{PROFIT}]]></textFieldExpression>
+				<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="false">
 				<reportElement key="textField-11" stretchType="RelativeToBandHeight" x="1400" y="0" width="50" height="13" uuid="3d0815a2-b760-434e-bb63-ec856afae135"/>
@@ -795,6 +805,7 @@
 					<font size="8"/>
 				</textElement>
 				<textFieldExpression><![CDATA[$F{MARGIN}]]></textFieldExpression>
+				<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
 				<reportElement key="textField-12" stretchType="RelativeToBandHeight" x="1450" y="0" width="50" height="13" uuid="d9693cbb-9d69-418a-becf-e47130fcc0a3"/>
@@ -808,6 +819,7 @@
 					<font size="8"/>
 				</textElement>
 				<textFieldExpression><![CDATA[$F{WEIGHT}]]></textFieldExpression>
+				<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
 				<reportElement key="textField-14" stretchType="RelativeToBandHeight" x="1500" y="0" width="100" height="13" uuid="79490dd4-4d29-4e5a-9301-aeb669776a2d"/>
--- a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesXLS.jrxml	Tue Aug 01 13:42:56 2017 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesXLS.jrxml	Wed Jul 26 17:24:11 2017 -0400
@@ -366,6 +366,7 @@
 					<font size="8"/>
 				</textElement>
 				<textFieldExpression><![CDATA[$F{QTY}]]></textFieldExpression>
+				<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="false">
 				<reportElement key="textField-8" stretchType="RelativeToBandHeight" x="1520" y="0" width="100" height="13" uuid="b230f45b-0364-40cb-ae4d-72fc46e0a1c4"/>
@@ -379,6 +380,7 @@
 					<font size="8"/>
 				</textElement>
 				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{UNITPRICE}]]></textFieldExpression>
+				<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="false">
 				<reportElement key="textField-8" stretchType="RelativeToBandHeight" x="1620" y="0" width="100" height="13"/>
@@ -392,6 +394,7 @@
 					<font size="8"/>
 				</textElement>
 				<textFieldExpression><![CDATA[$F{AMOUNT}]]></textFieldExpression>
+				<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 		</band>
 	</detail>
--- a/src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartnerJR.jrxml	Tue Aug 01 13:42:56 2017 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartnerJR.jrxml	Wed Jul 26 17:24:11 2017 -0400
@@ -2,6 +2,7 @@
 <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="ReportWarehousePartnerJR" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" uuid="7761643a-888d-4085-bd65-842b0ef65ab1">
 	<property name="ireport.scriptlethandling" value="0"/>
 	<property name="ireport.encoding" value="UTF-8"/>
+	<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
 	<import value="net.sf.jasperreports.engine.*"/>
 	<import value="java.util.*"/>
 	<import value="net.sf.jasperreports.engine.data.*"/>
@@ -318,7 +319,8 @@
 					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 				</box>
 				<textElement textAlignment="Right" verticalAlignment="Middle"/>
-				<textFieldExpression><![CDATA[($F{MOVEMENTQTY}!=null)?$P{NUMBERFORMAT}.format($F{MOVEMENTQTY}):new String(" ")]]></textFieldExpression>
+				<textFieldExpression><![CDATA[($F{MOVEMENTQTY}!=null)?$F{MOVEMENTQTY}:BigDecimal.ZERO]]></textFieldExpression>
+				<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
 				<reportElement key="textField-3" style="Detail_Line" stretchType="RelativeToBandHeight" x="213" y="0" width="37" height="16" uuid="4250c75d-2558-4b47-a8c7-87583022251f"/>
@@ -384,7 +386,8 @@
 					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 				</box>
 				<textElement textAlignment="Right" verticalAlignment="Middle"/>
-				<textFieldExpression><![CDATA[($F{WEIGHT}!=null)?$P{NUMBERFORMAT}.format($F{WEIGHT}):new String(" ")]]></textFieldExpression>
+				<textFieldExpression><![CDATA[($F{WEIGHT}!=null)?$F{WEIGHT}:BigDecimal.ZERO]]></textFieldExpression>
+				<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 			</textField>
 			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
 				<reportElement key="textField-9" style="Detail_Line" stretchType="RelativeToBandHeight" x="395" y="0" width="22" height="16" uuid="6059b44e-4351-4224-b3ea-01f292055faa"/>
--- a/src/org/openbravo/erpCommon/ad_reports/WeightDimensionalComparative.jrxml	Tue Aug 01 13:42:56 2017 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/WeightDimensionalComparative.jrxml	Wed Jul 26 17:24:11 2017 -0400
@@ -5,6 +5,7 @@
 	<property name="ireport.zoom" value="3.138428376721006"/>
 	<property name="ireport.x" value="1671"/>
 	<property name="ireport.y" value="105"/>
+	<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
 	<import value="net.sf.jasperreports.engine.*"/>
 	<import value="java.util.*"/>
 	<import value="net.sf.jasperreports.engine.data.*"/>
@@ -618,7 +619,8 @@
 					<textElement textAlignment="Right">
 						<font size="8"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHT_TOTAL}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_TOTAL}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_TOTAL}!=null)?$V{WEIGHT_TOTAL}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<staticText>
 					<reportElement key="staticText-15" style="Report_Data_Label" x="206" y="2" width="34" height="18" uuid="afd632e9-9484-4a22-aba9-f66bc0c0820c"/>
@@ -645,7 +647,8 @@
 					<textElement textAlignment="Right">
 						<font size="8"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHTREF_TOTAL}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHTREF_TOTAL}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHTREF_TOTAL}!=null)?$V{WEIGHTREF_TOTAL}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Report" isBlankWhenNull="false">
 					<reportElement key="textField-101" style="Total_Field" x="240" y="2" width="65" height="18" uuid="68140b4e-44b3-454c-8c40-fe749fd68e37"/>
@@ -659,7 +662,8 @@
 					<textElement textAlignment="Right">
 						<font size="8"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_TOTAL}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_TOTAL}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_TOTAL}!=null)?$V{CONVAMOUNT_TOTAL}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-102" style="Total_Field" x="320" y="2" width="65" height="18" uuid="4c63afb6-d130-45af-80d7-5a552e6f0909"/>
@@ -673,7 +677,8 @@
 					<textElement textAlignment="Right">
 						<font size="8"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_TOTAL}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNTREF_TOTAL}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_TOTAL}!=null)?$V{CONVAMOUNTREF_TOTAL}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-103" style="Total_Field" x="400" y="2" width="25" height="18" uuid="2dd981de-73de-485c-bdd2-9bc10d5d3b95"/>
@@ -687,7 +692,8 @@
 					<textElement textAlignment="Right">
 						<font size="8"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_T}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMT_PCT_T}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_T}!=null)?$V{CONVAMT_PCT_T}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-100" style="Total_Field" x="630" y="2" width="65" height="18" uuid="ce3b0947-5304-43aa-bb96-3d51faf27070"/>
@@ -701,7 +707,8 @@
 					<textElement textAlignment="Right">
 						<font size="8"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTYREF_TOTAL}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_TOTAL}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTYREF_TOTAL}!=null)?$V{QTYREF_TOTAL}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-100" style="Total_Field" x="565" y="2" width="65" height="18" uuid="4351191d-1f34-4864-b99a-1c2a66f70614"/>
@@ -715,7 +722,8 @@
 					<textElement textAlignment="Right">
 						<font size="8"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_TOTAL}!=null)?$P{NUMBERFORMAT}.format($V{QTY_TOTAL}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_TOTAL}!=null)?$V{QTY_TOTAL}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isBlankWhenNull="true">
 					<reportElement key="textField-104" style="Detail_Header" mode="Opaque" x="0" y="2" width="15" height="18" uuid="eab948e5-487f-4d0a-a036-5f59c483f6b5"/>
@@ -934,7 +942,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_SUM1}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM1}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM1}!=null)?$V{QTY_SUM1}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="425" y="0" width="65" height="18" uuid="62a514f7-ac24-4ba8-a6ae-a3a5b36dc9bc"/>
@@ -947,7 +956,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM1}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM1}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM1}!=null)?$V{WEIGHT_SUM1}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="490" y="0" width="75" height="18" uuid="bc47fc03-0472-4664-8284-de8f5453eb2b"/>
@@ -960,7 +970,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM1}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHTREF_SUM1}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM1}!=null)?$V{WEIGHTREF_SUM1}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="630" y="0" width="65" height="18" uuid="1b3f2445-b09b-497d-b3ea-b4e65c05ae4e">
@@ -975,7 +986,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTYREF_SUM1}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM1}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTYREF_SUM1}!=null)?$V{QTYREF_SUM1}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="695" y="0" width="35" height="18" uuid="3a696c3f-9cdd-4d56-88fa-a8e068b55feb">
@@ -990,7 +1002,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_PCT_1}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_1}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_PCT_1}!=null)?$V{QTY_PCT_1}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-12" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="240" y="0" width="65" height="18" uuid="3247444c-be0a-4db5-a27d-b0e5ddb18b47"/>
@@ -1003,7 +1016,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM1}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM1}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM1}!=null)?$V{CONVAMOUNT_SUM1}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-13" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="320" y="0" width="65" height="18" uuid="b0bd86bd-819b-4043-8e72-ad85b11fe4db"/>
@@ -1016,7 +1030,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM1}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNTREF_SUM1}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM1}!=null)?$V{CONVAMOUNTREF_SUM1}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-14" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="400" y="0" width="25" height="18" uuid="e1ac5ff3-4f2c-4a1d-90f7-7e78b647e885"/>
@@ -1029,7 +1044,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_1}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMT_PCT_1}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_1}!=null)?$V{CONVAMT_PCT_1}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-114" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="385" y="0" width="15" height="18" uuid="7a94b13a-ddf6-41fe-8eb4-dd476aecdf04"/>
@@ -1094,7 +1110,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_SUM2}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM2}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM2}!=null)?$V{QTY_SUM2}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL2" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level2_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="425" y="0" width="65" height="18" uuid="97b3e338-44f2-4a10-8c26-a0cf803434d8"/>
@@ -1107,7 +1124,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM2}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM2}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM2}!=null)?$V{WEIGHT_SUM2}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL2" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level2_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="490" y="0" width="75" height="18" uuid="e1a38f61-9fc1-49a0-bb2e-e01e0e79db33"/>
@@ -1120,7 +1138,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM2}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHTREF_SUM2}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM2}!=null)?$V{WEIGHTREF_SUM2}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL2" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level2_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="630" y="0" width="65" height="18" uuid="1b0ab5a5-430e-44e8-bacb-ee0a61a10adc">
@@ -1135,7 +1154,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTYREF_SUM2}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM2}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTYREF_SUM2}!=null)?$V{QTYREF_SUM2}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL2" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level2_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="695" y="0" width="35" height="18" uuid="d1c8bf20-bf05-48da-b268-85609070c134">
@@ -1150,7 +1170,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_PCT_2}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_2}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_PCT_2}!=null)?$V{QTY_PCT_2}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL2" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-15" style="Level2_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="240" y="0" width="65" height="18" uuid="ca8687b0-9bcd-4646-b93b-9be8b5dd3eeb"/>
@@ -1163,7 +1184,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM2}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM2}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM2}!=null)?$V{CONVAMOUNT_SUM2}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL2" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-16" style="Level2_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="320" y="0" width="65" height="18" uuid="80e70109-2cf1-4f66-9b4d-3370db0dc4c1"/>
@@ -1176,7 +1198,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM2}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNTREF_SUM2}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM2}!=null)?$V{CONVAMOUNTREF_SUM2}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL2" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-17" style="Level2_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="400" y="0" width="25" height="18" uuid="a97cad08-3136-4865-adc6-e4988fd489f6"/>
@@ -1189,7 +1212,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_2}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMT_PCT_2}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_2}!=null)?$V{CONVAMT_PCT_2}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-42" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="7f430e7b-4fb7-45f4-aee2-473891cbf138"/>
@@ -1267,7 +1291,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_SUM3}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM3}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM3}!=null)?$V{QTY_SUM3}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL3" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level3_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="425" y="0" width="65" height="18" uuid="67c0e3b4-aec8-4941-9f66-e7e1ba6d0534"/>
@@ -1280,7 +1305,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM3}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM3}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM3}!=null)?$V{WEIGHT_SUM3}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL3" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level3_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="490" y="0" width="75" height="18" uuid="da8c01cb-c8d5-4dbb-96b1-0db30d11b7f6"/>
@@ -1293,7 +1319,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM3}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHTREF_SUM3}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM3}!=null)?$V{WEIGHTREF_SUM3}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL3" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level3_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="630" y="0" width="65" height="18" uuid="6fe42723-1579-4076-8a9f-e4a354df3fc3">
@@ -1308,7 +1335,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTYREF_SUM3}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM3}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTYREF_SUM3}!=null)?$V{QTYREF_SUM3}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL3" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level3_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="695" y="0" width="35" height="18" uuid="f0d3a9e8-0fcd-46c0-ba01-00b84551ac42">
@@ -1323,7 +1351,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_PCT_3}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_3}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_PCT_3}!=null)?$V{QTY_PCT_3}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL3" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-18" style="Level3_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="240" y="0" width="65" height="18" uuid="c0a744f8-516f-46d7-bba3-ebf2f6328f6a"/>
@@ -1336,7 +1365,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM3}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM3}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM3}!=null)?$V{CONVAMOUNT_SUM3}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL3" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-19" style="Level3_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="320" y="0" width="65" height="18" uuid="321f4fe7-001f-4da6-83e1-f46bc0cf950a"/>
@@ -1349,7 +1379,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM3}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNTREF_SUM3}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM3}!=null)?$V{CONVAMOUNTREF_SUM3}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL3" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-20" style="Level3_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="400" y="0" width="25" height="18" uuid="6c502530-52bd-4f78-b275-8c9ca4979969"/>
@@ -1362,7 +1393,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_3}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMT_PCT_3}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_3}!=null)?$V{CONVAMT_PCT_3}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-43" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="159ebab5-da8f-41e8-9266-c709063ab5b4"/>
@@ -1453,7 +1485,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_SUM4}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM4}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM4}!=null)?$V{QTY_SUM4}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL4" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level4_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="425" y="0" width="65" height="18" uuid="0f60c6a2-6cfd-461e-9e82-a041141253de"/>
@@ -1466,7 +1499,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM4}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM4}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM4}!=null)?$V{WEIGHT_SUM4}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL4" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level4_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="490" y="0" width="75" height="18" uuid="699bf908-3b75-4452-a3b9-11ff11edaf70"/>
@@ -1479,7 +1513,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM4}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHTREF_SUM4}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM4}!=null)?$V{WEIGHTREF_SUM4}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL4" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level4_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="630" y="0" width="65" height="18" uuid="eaf0d4db-0e6e-40d3-9543-83979298c39f">
@@ -1494,7 +1529,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTYREF_SUM4}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM4}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTYREF_SUM4}!=null)?$V{QTYREF_SUM4}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL4" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level4_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="695" y="0" width="35" height="18" uuid="acc09c0c-c739-49c9-8ca5-3ec2a7de52a5">
@@ -1509,7 +1545,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_PCT_4}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_4}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_PCT_4}!=null)?$V{QTY_PCT_4}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL4" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-21" style="Level4_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="240" y="0" width="65" height="18" uuid="16bc351e-01cb-4b49-8661-4c703b9c6a38"/>
@@ -1522,7 +1559,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM4}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM4}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM4}!=null)?$V{CONVAMOUNT_SUM4}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL4" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-22" style="Level4_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="320" y="0" width="65" height="18" uuid="180c84ed-2a42-4bf3-af6e-5c1d825bcd04"/>
@@ -1535,7 +1573,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM4}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNTREF_SUM4}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM4}!=null)?$V{CONVAMOUNTREF_SUM4}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL4" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-23" style="Level4_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="400" y="0" width="25" height="18" uuid="99874d96-ccb6-4637-b986-bf1c465b91e8"/>
@@ -1548,7 +1587,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_4}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMT_PCT_4}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_4}!=null)?$V{CONVAMT_PCT_4}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-44" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="e1520ad1-5fb5-43e4-b569-4c9ee98f8972"/>
@@ -1652,7 +1692,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_SUM5}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM5}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM5}!=null)?$V{QTY_SUM5}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL5" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level5_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="425" y="0" width="65" height="18" uuid="9e403463-bdb0-4fec-93a5-209d4329beb3"/>
@@ -1665,7 +1706,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM5}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM5}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM5}!=null)?$V{WEIGHT_SUM5}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL5" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level5_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="490" y="0" width="75" height="18" uuid="9a40649d-8118-403c-9882-9ea9ba6ee728"/>
@@ -1678,7 +1720,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM5}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHTREF_SUM5}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM5}!=null)?$V{WEIGHTREF_SUM5}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL5" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level5_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="630" y="0" width="65" height="18" uuid="ac4c4ec6-1d4b-4a00-b607-ccc40c345adb">
@@ -1693,7 +1736,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTYREF_SUM5}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM5}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTYREF_SUM5}!=null)?$V{QTYREF_SUM5}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL5" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level5_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="695" y="0" width="35" height="18" uuid="52f7369d-68a3-4063-8991-eb30ef79f512">
@@ -1708,7 +1752,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_PCT_5}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_5}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_PCT_5}!=null)?$V{QTY_PCT_5}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL5" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-24" style="Level5_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="240" y="0" width="65" height="18" uuid="01b5500b-d067-4761-a1b8-448838e4360e"/>
@@ -1721,7 +1766,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM5}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM5}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM5}!=null)?$V{CONVAMOUNT_SUM5}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL5" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-25" style="Level5_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="320" y="0" width="65" height="18" uuid="77674dac-c9ed-4fbc-b2d5-a5b62217696a"/>
@@ -1734,7 +1780,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM5}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNTREF_SUM5}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM5}!=null)?$V{CONVAMOUNTREF_SUM5}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL5" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-26" style="Level5_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="400" y="0" width="25" height="18" uuid="5438ed71-54d7-4dd6-9795-f599f113a223"/>
@@ -1747,7 +1794,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_5}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMT_PCT_5}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_5}!=null)?$V{CONVAMT_PCT_5}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-45" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="8290c6e0-cfad-4fec-81f5-84b4867d7beb"/>
@@ -1864,7 +1912,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_SUM6}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM6}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM6}!=null)?$V{QTY_SUM6}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL6" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level6_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="425" y="0" width="65" height="18" uuid="9a1ab029-9cb8-43bc-aea1-b48e7a31cc6f"/>
@@ -1877,7 +1926,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM6}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM6}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM6}!=null)?$V{WEIGHT_SUM6}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL6" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level6_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="490" y="0" width="75" height="18" uuid="d3db1934-2534-4621-80aa-a6c758b51fb3"/>
@@ -1890,7 +1940,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM6}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHTREF_SUM6}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM6}!=null)?$V{WEIGHTREF_SUM6}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL6" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level6_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="630" y="0" width="65" height="18" uuid="ffab6a79-623a-42e2-b1b0-a8117e5fc9ec">
@@ -1905,7 +1956,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTYREF_SUM6}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM6}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTYREF_SUM6}!=null)?$V{QTYREF_SUM6}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL6" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level6_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="695" y="0" width="35" height="18" uuid="74cc6d9a-1f5d-4151-b8cf-cc87c7acddcb">
@@ -1920,7 +1972,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_PCT_6}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_6}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_PCT_6}!=null)?$V{QTY_PCT_6}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL6" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-27" style="Level6_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="240" y="0" width="65" height="18" uuid="a761cc9c-8e7c-437e-86b6-e92b8886750e"/>
@@ -1933,7 +1986,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM6}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM6}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM6}!=null)?$V{CONVAMOUNT_SUM6}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL6" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-28" style="Level6_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="320" y="0" width="65" height="18" uuid="2f810e71-3fe6-48eb-8bf7-e9442426247e"/>
@@ -1946,7 +2000,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM6}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNTREF_SUM6}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM6}!=null)?$V{CONVAMOUNTREF_SUM6}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL6" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-29" style="Level6_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="400" y="0" width="25" height="18" uuid="884fc74b-d0f8-4b39-99b9-b17e4ba91a90"/>
@@ -1959,7 +2014,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_6}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMT_PCT_6}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_6}!=null)?$V{CONVAMT_PCT_6}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-46" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="0047984f-95d9-4a05-9183-c4eaad8604f8"/>
@@ -2089,7 +2145,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_SUM7}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM7}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM7}!=null)?$V{QTY_SUM7}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL7" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level7_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="425" y="0" width="65" height="18" uuid="db46a7fe-ad38-44b6-8414-8c3f46b58405"/>
@@ -2102,7 +2159,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM7}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM7}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM7}!=null)?$V{WEIGHT_SUM7}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL7" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level7_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="490" y="0" width="75" height="18" uuid="4c028599-0a84-4731-9cb4-6d3a137638e0"/>
@@ -2115,7 +2173,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM7}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHTREF_SUM7}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM7}!=null)?$V{WEIGHTREF_SUM7}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL7" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level7_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="630" y="0" width="65" height="18" uuid="98ed6409-e487-4ce6-90a1-cf59f40f6303">
@@ -2130,7 +2189,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTYREF_SUM7}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM7}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTYREF_SUM7}!=null)?$V{QTYREF_SUM7}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL7" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level7_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="695" y="0" width="35" height="18" uuid="1ccb3156-d2a4-425d-8283-5d64856fa653">
@@ -2145,7 +2205,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_PCT_7}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_7}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_PCT_7}!=null)?$V{QTY_PCT_7}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL7" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-30" style="Level7_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="240" y="0" width="65" height="18" uuid="736436d8-f882-4e9b-8863-34796de93624"/>
@@ -2158,7 +2219,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM7}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM7}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM7}!=null)?$V{CONVAMOUNT_SUM7}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL7" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-31" style="Level7_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="320" y="0" width="65" height="18" uuid="f1a3c9d7-bf0d-4e9a-8e43-5b925470322b"/>
@@ -2171,7 +2233,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM7}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNTREF_SUM7}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM7}!=null)?$V{CONVAMOUNTREF_SUM7}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL7" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-32" style="Level7_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="400" y="0" width="25" height="18" uuid="26081681-4bbb-49ea-a7c5-21c9033fb493"/>
@@ -2184,7 +2247,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_7}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMT_PCT_7}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_7}!=null)?$V{CONVAMT_PCT_7}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-47" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="cc3998ba-c42a-4ee3-9777-fcd9f72a6802"/>
@@ -2327,7 +2391,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_SUM8}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM8}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM8}!=null)?$V{QTY_SUM8}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL8" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level8_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="425" y="0" width="65" height="18" uuid="77c192a6-8d63-426b-8c6e-57e15a73938d"/>
@@ -2340,7 +2405,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM8}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM8}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM8}!=null)?$V{WEIGHT_SUM8}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL8" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level8_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="490" y="0" width="75" height="18" uuid="044e5dee-edf7-47a2-a1ac-f63b39e1f8e1"/>
@@ -2353,7 +2419,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM8}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHTREF_SUM8}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM8}!=null)?$V{WEIGHTREF_SUM8}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL8" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level8_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="630" y="0" width="65" height="18" uuid="52dc832d-8943-409d-adf6-6ed9ffd4186d">
@@ -2368,7 +2435,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTYREF_SUM8}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM8}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTYREF_SUM8}!=null)?$V{QTYREF_SUM8}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL8" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level8_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="695" y="0" width="35" height="18" uuid="74fc1b9c-408c-4604-b36f-2f5780d83d88">
@@ -2383,7 +2451,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_PCT_8}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_8}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_PCT_8}!=null)?$V{QTY_PCT_8}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL8" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-33" style="Level8_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="240" y="0" width="65" height="18" uuid="eb3b032d-7f2c-4cbc-96de-9cb67ad968c1"/>
@@ -2396,7 +2465,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM8}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM8}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM8}!=null)?$V{CONVAMOUNT_SUM8}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL8" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-34" style="Level8_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="320" y="0" width="65" height="18" uuid="c944e2c4-28a1-4b89-9bd7-a7ca0cffc431"/>
@@ -2409,7 +2479,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM8}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNTREF_SUM8}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM8}!=null)?$V{CONVAMOUNTREF_SUM8}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL8" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-35" style="Level8_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="400" y="0" width="25" height="18" uuid="164aae45-edac-446a-a46f-c2e2e0ebbf74"/>
@@ -2422,7 +2493,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_8}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMT_PCT_8}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_8}!=null)?$V{CONVAMT_PCT_8}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-48" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="10e81893-c577-4c4b-969d-333650496d9f"/>
@@ -2578,7 +2650,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_SUM9}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM9}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM9}!=null)?$V{QTY_SUM9}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL9" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level9_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="425" y="0" width="65" height="18" uuid="1a6554fe-484a-4469-9154-352bc12b9ef9"/>
@@ -2591,7 +2664,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM9}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM9}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM9}!=null)?$V{WEIGHT_SUM9}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL9" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level9_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="490" y="0" width="75" height="18" uuid="b1ad7390-70c1-4a24-af6e-4c75699dbaef"/>
@@ -2604,7 +2678,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM9}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHTREF_SUM9}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM9}!=null)?$V{WEIGHTREF_SUM9}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL9" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level9_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="630" y="0" width="65" height="18" uuid="9f41553b-a524-4875-abe4-a7d81f08bd98">
@@ -2619,7 +2694,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTYREF_SUM9}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM9}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTYREF_SUM9}!=null)?$V{QTYREF_SUM9}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL9" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level9_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="695" y="0" width="35" height="18" uuid="4d7da0fb-976f-45b6-98e2-3d67331ed2a2">
@@ -2634,7 +2710,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_PCT_9}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_9}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_PCT_9}!=null)?$V{QTY_PCT_9}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL9" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-36" style="Level9_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="240" y="0" width="65" height="18" uuid="52862d9a-4742-42ab-9322-cf4301e374fa"/>
@@ -2647,7 +2724,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM9}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM9}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM9}!=null)?$V{CONVAMOUNT_SUM9}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL9" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-37" style="Level9_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="320" y="0" width="65" height="18" uuid="62eab7f8-3e10-47c4-a89e-1071ccd26a51"/>
@@ -2660,7 +2738,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM9}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNTREF_SUM9}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM9}!=null)?$V{CONVAMOUNTREF_SUM9}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL9" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-38" style="Level9_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="400" y="0" width="25" height="18" uuid="479e73dc-9e28-4a93-a79d-81b31fbc2a00"/>
@@ -2673,7 +2752,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_9}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMT_PCT_9}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_9}!=null)?$V{CONVAMT_PCT_9}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-49" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="ead2e8cc-cb0e-4b86-bcd3-6a4b35d9215c"/>
@@ -2842,7 +2922,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_SUM10}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM10}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM10}!=null)?$V{QTY_SUM10}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL10" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level10_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="425" y="0" width="65" height="18" uuid="6e154a06-403d-416d-96d0-9d5736d7c5b5"/>
@@ -2855,7 +2936,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM10}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM10}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM10}!=null)?$V{WEIGHT_SUM10}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL10" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level10_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="490" y="0" width="75" height="18" uuid="eff6db0a-0a92-4160-bbbf-7ff6ac99b7fe"/>
@@ -2868,7 +2950,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM10}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHTREF_SUM10}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM10}!=null)?$V{WEIGHTREF_SUM10}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL10" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level10_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="630" y="0" width="65" height="18" uuid="e9651ac5-2a17-4bcf-bf27-52440e5c31f2">
@@ -2883,7 +2966,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTYREF_SUM10}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM10}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTYREF_SUM10}!=null)?$V{QTYREF_SUM10}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL10" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level10_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="695" y="0" width="35" height="18" uuid="a84cee38-58c9-4c24-82ea-86d24ce1a25f">
@@ -2898,7 +2982,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_PCT_10}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_10}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_PCT_10}!=null)?$V{QTY_PCT_10}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL10" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-36" style="Level10_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="240" y="0" width="65" height="18" uuid="cd19e9d3-aa92-4a05-83d9-411ad002baed"/>
@@ -2911,7 +2996,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM10}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM10}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM10}!=null)?$V{CONVAMOUNT_SUM10}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL10" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-37" style="Level10_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="320" y="0" width="65" height="18" uuid="857a7113-0928-4d2f-9040-e5e96f1cca35"/>
@@ -2924,7 +3010,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM10}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNTREF_SUM10}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM10}!=null)?$V{CONVAMOUNTREF_SUM10}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL10" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-38" style="Level10_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="400" y="0" width="25" height="18" uuid="d59916dd-ec3a-47e8-a3a5-6130eb787a57"/>
@@ -2937,7 +3024,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_10}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMT_PCT_10}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_10}!=null)?$V{CONVAMT_PCT_10}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-49" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="c3dcec92-2ba3-43b9-8d6a-a1e5f5364402"/>
@@ -3119,7 +3207,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_SUM11}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM11}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM11}!=null)?$V{QTY_SUM11}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL11" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level11_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="425" y="0" width="65" height="18" uuid="4da93268-487d-45ea-951d-84df29b65709"/>
@@ -3132,7 +3221,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM11}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM11}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM11}!=null)?$V{WEIGHT_SUM11}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL11" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level11_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="490" y="0" width="75" height="18" uuid="806e3436-f447-4b00-8c04-6490812ad2b0"/>
@@ -3145,7 +3235,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM11}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHTREF_SUM11}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHTREF_SUM11}!=null)?$V{WEIGHTREF_SUM11}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL11" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level11_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="630" y="0" width="65" height="18" uuid="1b07fc76-5250-4620-baf4-4e643ffab56f">
@@ -3160,7 +3251,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTYREF_SUM11}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM11}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTYREF_SUM11}!=null)?$V{QTYREF_SUM11}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL11" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level11_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="695" y="0" width="35" height="18" uuid="904431fa-12c5-4ae5-9a7c-bf1934a56266">
@@ -3175,7 +3267,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{QTY_PCT_11}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_11}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_PCT_11}!=null)?$V{QTY_PCT_11}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL11" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-36" style="Level11_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="240" y="0" width="65" height="18" uuid="5200c9df-a32b-4866-b113-62bfdb015544"/>
@@ -3188,7 +3281,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM11}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM11}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM11}!=null)?$V{CONVAMOUNT_SUM11}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL11" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-37" style="Level11_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="320" y="0" width="65" height="18" uuid="6c74c84b-808c-4243-b158-203cd40df59e"/>
@@ -3201,7 +3295,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM11}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNTREF_SUM11}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNTREF_SUM11}!=null)?$V{CONVAMOUNTREF_SUM11}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL11" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-38" style="Level11_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="400" y="0" width="25" height="18" uuid="65f4f5a2-3728-45c0-9572-a9fb1c6c9863"/>
@@ -3214,7 +3309,8 @@
 					<textElement textAlignment="Right">
 						<font size="8" isBold="false"/>
 					</textElement>
-					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_11}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMT_PCT_11}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMT_PCT_11}!=null)?$V{CONVAMT_PCT_11}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-49" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="9803b151-2243-4895-a4e3-7c59daad922e"/>
--- a/src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml	Tue Aug 01 13:42:56 2017 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml	Wed Jul 26 17:24:11 2017 -0400
@@ -5,6 +5,7 @@
 	<property name="ireport.zoom" value="11.918176537727245"/>
 	<property name="ireport.x" value="7995"/>
 	<property name="ireport.y" value="1617"/>
+	<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
 	<import value="net.sf.jasperreports.engine.*"/>
 	<import value="java.util.*"/>
 	<import value="net.sf.jasperreports.engine.data.*"/>
@@ -344,7 +345,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{WEIGHT_TOTAL}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_TOTAL}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_TOTAL}!=null)? $V{WEIGHT_TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<staticText>
 					<reportElement key="staticText-9" style="Report_Data_Label" x="395" y="2" width="50" height="18" uuid="7bd179a8-e59c-44bc-8274-975a56fc9575"/>
@@ -367,7 +369,7 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_TOTAL}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_TOTAL}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_TOTAL}!=null)?$V{CONVAMOUNT_TOTAL}:BigDecimal.ZERO]]></textFieldExpression>
 				</textField>
 				<line>
 					<reportElement key="line-5" x="0" y="1" width="729" height="1" uuid="fed11dc1-1ca8-4a42-920b-03df2aa93a5c"/>
@@ -393,7 +395,7 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{QUANTITY_TOTAL}!=null)?$P{NUMBERFORMAT}.format($V{QUANTITY_TOTAL}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QUANTITY_TOTAL}!=null)?$V{QUANTITY_TOTAL}:BigDecimal.ZERO]]></textFieldExpression>
 				</textField>
 				<textField isBlankWhenNull="true">
 					<reportElement key="textField-97" style="Detail_Header" positionType="FixRelativeToBottom" x="0" y="2" width="15" height="18" uuid="4573afd8-2426-48da-b29c-0e225b939b68"/>
@@ -556,7 +558,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{QTY_SUM1}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM1}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM1}!=null)?$V{QTY_SUM1}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level1_Line" stretchType="RelativeToBandHeight" x="560" y="0" width="94" height="18" uuid="40dc9a97-8306-46ef-ab43-e8f84b8093e9"/>
@@ -567,7 +570,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM1}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM1}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM1}!=null)?$V{WEIGHT_SUM1}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-63" style="Level1_Line" stretchType="RelativeToBandHeight" x="445" y="0" width="91" height="18" uuid="e12dfc48-dc23-4f3e-ac15-64a2a106e2bd"/>
@@ -578,7 +582,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM1}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM1}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM1}!=null)?$V{CONVAMOUNT_SUM1}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-79" style="Level1_Line" stretchType="RelativeToBandHeight" x="536" y="0" width="24" height="18" uuid="797a17a0-2925-41b5-8835-535755098e3a"/>
@@ -623,7 +628,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{QTY_SUM2}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM2}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM2}!=null)?$V{QTY_SUM2}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL2" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level2_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="560" y="0" width="94" height="18" uuid="053e7b5d-727b-4c2d-b00a-954dd2089ff8"/>
@@ -634,7 +640,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM2}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM2}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM2}!=null)?$V{WEIGHT_SUM2}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-18" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="8f32ac62-32b2-44e5-8dd8-b2d4e859e4e7"/>
@@ -656,7 +663,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM2}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM2}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM2}!=null)?$V{CONVAMOUNT_SUM2}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL2" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-81" style="Level2_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="536" y="0" width="24" height="18" uuid="374852c2-5354-4f23-9acc-870389656abe"/>
@@ -701,7 +709,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{QTY_SUM3}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM3}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM3}!=null)?$V{QTY_SUM3}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL3" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level3_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="560" y="0" width="94" height="18" uuid="f882bc36-09a0-4f7f-b52b-7202367e5e68"/>
@@ -712,7 +721,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM3}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM3}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM3}!=null)?$V{WEIGHT_SUM3}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-21" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="a0cd3a61-523d-40b1-9abb-5d4748cc6e82"/>
@@ -745,7 +755,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM3}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM3}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM3}!=null)?$V{CONVAMOUNT_SUM3}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-83" style="Level1_Line" stretchType="RelativeToBandHeight" x="536" y="0" width="24" height="18" uuid="374ac65a-737c-4d69-b9d6-0288c5565319"/>
@@ -790,7 +801,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{QTY_SUM4}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM4}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM4}!=null)?$V{QTY_SUM4}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL4" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level4_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="560" y="0" width="94" height="18" uuid="b9fde1ce-b791-46bf-b157-0ea34eee56ae"/>
@@ -801,7 +813,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM4}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM4}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM4}!=null)?$V{WEIGHT_SUM4}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-20" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="917de0f6-1f77-49a4-9a88-075d0060a11d"/>
@@ -845,7 +858,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM4}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM4}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM4}!=null)?$V{CONVAMOUNT_SUM4}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL2" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-85" style="Level2_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="536" y="0" width="24" height="18" uuid="05828413-7620-48c6-b95a-32b02ca0f06c"/>
@@ -890,7 +904,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{QTY_SUM5}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM5}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM5}!=null)?$V{QTY_SUM5}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL5" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level5_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="560" y="0" width="94" height="18" uuid="fc638ea7-8b2c-44c0-a1d3-ee5b32439031"/>
@@ -901,7 +916,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM5}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM5}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM5}!=null)?$V{WEIGHT_SUM5}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-19" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="5f19e3f7-52e2-4061-8641-88eed205e1e4"/>
@@ -956,7 +972,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM5}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM5}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM5}!=null)?$V{CONVAMOUNT_SUM5}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-87" style="Level1_Line" stretchType="RelativeToBandHeight" x="536" y="0" width="24" height="18" uuid="3040921f-78e0-45de-ac76-077b4bc5c01f"/>
@@ -1001,7 +1018,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{QTY_SUM6}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM6}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM6}!=null)?$V{QTY_SUM6}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL6" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level6_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="560" y="0" width="94" height="18" uuid="9f7261fc-9835-4678-90f5-5fc0c73b3757"/>
@@ -1012,7 +1030,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM6}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM6}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM6}!=null)?$V{WEIGHT_SUM6}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-22" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="03503b4d-e444-4c5e-b349-d1c756729cf5"/>
@@ -1078,7 +1097,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM6}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM6}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM6}!=null)?$V{CONVAMOUNT_SUM6}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL2" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-89" style="Level2_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="536" y="0" width="24" height="18" uuid="cb3b1ca4-a5dc-480a-aa1e-f70f75e3c676"/>
@@ -1123,7 +1143,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{QTY_SUM7}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM7}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM7}!=null)?$V{QTY_SUM7}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL7" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level7_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="560" y="0" width="94" height="18" uuid="798f4456-912b-44ea-aeda-31c2dcdbac0d"/>
@@ -1134,7 +1155,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM7}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM7}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM7}!=null)?$V{WEIGHT_SUM7}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-23" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="789f48df-8ca5-45c8-9b04-e297c27378ba"/>
@@ -1211,7 +1233,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM7}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM7}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM7}!=null)?$V{CONVAMOUNT_SUM7}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-91" style="Level1_Line" stretchType="RelativeToBandHeight" x="536" y="0" width="24" height="18" uuid="a4b41c5a-f12b-4b8e-a97d-7eea6afd0751"/>
@@ -1256,7 +1279,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{QTY_SUM8}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM8}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM8}!=null)?$V{QTY_SUM8}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL8" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level8_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="560" y="0" width="94" height="18" uuid="49f9dcda-a8cc-4e1e-b079-b33849d07a31"/>
@@ -1267,7 +1291,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM8}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM8}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM8}!=null)?$V{WEIGHT_SUM8}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-24" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="c4c4d5dc-8687-48ad-8c7b-d7a620baee16"/>
@@ -1355,7 +1380,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM8}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM8}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM8}!=null)?$V{CONVAMOUNT_SUM8}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL2" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-93" style="Level2_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="536" y="0" width="24" height="18" uuid="8f7d7541-264f-4a20-865d-bf2003af8a92"/>
@@ -1400,7 +1426,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{QTY_SUM9}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM9}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM9}!=null)?$V{QTY_SUM9}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL9" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level9_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="560" y="0" width="94" height="18" uuid="a7ab64f8-75e2-4911-a26f-0cc2bd2efc6b"/>
@@ -1411,7 +1438,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM9}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM9}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM9}!=null)?$V{WEIGHT_SUM9}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-25" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="2cc4429f-8646-4a3b-8c5a-43bcd666b480"/>
@@ -1510,7 +1538,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM9}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM9}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM9}!=null)?$V{CONVAMOUNT_SUM9}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-95" style="Level1_Line" stretchType="RelativeToBandHeight" x="536" y="0" width="24" height="18" uuid="3824fbec-fea8-4611-a42a-3ab4bb55e99d"/>
@@ -1555,7 +1584,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{QTY_SUM10}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM10}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM10}!=null)?$V{QTY_SUM10}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL10" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level10_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="560" y="0" width="94" height="18" uuid="251a0b6e-4927-4171-aacb-752a84ae2659"/>
@@ -1566,7 +1596,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM10}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM10}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM10}!=null)?$V{WEIGHT_SUM10}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-98" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="6236b170-0a11-4e30-8905-8473a1f8425d"/>
@@ -1676,7 +1707,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM10}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM10}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM10}!=null)?$V{CONVAMOUNT_SUM10}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-107" style="Level10_Line" stretchType="RelativeToBandHeight" x="536" y="0" width="24" height="18" uuid="59da69c6-bdb8-48a4-be77-4a2762acd1b4"/>
@@ -1721,7 +1753,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{QTY_SUM11}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM11}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{QTY_SUM11}!=null)?$V{QTY_SUM11}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="LEVEL11" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField" style="Level11_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="560" y="0" width="94" height="18" uuid="495b192f-23b2-494e-8f61-f8e3fbcc6c9d"/>
@@ -1732,7 +1765,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{WEIGHT_SUM11}!=null)?$P{NUMBERFORMAT}.format($V{WEIGHT_SUM11}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{WEIGHT_SUM11}!=null)?$V{WEIGHT_SUM11}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
 					<reportElement key="textField-98" style="Level1_Line" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="15" height="18" uuid="f7c9a139-a25f-443f-872d-e346716a9cb5"/>
@@ -1853,7 +1887,8 @@
 						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
 					</box>
 					<textElement textAlignment="Right"/>
-					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM11}!=null)?$P{NUMBERFORMAT}.format($V{CONVAMOUNT_SUM11}):new String(" ")]]></textFieldExpression>
+					<textFieldExpression><![CDATA[($V{CONVAMOUNT_SUM11}!=null)?$V{CONVAMOUNT_SUM11}:BigDecimal.ZERO]]></textFieldExpression>
+					<patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression>
 				</textField>
 				<textField evaluationTime="Group" evaluationGroup="NIVEL1" pattern="" isBlankWhenNull="false">
 					<reportElement key="textField-107" style="Level11_Line" stretchType="RelativeToBandHeight" x="536" y="0" width="24" height="18" uuid="059f8867-1188-45d4-a25e-0cba7248f1bf"/>