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