Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006706Openbravo ERPA. Platformpublic2008-12-20 17:092009-04-21 12:36
iciordia 
shuehner 
normalminoralways
closedfixed 
5
pi 
 
Core
No
0006706: "/n" character is removed from jrxml file when executed through Openbravo
"/n" character is removed from jrxml file when executed through Openbravo. If the sql statement within it uses "/n" characters to separate the expresions, when executing the report and after removing this character it fails (the sql statement is wrong).
In any report in the system, edit the sql statatement so the last expresion in the SELECT clause and the FROM clause are only separated by a new line ("/n") character. Execute it through iReports and it works. If you execute it through Openbravo it fails.
Check if the root cause of the problem is in Openbravo (eg. openbravo uses a parser to load the jrxml file, or the translation process copies it after parsing it) or in Jasper Reports.

If it is in Openbravo, change the behaviour of the parser to avoid removing new line character when parsing.
No tags attached.
related to defect 0009328 closed iperdomo String out of index: -1 error appears, when a jasper report contains a \n in one field 
Issue History
2008-12-20 17:09iciordiaNew Issue
2008-12-20 17:09iciordiaAssigned To => iperdomo
2008-12-20 17:09iciordiasf_bug_id0 => 2454363
2008-12-20 17:09iciordiaRegression testing => No
2009-01-02 18:56iperdomoStatusnew => scheduled
2009-01-02 18:56iperdomofix_in_branch => trunk
2009-01-28 14:46iperdomoAssigned Toiperdomo => shuehner
2009-01-29 17:50svnbotCheckin
2009-01-29 17:50svnbotNote Added: 0012849
2009-01-29 17:50svnbotStatusscheduled => resolved
2009-01-29 17:50svnbotResolutionopen => fixed
2009-01-29 17:50svnbotsvn_revision => 12512
2009-04-21 12:36psarobeStatusresolved => closed
2009-06-04 11:20rafarodaRelationship addedrelated to 0009328

Notes
(0012849)
svnbot   
2009-01-29 17:50   
Repository: openbravo
Revision: 12512
Author: huehner
Date: 2009-01-29 17:50:55 +0100 (Thu, 29 Jan 2009)

Fixed 6706
Do not remove all newline characters when doing online translation
of i.e. jasper report designs, as this breaks embedded sql statements
with several lines and not leading/trailing spaces around a linebreak.

---
U trunk/src-core/src/org/openbravo/uiTranslation/TranslationHandler.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=12512&sc=1 [^]