• Problem reports
  • V5 - (1412) Are the summaries in the reference grids broken?

I'm not sure if it is because I do not understand how to use the new grid group summary feature or if it is broken. I will detail an example of what I am experiencing and hopefully this will shed light on whether this is a lack of knowledge or application problem.

SETUP
Using the Ordering application I selected the Items reference grid from the 'PurchaseOrder' business object. I selected grouping and updated the Items grid to group on 'ProductName'. I then selected 'Display summary for each group' and put a check in the 'Display' column for 'Amount'. The calculation was updated to SUM and the presentation remained {Value}.

EXECUTION
When viewing the application using Firefox 3.6.16 I opened the Purchase order for Aware IM Server port for Lucy Jackson that includes 3 separate items:

EPSON DB T073390 Magenta Ink - 30.00
EPSON RX650 Multi-Function - 219.50
PANASONIC 32in Integrated HD LCD TV - 1,199.50

Each displays in a separate group and a summary is displayed for each.

Here is the problem:

30.00 is displayed as 30
219.50 is displayed as 219.5
1,199.50 is displayed as 1

I tried this same example in a separate bsv and found that the summary always breaks at the comma (e.g. 219,050 displays as 219 in the summary).

Two questions:

  1. Is there a way to control the output so that the formatting in the summary is the same as the format set at the attribute level?

  2. Is there a way to make anything to the right of the comma display or is this a bug?

9 days later