Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0009027Openbravo ERP09. Financial managementpublic2009-05-13 18:542009-07-27 19:38
networkb 
rafaroda 
immediatemajoralways
closedfixed 
5
2.40MP3 
2.40MP32.50MP3 
Core
No
0009027: General Ledger Report executed with "show all" doesn't respect column's width
When executing General Ledger Report with option "show all" selected, minimum width of columns is not respected.
 
See image attached
(For example: columns with no data in description field are not 75% width)
1. Financial Management || Accounting || Analysis Tools || General Ledger Report
2. Check "show all" and execute the report clicking "HTML format" button
250MP3releasecandidate
depends on backport 00090412.40MP3 closed rafaroda General Ledger Report's appearance is aligned when executed with "show all" selected 
depends on backport 00097732.40MP3 closed rafaroda General Ledger Report executed with "show all" doesn't respect column's width  
jpg showAllGL.jpg (128,876) 2009-05-13 18:54
https://issues.openbravo.com/file_download.php?file_id=1305&type=bug
jpg

png GLShowAll.png (226,615) 2009-05-28 13:04
https://issues.openbravo.com/file_download.php?file_id=1353&type=bug
png

diff 9027.diff (643) 2009-07-03 17:17
https://issues.openbravo.com/file_download.php?file_id=1510&type=bug
png WithoutFix.png (169,624) 2009-07-08 10:55
https://issues.openbravo.com/file_download.php?file_id=1521&type=bug
png

png WithFix.png (171,669) 2009-07-08 10:55
https://issues.openbravo.com/file_download.php?file_id=1522&type=bug
png
Issue History
2009-05-13 18:54networkbNew Issue
2009-05-13 18:54networkbAssigned To => rafaroda
2009-05-13 18:54networkbFile Added: showAllGL.jpg
2009-05-13 18:54networkbRegression testing => No
2009-05-15 08:21rafarodaAssigned Torafaroda => dalsasua
2009-05-15 10:39vmromanosAssigned Todalsasua => vmromanos
2009-05-15 10:40vmromanosStatusnew => scheduled
2009-05-15 10:40vmromanosfix_in_branch => pi
2009-05-15 18:09vmromanosStatusscheduled => feedback
2009-05-20 12:07networkbPriorityimmediate => high
2009-05-20 12:07networkbStatusfeedback => new
2009-05-20 12:07networkbfix_in_branchpi =>
2009-05-20 12:07networkbSummaryGeneral Ledger Report's appearance is aligned when executed with "show all" selected => General Ledger Report executed with "show all" doesn't respect column's width
2009-05-20 12:07networkbDescription Updated
2009-05-20 12:22networkbAssigned Tovmromanos => dbaz
2009-05-20 12:49psarobeStatusnew => scheduled
2009-05-20 12:49psarobefix_in_branch => pi
2009-05-20 12:50psarobePriorityhigh => immediate
2009-05-20 12:50psarobefix_in_branchpi =>
2009-05-25 10:32dbazNote Added: 0016610
2009-05-25 10:33dbazAssigned Todbaz => rafaroda
2009-05-25 11:21rafarodaNote Added: 0016614
2009-05-25 11:21rafarodaAssigned Torafaroda => dalsasua
2009-05-25 11:47dalsasuaNote Added: 0016618
2009-05-25 11:47dalsasuaAssigned Todalsasua => rafaroda
2009-05-28 10:27rafarodaNote Added: 0016703
2009-05-28 10:27rafarodaStatusscheduled => feedback
2009-05-28 10:53networkbNote Added: 0016708
2009-05-28 10:53networkbAssigned Torafaroda => dbaz
2009-05-28 10:53networkbStatusfeedback => new
2009-05-28 10:56dbazNote Added: 0016712
2009-05-28 10:56dbazAssigned Todbaz => rafaroda
2009-05-28 10:57dalsasuaNote Added: 0016713
2009-05-28 13:04networkbFile Added: GLShowAll.png
2009-05-28 13:04networkbNote Added: 0016727
2009-05-28 13:09rafarodaNote Added: 0016728
2009-05-28 13:09rafarodaAssigned Torafaroda => dbaz
2009-05-28 13:09rafarodaNote Deleted: 0016713
2009-05-28 13:12dbazNote Added: 0016729
2009-05-28 13:12dbazAssigned Todbaz => dalsasua
2009-05-28 13:41dalsasuaNote Added: 0016730
2009-05-28 13:42dalsasuaAssigned Todalsasua => rafaroda
2009-05-28 16:59networkbNote Added: 0016731
2009-05-28 18:24rafarodaNote Added: 0016734
2009-05-28 18:24rafarodaAssigned Torafaroda => dbaz
2009-06-01 09:22rafarodaNote Added: 0016791
2009-06-01 11:42rafarodaAssigned Todbaz => dalsasua
2009-06-01 11:43rafarodaStatusnew => closed
2009-06-01 11:43rafarodaNote Added: 0016801
2009-06-01 11:43rafarodaResolutionopen => no change required
2009-06-02 00:00anonymoussf_bug_id0 => 2799683
2009-06-18 17:51networkbNote Added: 0017430
2009-06-22 19:10networkbAssigned Todalsasua => rafaroda
2009-06-22 19:10networkbStatusclosed => new
2009-06-22 19:10networkbResolutionno change required => open
2009-06-22 19:10networkbNote Added: 0017534
2009-06-22 19:29dbazNote Added: 0017536
2009-07-01 09:23psarobeStatusnew => feedback
2009-07-03 17:17networkbFile Added: 9027.diff
2009-07-03 17:17networkbNote Added: 0017898
2009-07-06 08:53rafarodaAssigned Torafaroda => dalsasua
2009-07-06 08:53rafarodaStatusfeedback => new
2009-07-06 08:54rafarodaStatusnew => scheduled
2009-07-06 08:54rafarodafix_in_branch => pi
2009-07-07 12:06vmromanosNote Added: 0017961
2009-07-07 12:06vmromanosAssigned Todalsasua => networkb
2009-07-07 12:06vmromanosStatusscheduled => feedback
2009-07-08 10:54rafarodaNote Added: 0018009
2009-07-08 10:54rafarodaAssigned Tonetworkb => rafaroda
2009-07-08 10:54rafarodaStatusfeedback => new
2009-07-08 10:54rafarodafix_in_branchpi =>
2009-07-08 10:55rafarodaFile Added: WithoutFix.png
2009-07-08 10:55rafarodaFile Added: WithFix.png
2009-07-08 10:56rafarodaStatusnew => acknowledged
2009-07-10 16:06hgbotCheckin
2009-07-10 16:06hgbotNote Added: 0018112
2009-07-10 16:06hgbotStatusacknowledged => resolved
2009-07-10 16:06hgbotResolutionopen => fixed
2009-07-10 16:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/672dad0c98b0e1d7e4adcbf7068cbaab5323f281 [^]
2009-07-21 16:24psarobeFixed in Version => 2.50MP3
2009-07-21 16:26psarobeTag Attached: 250MP3releasecandidate
2009-07-27 19:38psarobeStatusresolved => closed
2009-07-27 19:38psarobeNote Added: 0018635

