details: https://code.openbravo.com/erp/devel/pi/rev/b4a6052148fe changeset: 21120:b4a6052148fe user: Javier Etxarri <javier.echarri <at> openbravo.com> date: Thu Sep 12 22:48:01 2013 +0200 summary: Fixes issue 24512: The Report General Ledger does not format the dates with the dateformat defined for Openbravo when exporting to xls
diffstat: src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerExcel.jrxml | 5 ++++- 1 files changed, 4 insertions(+), 1 deletions(-) diffs (22 lines): diff -r 74a1c5d100ae -r b4a6052148fe src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerExcel.jrxml --- a/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerExcel.jrxml Thu Sep 12 17:51:51 2013 +0200 +++ b/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerExcel.jrxml Thu Sep 12 22:48:01 2013 +0200 @@ -2,6 +2,9 @@ <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="ReportGeneralLedgerExcel" pageWidth="1500" pageHeight="842" orientation="Landscape" columnWidth="1500" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isIgnorePagination="true"> <property name="ireport.scriptlethandling" value="0"/> <property name="ireport.encoding" value="UTF-8"/> + <property name="ireport.zoom" value="1.0"/> + <property name="ireport.x" value="0"/> + <property name="ireport.y" value="0"/> <import value="net.sf.jasperreports.engine.*"/> <import value="java.util.*"/> <import value="net.sf.jasperreports.engine.data.*"/> @@ -373,7 +376,7 @@ <textElement textAlignment="Left"> <font size="8"/> </textElement> - <textFieldExpression class="java.util.Date"><![CDATA[$F{DATEACCT}]]></textFieldExpression> + <textFieldExpression class="java.lang.String"><![CDATA[(new SimpleDateFormat($P{strDateFormat})).format($F{DATEACCT})]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="textField" stretchType="RelativeToBandHeight" x="900" y="0" width="200" height="13"/> ------------------------------------------------------------------------------ How ServiceNow helps IT people transform IT departments: 1. Consolidate legacy IT systems to a single system of record for IT 2. Standardize and globalize service processes across IT 3. Implement zero-touch automation to replace manual, redundant tasks http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
