details: https://code.openbravo.com/erp/devel/pi/rev/33b542f18c28
changeset: 32449:33b542f18c28
user: Armaignac <collazoandy4 <at> gmail.com>
date: Mon Jul 10 17:14:46 2017 -0400
summary: Fixes issue 36404: Numbers in Receivables Aging Schedule and
Payables Aging
Schedule are exported to Excel as strings
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/AgingScheduleDetailXLS.jrxml
| 43 ++++---
src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLSDoubtfulDebt.jrxml
| 11 +-
src/org/openbravo/erpCommon/ad_reports/AgingScheduleXLS.jrxml
| 54 ++++-----
3 files changed, 54 insertions(+), 54 deletions(-)
diffs (truncated from 464 to 300 lines):
diff -r a99ac166135b -r 33b542f18c28
src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLS.jrxml
--- a/src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLS.jrxml
Tue Jul 11 12:30:29 2017 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLS.jrxml
Mon Jul 10 17:14:46 2017 -0400
@@ -5,6 +5,7 @@
<property name="ireport.zoom" value="0.75"/>
<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.*"/>
@@ -60,7 +61,7 @@
'hello' AS CURRENCY, 1234 AS BASE_AMOUNT, 'hello' AS BASE_CURRENCY,
'hello' AS PAYMENT_METHOD, 'hello' AS FINANCIAL_ACCOUNT
FROM DUAL]]>
</queryString>
- <field name="INVOICE_NUMBER" class="java.lang.String"/>
+ <field name="INVOICE_NUMBER" class="java.lang.Integer"/>
<field name="INVOICE_ID" class="java.lang.String"/>
<field name="AMOUNT0" class="java.math.BigDecimal"/>
<field name="AMOUNT1" class="java.math.BigDecimal"/>
@@ -177,7 +178,7 @@
<textElement textAlignment="Right">
<font size="10" isBold="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format(($V{SUMNET}==null ?
BigDecimal.ZERO : $V{SUMNET}).add($V{SUMCREDIT}==null ? BigDecimal.ZERO :
$V{SUMCREDIT}))]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[($V{SUMNET}==null ? BigDecimal.ZERO :
$V{SUMNET}).add($V{SUMCREDIT}==null ? BigDecimal.ZERO :
$V{SUMCREDIT})]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
</band>
@@ -365,7 +366,7 @@
<textElement verticalAlignment="Middle">
<font size="8" isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$F{INVOICE_NUMBER}]]></textFieldExpression>
+ <textFieldExpression
class="java.lang.Integer"><![CDATA[$F{INVOICE_NUMBER}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true"
hyperlinkType="Reference">
<reportElement key="textField-6"
style="Detail_Line" x="258" y="0" width="75" height="16" forecolor="#000000"
uuid="e5135476-8709-480a-a862-8567c34a0c9a"/>
@@ -373,7 +374,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($F{AMOUNT0} != null ?
$F{AMOUNT0} : BigDecimal.ZERO)]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$F{AMOUNT0} != null ? $F{AMOUNT0} :
BigDecimal.ZERO]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField isBlankWhenNull="true"
hyperlinkType="Reference">
@@ -382,7 +383,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($F{AMOUNT1} != null ?
$F{AMOUNT1} : BigDecimal.ZERO)]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$F{AMOUNT1} != null ? $F{AMOUNT1} :
BigDecimal.ZERO]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField isBlankWhenNull="true"
hyperlinkType="Reference">
@@ -391,7 +392,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($F{AMOUNT2} != null ?
$F{AMOUNT2} : BigDecimal.ZERO)]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$F{AMOUNT2} != null ? $F{AMOUNT2} :
BigDecimal.ZERO]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField isBlankWhenNull="true"
hyperlinkType="Reference">
@@ -400,7 +401,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($F{AMOUNT3} != null ?
$F{AMOUNT3} : BigDecimal.ZERO)]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$F{AMOUNT3} != null ? $F{AMOUNT3} :
BigDecimal.ZERO]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField isBlankWhenNull="true"
hyperlinkType="Reference">
@@ -409,7 +410,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($F{AMOUNT4} != null ?
$F{AMOUNT4} : BigDecimal.ZERO)]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$F{AMOUNT4} != null ? $F{AMOUNT4} :
BigDecimal.ZERO]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField isBlankWhenNull="true"
hyperlinkType="Reference">
@@ -434,8 +435,8 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($F{SHOW_NETDUE} == null ?
BigDecimal.ZERO : ($F{NETDUE} == null
- ? $F{SHOW_NETDUE}.negate() : $F{SHOW_NETDUE}))]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$F{SHOW_NETDUE} == null ? BigDecimal.ZERO
: ($F{NETDUE} == null
+ ? $F{SHOW_NETDUE}.negate() : $F{SHOW_NETDUE})]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField isBlankWhenNull="true"
hyperlinkType="Reference">
@@ -444,7 +445,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($F{AMOUNT5} != null ?
$F{AMOUNT5} : BigDecimal.ZERO)]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$F{AMOUNT5} != null ? $F{AMOUNT5} :
BigDecimal.ZERO]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField isStretchWithOverflow="true"
isBlankWhenNull="true" hyperlinkType="Reference">
@@ -453,7 +454,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($F{AMOUNT6} != null ?
$F{AMOUNT6}.negate() : BigDecimal.ZERO)]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$F{AMOUNT6} != null ?
$F{AMOUNT6}.negate() : BigDecimal.ZERO]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
</band>
@@ -479,7 +480,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isBold="false"
isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($V{SUMAMT3TOTAL} != null
? $V{SUMAMT3TOTAL} : (new BigDecimal("0")))]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT3TOTAL} != null ?
$V{SUMAMT3TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField isBlankWhenNull="true"
hyperlinkType="Reference">
@@ -488,7 +489,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isBold="false"
isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($V{SUMAMT4TOTAL} != null
? $V{SUMAMT4TOTAL} : (new BigDecimal("0")))]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT4TOTAL} != null ?
$V{SUMAMT4TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<line>
@@ -500,7 +501,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isBold="false"
isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($V{SUMAMT2TOTAL} != null
? $V{SUMAMT2TOTAL} : (new BigDecimal("0")))]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT2TOTAL} != null ?
$V{SUMAMT2TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField isBlankWhenNull="true"
hyperlinkType="Reference">
@@ -509,7 +510,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isBold="false"
isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($V{SUMAMT5TOTAL} != null
? $V{SUMAMT5TOTAL} : (new BigDecimal("0")))]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT5TOTAL} != null ?
$V{SUMAMT5TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<line>
@@ -521,7 +522,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="10" isBold="false"
isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($V{SUMNETTOTAL}.add($V{SUMCREDITSTOTAL}==null
? BigDecimal.ZERO : $V{SUMCREDITSTOTAL}))]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$V{SUMNETTOTAL}.add($V{SUMCREDITSTOTAL}==null
? BigDecimal.ZERO : $V{SUMCREDITSTOTAL})]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField isStretchWithOverflow="true"
isBlankWhenNull="false">
@@ -530,7 +531,7 @@
<textElement textAlignment="Right">
<font size="10" isBold="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format(($V{SUMNETTOTAL}==null ?
BigDecimal.ZERO : $V{SUMNETTOTAL}).add($V{SUMCREDITSTOTAL}==null ?
BigDecimal.ZERO : $V{SUMCREDITSTOTAL}))]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[($V{SUMNETTOTAL}==null ? BigDecimal.ZERO
: $V{SUMNETTOTAL}).add($V{SUMCREDITSTOTAL}==null ? BigDecimal.ZERO :
$V{SUMCREDITSTOTAL})]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField isStretchWithOverflow="true"
isBlankWhenNull="true" hyperlinkType="Reference">
@@ -539,7 +540,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isBold="false"
isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($V{SUMCREDITSTOTAL} !=
null ? $V{SUMCREDITSTOTAL} : new BigDecimal("0"))]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$V{SUMCREDITSTOTAL} != null ?
$V{SUMCREDITSTOTAL} : BigDecimal.ZERO]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField isStretchWithOverflow="true"
isBlankWhenNull="true" hyperlinkType="Reference">
@@ -548,7 +549,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isBold="false"
isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($V{SUMAMT0TOTAL} != null
? $V{SUMAMT0TOTAL} : (new BigDecimal("0")))]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT0TOTAL} != null ?
$V{SUMAMT0TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField isBlankWhenNull="true"
hyperlinkType="Reference">
@@ -557,7 +558,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isBold="false"
isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($V{SUMAMT1TOTAL} != null
? $V{SUMAMT1TOTAL} : (new BigDecimal("0")))]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT1TOTAL} != null ?
$V{SUMAMT1TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
</band>
diff -r a99ac166135b -r 33b542f18c28
src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLSDoubtfulDebt.jrxml
---
a/src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLSDoubtfulDebt.jrxml
Tue Jul 11 12:30:29 2017 +0200
+++
b/src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLSDoubtfulDebt.jrxml
Mon Jul 10 17:14:46 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.*"/>
@@ -60,7 +61,7 @@
'hello' AS CURRENCY, 1234 AS BASE_AMOUNT, 'hello' AS BASE_CURRENCY,
'hello' AS PAYMENT_METHOD, 'hello' AS FINANCIAL_ACCOUNT
FROM DUAL]]>
</queryString>
- <field name="INVOICE_NUMBER" class="java.lang.String"/>
+ <field name="INVOICE_NUMBER" class="java.lang.Integer"/>
<field name="INVOICE_ID" class="java.lang.String"/>
<field name="AMOUNT0" class="java.math.BigDecimal"/>
<field name="AMOUNT1" class="java.math.BigDecimal"/>
@@ -403,7 +404,7 @@
<textElement verticalAlignment="Middle">
<font size="8" isUnderline="false"/>
</textElement>
- <textFieldExpression
class="java.lang.String"><![CDATA[$F{INVOICE_NUMBER}]]></textFieldExpression>
+ <textFieldExpression
class="java.lang.Integer"><![CDATA[$F{INVOICE_NUMBER}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true"
hyperlinkType="Reference">
<reportElement key="textField-6"
style="Detail_Line" x="258" y="0" width="75" height="16" forecolor="#000000"/>
@@ -500,7 +501,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isUnderline="false"/>
</textElement>
- <textFieldExpression
class="java.lang.String"><![CDATA[$F{PERCENTAGE} != null ?
$P{AMOUNTFORMAT}.format($F{PERCENTAGE}) + " %" : null]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$F{PERCENTAGE} != null ? $F{PERCENTAGE}
: null]]></textFieldExpression>
</textField>
</band>
</detail>
@@ -605,13 +606,13 @@
</textElement>
<textFieldExpression
class="java.math.BigDecimal"><![CDATA[$V{SUMDOUBTFULTOTAL} != null ?
$V{SUMDOUBTFULTOTAL} : new BigDecimal("0")]]></textFieldExpression>
</textField>
- <textField isStretchWithOverflow="true"
isBlankWhenNull="true" hyperlinkType="Reference">
+ <textField isStretchWithOverflow="true"
isBlankWhenNull="true" hyperlinkType="Reference" pattern="##0.00%">
<reportElement key="textField-6"
style="Detail_Header" x="868" y="42" width="70" height="16" forecolor="#000000"
backcolor="#FFFFFF"/>
<box leftPadding="2"/>
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isBold="false"
isUnderline="false"/>
</textElement>
- <textFieldExpression
class="java.lang.String"><![CDATA[($V{PERCENTAGETOTAL} != null ?
$P{AMOUNTFORMAT}.format($V{PERCENTAGETOTAL}) : $P{AMOUNTFORMAT}.format(new
BigDecimal("0"))) + " %"]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[($V{PERCENTAGETOTAL} != null ?
$V{PERCENTAGETOTAL} : BigDecimal.ZERO)]]></textFieldExpression>
</textField>
</band>
</columnFooter>
diff -r a99ac166135b -r 33b542f18c28
src/org/openbravo/erpCommon/ad_reports/AgingScheduleXLS.jrxml
--- a/src/org/openbravo/erpCommon/ad_reports/AgingScheduleXLS.jrxml Tue Jul
11 12:30:29 2017 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/AgingScheduleXLS.jrxml Mon Jul
10 17:14:46 2017 -0400
@@ -404,7 +404,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($F{net})]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$F{net}]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField isStretchWithOverflow="true"
pattern="##0.00" isBlankWhenNull="false" hyperlinkType="Reference">
@@ -418,7 +418,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($F{credit}.negate())]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$F{credit}.negate()]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField pattern="##0.00" isBlankWhenNull="false"
hyperlinkType="Reference">
@@ -432,7 +432,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($F{amount0})]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$F{amount0}]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField pattern="##0.00" isBlankWhenNull="false"
hyperlinkType="Reference">
@@ -446,7 +446,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($F{amount1})]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$F{amount1}]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField pattern="##0.00" isBlankWhenNull="false"
hyperlinkType="Reference">
@@ -460,7 +460,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($F{amount2})]]></textFieldExpression>
+ <textFieldExpression
class="java.math.BigDecimal"><![CDATA[$F{amount2}]]></textFieldExpression>
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
</textField>
<textField pattern="##0.00" isBlankWhenNull="false"
hyperlinkType="Reference">
@@ -474,7 +474,7 @@
<textElement textAlignment="Right"
verticalAlignment="Middle">
<font size="8" isUnderline="false"/>
</textElement>
-
<textFieldExpression><![CDATA[$P{AMOUNTFORMAT}.format($F{amount3})]]></textFieldExpression>
------------------------------------------------------------------------------
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