Notes
(0016610)
dbaz   
2009-05-25 10:32   
The only possible solution is set a fixed width of each column (the maximun column with should be asked to Localization team, because once the maximun is reached it won't be able to see any more digit of a column).
(0016614)
rafaroda   
2009-05-25 11:21   
David,

Could you please see if the solution proposed by dbaz is valid?

Thanks.
(0016618)
dalsasua   
2009-05-25 11:47   
Hi,

In my opinion, it's not necessary to change the standard code, because it would imply a lot of testing to check that continues to work trough several browsers and screen resolutions. I would apply the proposed solution from David to the customer that reports the bug, and just test it in their environment. It is true that a financial report is not well built if columns are not aligned from one block to another, but the official report is the one printed through the pdf file, and this is correctly built. The html report is just a draft view of the report, to easy check and look up numbers.

Once this is clear, I would say that the width of each column would be:

date column: necessary to show the text '99-99-9999'
dates debit, credit and total columns: necessary with to show the text '-999.999.999,99'
description column: the rest of available width

Regards.
(0016703)
rafaroda   
2009-05-28 10:27   
This issue is waiting for feedback regarding David Alsasua suggestion.
(0016708)
networkb   
2009-05-28 10:53   
David,

Could you please explain why % width does not work?

Thanks
(0016712)
dbaz   
2009-05-28 10:56   
Because the text contained in the cells exceeds the %
(0016727)
networkb   
2009-05-28 13:04   
We have been doing some tests and we have realized that in GeneralLedgerReport.html, there is a table which first row has width=100% so it is doing that the rest of width columns are not being respected.

Modifying this and adjusting % width related to DAL indications above, we will make % work and appearance will be aligned and adapted to text.

(screenshot attached GLShowAll.png)
(0016728)
rafaroda   
2009-05-28 13:09   
David Baz,

Do you think that the fix proposed by networkb should be included in Openbravo ERP?

If so please schedule the issue.

Thanks.
(0016729)
dbaz   
2009-05-28 13:12   
Since it is a particular report and not a standard behaviour for all the application, localization team should take the decision...

I reasign it to David Alsasua
(0016730)
dalsasua   
2009-05-28 13:41   
In my opinion, this should be applied only to the reporter's environment. This change of the report, makes it expand horizontally as much as needed, no matter if description is so large that the width of the report is much bigger than the width of the filters section. This is not comfortable for lower resolution monitors, and breaks the standard behavior of the ERP.

Regards.
(0016731)
networkb   
2009-05-28 16:59   
Just one final doubt: the only thing that we have done is to change the following line "<TD width="100%" class="DataGrid_Header_Cell">Cliente<SPAN id="fieldPartner2"></SPAN></TD>" by this other one "<TD colspan="5" class="DataGrid_Header_Cell">Cliente<SPAN id="fieldPartner2"></SPAN></TD></TR>" in ReportGeneralLedger.html file.

The behavior which follows the report when description is too large expanding horizontally as much as needed (being bigger than the width of the filters section, if necessary) is due to clause "style=table-layout: auto;" which is set in the standard pattern of table definition... so it is following the standard behavior, isn't it?

In case we want that reports data don't exceed filters section, we will need to set "style=table-layout: fixed;" and revise other table definitions...
(0016734)
rafaroda   
2009-05-28 18:24   
David Baz,

Any comment on this?

Thanks.
(0016791)
rafaroda   
2009-06-01 09:22   
Reminder sent to: dbaz

David Baz, could you please determine whether there is an issue in the HTML coding of this report?

Thanks.
(0016801)
rafaroda   
2009-06-01 11:43   
According to David Alsasua, this issue will not be fixed in standard Openbravo ERP but change can be applied to the customer.
(0017430)
networkb   
2009-06-18 17:51   
Hi again,

We would like to understand why this bug was closed once we had located the problem and without known David Baz's opinion. Because of that, we continue having the same doubt:

"the only thing that we have done is to change the following line "<TD width="100%" class="DataGrid_Header_Cell">Cliente<SPAN id="fieldPartner2"></SPAN></TD>" by this other one "<TD colspan="5" class="DataGrid_Header_Cell">Cliente<SPAN id="fieldPartner2"></SPAN></TD></TR>" in ReportGeneralLedger.html file.

The behavior which follows the report when description is too large expanding horizontally as much as needed (being bigger than the width of the filters section, if necessary) is due to clause "style=table-layout: auto;" which is set in the standard pattern of table definition... so it is following the standard behavior, isn't it?

In case we want that reports data don't exceed filters section, we will need to set "style=table-layout: fixed;" and revise other table definitions..."

Thanks
(0017534)
networkb   
2009-06-22 19:10   
Hi again,

We would like to understand why this bug was closed once we had located the problem and without known David Baz's opinion. Because of that, we continue having the same doubt:

"the only thing that we have done is to change the following line "<TD width="100%" class="DataGrid_Header_Cell">Cliente<SPAN id="fieldPartner2"></SPAN></TD>" by this other one "<TD colspan="5" class="DataGrid_Header_Cell">Cliente<SPAN id="fieldPartner2"></SPAN></TD></TR>" in ReportGeneralLedger.html file.

The behavior which follows the report when description is too large expanding horizontally as much as needed (being bigger than the width of the filters section, if necessary) is due to clause "style=table-layout: auto;" which is set in the standard pattern of table definition... so it is following the standard behavior, isn't it?

In case we want that reports data don't exceed filters section, we will need to set "style=table-layout: fixed;" and revise other table definitions..."

Thanks
(0017536)
dbaz   
2009-06-22 19:29   
Hi networkb

At the end after reading your question I don't understand if with "style=table-layout: fixed;" you have finally succeed to fix the bug or not. If the answer is "yes" it is ok for me.

Even more, since this "bug" is only going to be fixed in your client, any solution that you find which has your client's agree is valid.
(0017898)
networkb   
2009-07-03 17:17   
Hi,

I attach the file we have applied to our customer.
(0017961)
vmromanos   
2009-07-07 12:06   
It seems that the bug is already fixed in the customer's environment and, from Engineering, we have decided not to change core. Shall we close the bug or do you need more clarifications?
(0018009)
rafaroda   
2009-07-08 10:54   
I do agree that ReportGeneralLedger.html has an issue in lines:
<div id="sectionPartner">
  <table border="1" cellspacing="0" cellpadding="0" width="90%" class="DataGrid_Header_Table DataGrid_Body_Table" style="table-layout: auto;">
    <tr class="DataGrid_Body_Row">
      <td width="100%" class="DataGrid_Header_Cell">Customer
         <span id="fieldPartner2"></span></td>
    </tr>

which should be replaced by:
<div id="sectionPartner">
  <table border="1" cellspacing="0" cellpadding="0" width="90%" class="DataGrid_Header_Table DataGrid_Body_Table" style="table-layout: auto;">
    <tr class="DataGrid_Body_Row">
      <td colspan="5" class="DataGrid_Header_Cell">Customer
        <span id="fieldPartner2"></span></td>
    </tr>

The current behavior looks like WithoutFix.png where the Date column takes too much width.

Applying the fix, WithFix.png, Date column takes a reasonable width but Description cell keeps being the one on which the other cells' width are based.
(0018112)
hgbot   
2009-07-10 16:06   
Repository: erp/devel/pi
Changeset: 672dad0c98b0e1d7e4adcbf7068cbaab5323f281
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Fri Jul 10 16:05:48 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/672dad0c98b0e1d7e4adcbf7068cbaab5323f281 [^]

Fixes issue 0009027 Replaced width=\\"100%\\" by colspan=\\"5\\" to construct ReportGeneralLedger.html properly.

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.html
---
(0018635)
psarobe   
2009-07-27 19:38   
Following Withfix.png image, the bug seems to be fixed