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

Reply via email to