details: https://code.openbravo.com/erp/devel/pi/rev/9b2210a5b692
changeset: 32534:9b2210a5b692
user: Armaignac <collazoandy4 <at> gmail.com>
date: Wed Jul 26 17:24:11 2017 -0400
summary: 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.
diffstat:
src/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml
| 28 +-
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalExcel.jrxml
| 3 +
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
| 14 +-
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesXLS.jrxml
| 3 +
src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartnerJR.jrxml
| 7 +-
src/org/openbravo/erpCommon/ad_reports/WeightDimensionalComparative.jrxml
| 286 ++++++---
src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml
| 107 ++-
7 files changed, 305 insertions(+), 143 deletions(-)
diffs (truncated from 1617 to 300 lines):
diff -r b12d3da979df -r 9b2210a5b692
src/org/openbravo/erpCommon/ad_reports/CustomerStatement.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"/>
diff -r b12d3da979df -r 9b2210a5b692
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalExcel.jrxml
---
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"/>
diff -r b12d3da979df -r 9b2210a5b692
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
---
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"/>
diff -r b12d3da979df -r 9b2210a5b692
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesXLS.jrxml
---
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>
diff -r b12d3da979df -r 9b2210a5b692
src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartnerJR.jrxml
--- 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"/>
diff -r b12d3da979df -r 9b2210a5b692
src/org/openbravo/erpCommon/ad_reports/WeightDimensionalComparative.jrxml
--- 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">
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
