details:   https://code.openbravo.com/erp/devel/pi/rev/a2e47e0999a6
changeset: 32477:a2e47e0999a6
user:      Armaignac <collazoandy4 <at> gmail.com>
date:      Mon Jul 17 11:07:41 2017 -0400
summary:   Backed out changeset: 33b542f18c28
Solution was wrong as it includes unnecessary changes

details:   https://code.openbravo.com/erp/devel/pi/rev/4ffa25fd381c
changeset: 32478:4ffa25fd381c
user:      Armaignac <collazoandy4 <at> gmail.com>
date:      Mon Jul 17 12:15:51 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.

details:   https://code.openbravo.com/erp/devel/pi/rev/89e9cb7c60dc
changeset: 32479:89e9cb7c60dc
user:      Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
date:      Wed Jul 19 11:38:14 2017 +0200
summary:   Fixes issue 36404: Code review improvements

Replaced new BigDecimal("0") by BigDecimal.ZERO as in the original fix

diffstat:

 src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLS.jrxml            
 |  40 +++++-----
 
src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLSDoubtfulDebt.jrxml 
|  24 +++---
 src/org/openbravo/erpCommon/ad_reports/AgingScheduleXLS.jrxml                  
 |  40 +++++-----
 3 files changed, 52 insertions(+), 52 deletions(-)

diffs (truncated from 477 to 300 lines):

diff -r ee4945b282bb -r 89e9cb7c60dc 
src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLS.jrxml
--- a/src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLS.jrxml       
Tue Jul 18 10:31:34 2017 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLS.jrxml       
Wed Jul 19 11:38:14 2017 +0200
@@ -61,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.Integer"/>
+       <field name="INVOICE_NUMBER" class="java.lang.String"/>
        <field name="INVOICE_ID" class="java.lang.String"/>
        <field name="AMOUNT0" class="java.math.BigDecimal"/>
        <field name="AMOUNT1" class="java.math.BigDecimal"/>
@@ -178,7 +178,7 @@
                                        <textElement textAlignment="Right">
                                                <font size="10" isBold="false"/>
                                        </textElement>
-                                       <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[($V{SUMNET}==null ? BigDecimal.ZERO : 
$V{SUMNET}).add($V{SUMCREDIT}==null ? BigDecimal.ZERO : 
$V{SUMCREDIT})]]></textFieldExpression>
+                                       
<textFieldExpression><![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>
@@ -366,7 +366,7 @@
                                <textElement verticalAlignment="Middle">
                                        <font size="8" isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.lang.Integer"><![CDATA[$F{INVOICE_NUMBER}]]></textFieldExpression>
+                               
<textFieldExpression><![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"/>
@@ -374,7 +374,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$F{AMOUNT0} != null ? $F{AMOUNT0} : 
BigDecimal.ZERO]]></textFieldExpression>
+                               <textFieldExpression><![CDATA[$F{AMOUNT0} != 
null ? $F{AMOUNT0} : BigDecimal.ZERO]]></textFieldExpression>
                                
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
                        </textField>
                        <textField isBlankWhenNull="true" 
hyperlinkType="Reference">
@@ -383,7 +383,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$F{AMOUNT1} != null ? $F{AMOUNT1} : 
BigDecimal.ZERO]]></textFieldExpression>
+                               <textFieldExpression><![CDATA[$F{AMOUNT1} != 
null ? $F{AMOUNT1} : BigDecimal.ZERO]]></textFieldExpression>
                                
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
                        </textField>
                        <textField isBlankWhenNull="true" 
hyperlinkType="Reference">
@@ -392,7 +392,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$F{AMOUNT2} != null ? $F{AMOUNT2} : 
BigDecimal.ZERO]]></textFieldExpression>
+                               <textFieldExpression><![CDATA[$F{AMOUNT2} != 
null ? $F{AMOUNT2} : BigDecimal.ZERO]]></textFieldExpression>
                                
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
                        </textField>
                        <textField isBlankWhenNull="true" 
