details: https://code.openbravo.com/erp/devel/pi/rev/a686f7a45fa5 changeset: 32539:a686f7a45fa5 user: Armaignac <collazoandy4 <at> gmail.com> date: Fri Aug 04 11:34:16 2017 -0400 summary: Related to issue 31710: Fix Sales Invoice Dimensional & Shipment Dimensional reports
The Sales Invoice Dimensional Report document type total was exported as String. A int conversion was added to doctypecount. The Shipments Dimensional Report totals missed the patternExpression. It was added to properly format the amount. diffstat: src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalyses_srpt_doctypecount.jrxml | 3 ++- src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml | 2 ++ 2 files changed, 4 insertions(+), 1 deletions(-) diffs (39 lines): diff -r 2ab8016a2353 -r a686f7a45fa5 src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalyses_srpt_doctypecount.jrxml --- a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalyses_srpt_doctypecount.jrxml Fri Aug 04 19:25:27 2017 -0400 +++ b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalyses_srpt_doctypecount.jrxml Fri Aug 04 11:34:16 2017 -0400 @@ -3,6 +3,7 @@ <!-- 2017-02-23T10:42:31 --> <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="ReportInvoiceCustomerDimensionalAnalyses_srpt_doctypecount" pageWidth="400" pageHeight="802" whenNoDataType="AllSectionsNoDetail" columnWidth="400" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" whenResourceMissingType="Error" uuid="dcc54a6a-4fa7-4363-918c-1e721f63d8f0"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="si"/> + <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/> <style name="Detail_Header" mode="Opaque" forecolor="#FFFFFF" backcolor="#5D5D5D" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="9" isBold="true"/> <style name="Detail_Line" fontName="Bitstream Vera Sans" fontSize="8" isBold="true"> <conditionalStyle> @@ -145,7 +146,7 @@ <textElement textAlignment="Left"> <font size="8"/> </textElement> - <textFieldExpression><![CDATA[$F{doctypecount}]]></textFieldExpression> + <textFieldExpression><![CDATA[Integer.parseInt($F{doctypecount})]]></textFieldExpression> </textField> <textField> <reportElement style="Detail_Line" x="0" y="0" width="350" height="14" uuid="d4593cb6-8fa6-4f11-a6e1-d62b345662af"> diff -r 2ab8016a2353 -r a686f7a45fa5 src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml --- a/src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml Fri Aug 04 19:25:27 2017 -0400 +++ b/src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml Fri Aug 04 11:34:16 2017 -0400 @@ -370,6 +370,7 @@ </box> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[($V{CONVAMOUNT_TOTAL}!=null)?$V{CONVAMOUNT_TOTAL}:BigDecimal.ZERO]]></textFieldExpression> + <patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression> </textField> <line> <reportElement key="line-5" x="0" y="1" width="729" height="1" uuid="fed11dc1-1ca8-4a42-920b-03df2aa93a5c"/> @@ -396,6 +397,7 @@ </box> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[($V{QUANTITY_TOTAL}!=null)?$V{QUANTITY_TOTAL}:BigDecimal.ZERO]]></textFieldExpression> + <patternExpression><![CDATA[$P{NUMBERFORMAT}.toPattern()]]></patternExpression> </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"/> ------------------------------------------------------------------------------ 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