Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0008976 | Openbravo ERP | B. User interface | public | 2009-05-09 11:45 | 2009-06-17 10:53 |
|
| Reporter | iciordia | |
| Assigned To | gmauleon | |
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | any |
| Product Version | 2.40 | |
| Target Version | | Fixed in Version | pi | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0008976: Some reports can not be copy/pasted to excel in an adequate format |
| Description | In previous releases to 2.35 it was possible to copy the output of a report and paste it in excel. After migration to jasper reports, it is not possible and there is no excel format.
See notes below for a detailed list of those reports |
| Steps To Reproduce | Not exported report to excel:
• Warehouse Management || Analysis Tools || Warehouse Control Report || Warehouse Control Report
• Warehouse Management || Analysis Tools || Valued Stock Report || Valued Stock Report
• Financial Management || Receivables & Payables || Analysis Tools || Sales Order Open Item
• Financial Management || Receivables & Payables || Analysis Tools || Payment Report
• Financial Management || Receivables & Payables || Analysis Tools || Payment Tracker || Payment Tracker
• Financial Management || Receivables & Payables || Analysis Tools || Payment Tracker || Bank Report
• Financial Management || Receivables & Payables || Analysis Tools || Payment Tracker || Cash Report
• Financial Management || Accounting || Analysis Tools || General Ledger Journal --> Detail |
| Proposed Solution | Create an excell icon in each Report and use the existing jasper report but with he different output formal in order to handle the xls format.
Notice that the jasper reports should be modified to fit it properly, otherwise new empty column will appear |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | feature request | 0008474 | pi | closed | gmauleon | Some reports has only the HTML button. The PDF button is required | | related to | feature request | 0009464 | | scheduled | gorkaion | Export to Excel is not properly supported | | depends on | backport | 0008990 | | closed | gmauleon | Some reports can not be copy/pasted to excel in an adequate format |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2009-05-09 11:45 | iciordia | New Issue | |
| 2009-05-09 11:45 | iciordia | Assigned To | => rafaroda |
| 2009-05-09 11:45 | iciordia | Regression testing | => No |
| 2009-05-11 09:56 | rafaroda | Note Added: 0016226 | |
| 2009-05-11 09:56 | rafaroda | Status | new => feedback |
| 2009-05-11 11:25 | networkb | Note Added: 0016249 | |
| 2009-05-11 11:28 | networkb | Note Added: 0016251 | |
| 2009-05-11 13:17 | rafaroda | Relationship added | related to 0008474 |
| 2009-05-11 16:16 | rafaroda | Note Deleted: 0016226 | |
| 2009-05-11 16:17 | rafaroda | Note Deleted: 0016249 | |
| 2009-05-11 16:17 | rafaroda | Status | feedback => new |
| 2009-05-11 16:17 | rafaroda | version | pi => 2.40 |
| 2009-05-11 16:17 | rafaroda | Proposed Solution updated | |
| 2009-05-11 16:17 | rafaroda | Note Deleted: 0016251 | |
| 2009-05-11 16:17 | rafaroda | Assigned To | rafaroda => gmauleon |
| 2009-05-11 16:17 | rafaroda | Status | new => scheduled |
| 2009-05-11 16:17 | rafaroda | fix_in_branch | => pi |
| 2009-05-27 17:47 | gmauleon | Note Added: 0016688 | |
| 2009-05-27 17:48 | gmauleon | fix_in_branch | pi => |
| 2009-05-27 17:48 | gmauleon | Steps to Reproduce Updated | |
| 2009-06-11 09:38 | gmauleon | Summary | Some reports can not be copy/pasted to excel => Some reports can not be copy/pasted to excel in an adequate format |
| 2009-06-11 09:39 | gmauleon | Note Added: 0017208 | |
| 2009-06-12 11:55 | hgbot | Checkin | |
| 2009-06-12 11:55 | hgbot | Note Added: 0017242 | |
| 2009-06-12 11:55 | hgbot | Status | scheduled => resolved |
| 2009-06-12 11:55 | hgbot | Resolution | open => fixed |
| 2009-06-12 11:55 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/0741ed21940d7923556c210a67aa93bed753abd5 [^] |
| 2009-06-12 12:01 | gmauleon | Note Added: 0017243 | |
| 2009-06-15 10:34 | sureshbabu | Status | resolved => closed |
| 2009-06-15 10:34 | sureshbabu | Note Added: 0017287 | |
| 2009-06-15 10:34 | sureshbabu | Fixed in Version | => pi |
| 2009-06-16 00:00 | anonymous | sf_bug_id | 0 => 2806846 |
| 2009-06-17 10:53 | rafaroda | Relationship added | related to 0009464 |
| 2009-06-17 10:53 | rafaroda | Note Added: 0017381 | |
|
Notes |
|
|
|
Some of the reports commented are actually in HTML format so the user is able to copy & paste the content of them into a Excell File.
-Warehouse Management || Analysis Tools || Warehouse Control Report || Warehouse Control Report
-Warehouse Management || Analysis Tools || Valued Stock Report || Valued Stock Report
-Financial Management || Receivables & Payables || Analysis Tools || Payment Report
-Financial Management || Receivables & Payables || Analysis Tools || Payment Tracker || Payment Tracker
-Financial Management || Accounting || Analysis Tools || General Ledger Journal --> Detail
The other ones are in Jasper format and the way to act on them is to put and excell icon in the top of the window and change the output format of the PDF report to Excell
-Financial Management || Receivables & Payables || Analysis Tools || Sales Order Open Item
-Financial Management || Receivables & Payables || Analysis Tools || Payment Tracker || Bank Report
-Financial Management || Receivables & Payables || Analysis Tools || Payment Tracker || Cash Report |
|
|
|
|
Conclusions written by network
After review the reports what can not be copy/paste in excel file, conclusions are:
The following three reports can be copy/paste to excel in an adequate format so that no modifications are needed:
-Warehouse Management || Analysis Tools || Valued Stock Report || Valued Stock Report
-Financial Management || Receivables & Payables || Analysis Tools || Payment Report
-Financial Management || Accounting || Analysis Tools || General Ledger Journal --> Detail
However, the others two reports can not be copy/paste to excel because the data is shown group by some field so it's necessary to add an excel button in the reports:
-Warehouse Management || Analysis Tools || Warehouse Control Report || Warehouse Control Report
-Financial Management || Receivables & Payables || Analysis Tools || Payment Tracker || Payment Tracker
The excel result must be shown no grouped. |
|
|
|
(0017242)
|
|
hgbot
|
|
2009-06-12 11:55
|
|
Repository: erp/devel/pi
Changeset: 0741ed21940d7923556c210a67aa93bed753abd5
Author: Gorka Mauleon <gorka.mauleon <at> openbravo.com>
Date: Fri Jun 12 11:54:22 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0741ed21940d7923556c210a67aa93bed753abd5 [^]
fixes issue 0008976: Some reports can not be copy/pasted to excel in an adequate format
---
M src/org/openbravo/erpCommon/ad_reports/ReportBankJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportCashJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderOpenItemEdit.jrxml
---
|
|
|
|
|
As seen in previous comments, the decided way to fix this bugs includes only the 3 jasper reports modified in the commit. As the XML output format hasn't been even supported for this reports the inclusion of the xml button is not possible to fix a bug in the other hand in previous version when the user used the copy & paste to an excel file the the format was better than now. So in this fix the current report for this bugs are following the instructions give by Jaspersoft[1]
Regards
[1] http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/faq.html?group_id=252#FAQ9 [^] |
|
|
|
|
|
Now those three reports(Cash report, Bank report, Sales order open item) can able to cut & paste to excel. |
|
|
|
|
|
The Excel showing data results not grouped will be addressed by feature request 0009464 |
|