hyperlinkType="Reference">
@@ -401,7 +401,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$F{AMOUNT3} != null ? $F{AMOUNT3} : 
BigDecimal.ZERO]]></textFieldExpression>
+                               <textFieldExpression><![CDATA[$F{AMOUNT3} != 
null ? $F{AMOUNT3} : BigDecimal.ZERO]]></textFieldExpression>
                                
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
                        </textField>
                        <textField isBlankWhenNull="true" 
hyperlinkType="Reference">
@@ -410,7 +410,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$F{AMOUNT4} != null ? $F{AMOUNT4} : 
BigDecimal.ZERO]]></textFieldExpression>
+                               <textFieldExpression><![CDATA[$F{AMOUNT4} != 
null ? $F{AMOUNT4} : BigDecimal.ZERO]]></textFieldExpression>
                                
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
                        </textField>
                        <textField isBlankWhenNull="true" 
hyperlinkType="Reference">
@@ -435,7 +435,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$F{SHOW_NETDUE} == null ? BigDecimal.ZERO 
: ($F{NETDUE} == null
+                               <textFieldExpression><![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>
@@ -445,7 +445,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$F{AMOUNT5} != null ? $F{AMOUNT5} : 
BigDecimal.ZERO]]></textFieldExpression>
+                               <textFieldExpression><![CDATA[$F{AMOUNT5} != 
null ? $F{AMOUNT5} : BigDecimal.ZERO]]></textFieldExpression>
                                
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
                        </textField>
                        <textField isStretchWithOverflow="true" 
isBlankWhenNull="true" hyperlinkType="Reference">
@@ -454,7 +454,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$F{AMOUNT6} != null ? 
$F{AMOUNT6}.negate() : BigDecimal.ZERO]]></textFieldExpression>
+                               <textFieldExpression><![CDATA[$F{AMOUNT6} != 
null ? $F{AMOUNT6}.negate() : BigDecimal.ZERO]]></textFieldExpression>
                                
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
                        </textField>
                </band>
@@ -480,7 +480,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT3TOTAL} != null ? 
$V{SUMAMT3TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
+                               <textFieldExpression><![CDATA[$V{SUMAMT3TOTAL} 
!= null ? $V{SUMAMT3TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
                                
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
                        </textField>
                        <textField isBlankWhenNull="true" 
hyperlinkType="Reference">
@@ -489,7 +489,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT4TOTAL} != null ? 
$V{SUMAMT4TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
+                               <textFieldExpression><![CDATA[$V{SUMAMT4TOTAL} 
!= null ? $V{SUMAMT4TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
                                
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
                        </textField>
                        <line>
@@ -501,7 +501,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT2TOTAL} != null ? 
$V{SUMAMT2TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
+                               <textFieldExpression><![CDATA[$V{SUMAMT2TOTAL} 
!= null ? $V{SUMAMT2TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
                                
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
                        </textField>
                        <textField isBlankWhenNull="true" 
hyperlinkType="Reference">
@@ -510,7 +510,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT5TOTAL} != null ? 
$V{SUMAMT5TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
+                               <textFieldExpression><![CDATA[$V{SUMAMT5TOTAL} 
!= null ? $V{SUMAMT5TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
                                
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
                        </textField>
                        <line>
@@ -522,7 +522,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="10" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMNETTOTAL}.add($V{SUMCREDITSTOTAL}==null
 ? BigDecimal.ZERO : $V{SUMCREDITSTOTAL})]]></textFieldExpression>
+                               
<textFieldExpression><![CDATA[$V{SUMNETTOTAL}.add($V{SUMCREDITSTOTAL}==null ? 
BigDecimal.ZERO : $V{SUMCREDITSTOTAL})]]></textFieldExpression>
                                
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
                        </textField>
                        <textField isStretchWithOverflow="true" 
isBlankWhenNull="false">
@@ -531,7 +531,7 @@
                                <textElement textAlignment="Right">
                                        <font size="10" isBold="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[($V{SUMNETTOTAL}==null ? BigDecimal.ZERO 
: $V{SUMNETTOTAL}).add($V{SUMCREDITSTOTAL}==null ? BigDecimal.ZERO : 
$V{SUMCREDITSTOTAL})]]></textFieldExpression>
+                               
<textFieldExpression><![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">
@@ -540,7 +540,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMCREDITSTOTAL} != null ? 
$V{SUMCREDITSTOTAL} : BigDecimal.ZERO]]></textFieldExpression>
+                               
<textFieldExpression><![CDATA[$V{SUMCREDITSTOTAL} != null ? $V{SUMCREDITSTOTAL} 
: BigDecimal.ZERO]]></textFieldExpression>
                                
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
                        </textField>
                        <textField isStretchWithOverflow="true" 
isBlankWhenNull="true" hyperlinkType="Reference">
@@ -549,7 +549,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT0TOTAL} != null ? 
$V{SUMAMT0TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
+                               <textFieldExpression><![CDATA[$V{SUMAMT0TOTAL} 
!= null ? $V{SUMAMT0TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
                                
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
                        </textField>
                        <textField isBlankWhenNull="true" 
hyperlinkType="Reference">
@@ -558,7 +558,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT1TOTAL} != null ? 
$V{SUMAMT1TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
+                               <textFieldExpression><![CDATA[$V{SUMAMT1TOTAL} 
!= null ? $V{SUMAMT1TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
                                
<patternExpression><![CDATA[$P{AMOUNTFORMAT}.toPattern()]]></patternExpression>
                        </textField>
                </band>
diff -r ee4945b282bb -r 89e9cb7c60dc 
src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLSDoubtfulDebt.jrxml
--- 
a/src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLSDoubtfulDebt.jrxml
   Tue Jul 18 10:31:34 2017 +0200
+++ 
b/src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLSDoubtfulDebt.jrxml
   Wed Jul 19 11:38:14 2017 +0200
@@ -61,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.Integer"/>
+       <field name="INVOICE_NUMBER" class="java.lang.String"/>
        <field name="INVOICE_ID" class="java.lang.String"/>
        <field name="AMOUNT0" class="java.math.BigDecimal"/>
        <field name="AMOUNT1" class="java.math.BigDecimal"/>
@@ -404,7 +404,7 @@
                                <textElement verticalAlignment="Middle">
                                        <font size="8" isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.lang.Integer"><![CDATA[$F{INVOICE_NUMBER}]]></textFieldExpression>
+                               <textFieldExpression 
class="java.lang.String"><![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"/>
@@ -501,7 +501,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$F{PERCENTAGE} != null ?  $F{PERCENTAGE} 
: null]]></textFieldExpression>
+                               <textFieldExpression><![CDATA[$F{PERCENTAGE} != 
null ?  $F{PERCENTAGE} : null]]></textFieldExpression>
                        </textField>
                </band>
        </detail>
@@ -526,7 +526,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT3TOTAL} != null ? 
$V{SUMAMT3TOTAL} : (new BigDecimal("0"))]]></textFieldExpression>
+                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT3TOTAL} != null ? 
$V{SUMAMT3TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
                        </textField>
                        <textField isBlankWhenNull="true" 
hyperlinkType="Reference">
                                <reportElement key="textField-6" 
style="Detail_Header" x="558" y="42" width="75" height="16" forecolor="#000000" 
backcolor="#FFFFFF"/>
@@ -534,7 +534,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT4TOTAL} != null ? 
$V{SUMAMT4TOTAL} : (new BigDecimal("0"))]]></textFieldExpression>
+                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT4TOTAL} != null ? 
$V{SUMAMT4TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
                        </textField>
                        <line>
                                <reportElement key="line-33" 
style="Report_Footer" x="1" y="63" width="1137" height="1"/>
@@ -545,7 +545,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT2TOTAL} != null ? 
$V{SUMAMT2TOTAL} : (new BigDecimal("0"))]]></textFieldExpression>
+                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT2TOTAL} != null ? 
$V{SUMAMT2TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
                        </textField>
                        <textField isBlankWhenNull="true" 
hyperlinkType="Reference">
                                <reportElement key="textField-6" 
style="Detail_Header" x="633" y="42" width="75" height="16" forecolor="#000000" 
backcolor="#FFFFFF"/>
@@ -553,7 +553,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT5TOTAL} != null ? 
$V{SUMAMT5TOTAL} : (new BigDecimal("0"))]]></textFieldExpression>
+                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT5TOTAL} != null ? 
$V{SUMAMT5TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
                        </textField>
                        <line>
                                <reportElement key="line-33" 
style="Report_Footer" x="1" y="29" width="1137" height="1"/>
@@ -580,7 +580,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMCREDITSTOTAL} != null ? 
$V{SUMCREDITSTOTAL} : new BigDecimal("0")]]></textFieldExpression>
+                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMCREDITSTOTAL} != null ? 
$V{SUMCREDITSTOTAL} : BigDecimal.ZERO]]></textFieldExpression>
                        </textField>
                        <textField isStretchWithOverflow="true" 
isBlankWhenNull="true" hyperlinkType="Reference">
                                <reportElement key="textField-6" 
style="Detail_Header" x="258" y="42" width="75" height="16" forecolor="#000000" 
backcolor="#FFFFFF"/>
@@ -588,7 +588,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT0TOTAL} != null ? 
$V{SUMAMT0TOTAL} : (new BigDecimal("0"))]]></textFieldExpression>
+                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT0TOTAL} != null ? 
$V{SUMAMT0TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
                        </textField>
                        <textField isBlankWhenNull="true" 
hyperlinkType="Reference">
                                <reportElement key="textField-6" 
style="Detail_Header" x="333" y="42" width="75" height="16" forecolor="#000000" 
backcolor="#FFFFFF"/>
@@ -596,7 +596,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT1TOTAL} != null ? 
$V{SUMAMT1TOTAL} : (new BigDecimal("0"))]]></textFieldExpression>
+                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMAMT1TOTAL} != null ? 
$V{SUMAMT1TOTAL} : BigDecimal.ZERO]]></textFieldExpression>
                        </textField>
                        <textField isStretchWithOverflow="true" 
isBlankWhenNull="true" hyperlinkType="Reference">
                                <reportElement key="textField-6" 
style="Detail_Header" x="783" y="42" width="85" height="16" forecolor="#000000" 
backcolor="#FFFFFF"/>
@@ -604,7 +604,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMDOUBTFULTOTAL} != null ? 
$V{SUMDOUBTFULTOTAL} : new BigDecimal("0")]]></textFieldExpression>
+                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[$V{SUMDOUBTFULTOTAL} != null ? 
$V{SUMDOUBTFULTOTAL} : BigDecimal.ZERO]]></textFieldExpression>
                        </textField>
                        <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"/>
@@ -612,7 +612,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8" isBold="false" 
isUnderline="false"/>
                                </textElement>
-                               <textFieldExpression 
class="java.math.BigDecimal"><![CDATA[($V{PERCENTAGETOTAL} != null ? 
$V{PERCENTAGETOTAL} : BigDecimal.ZERO)]]></textFieldExpression>
+                               
<textFieldExpression><![CDATA[($V{PERCENTAGETOTAL} != null ? 
$V{PERCENTAGETOTAL} : BigDecimal.ZERO)]]></textFieldExpression>
                        </textField>
                </band>
        </columnFooter>
diff -r ee4945b282bb -r 89e9cb7c60dc 
src/org/openbravo/erpCommon/ad_reports/AgingScheduleXLS.jrxml
--- a/src/org/openbravo/erpCommon/ad_reports/AgingScheduleXLS.jrxml     Tue Jul 
18 10:31:34 2017 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/AgingScheduleXLS.jrxml     Wed Jul 
19 11:38:14 2017 +0200
@@ -404,7 +404,7 @@
                                <textElement textAlignment="Right" 
verticalAlignment="Middle">
                                        <font size="8"/>

------------------------------------------------------------------------------
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

Reply via email to