Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-3080

The applying of Data Formatting has changed compared to version 3.6.GA

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 3.6.1 GA [3.6.0 GA (Platform Release)]
    • Component/s: None
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      Look at the attached sample report.
      Look in particular to the column Nr of FTE
      For date : 01-10-2010 the value is 20, when shown in the designer version 3.6

      When you look at it in the latest designer (build 4238), you will notice that the formating is gone, the value 19,937 is shown.
      I could fix this by setting "data-format" to false. In 3.6 changing this flag does not have any effect, so i assume the behaviour changed because the bug is fixed.
      This behaviour is anoying, as i need to rework a lot of existing reports.

      What happens then is unacceptable. Change the "data-format" to false, the value displayed is 19. The value is not rounded correctly!!!!!!!!!! it is truncated.

      1. incompatibility.xml
        6 kB
        Kurtis Cruzada
      1. 3.6.1.png
        175 kB
      2. 3.6.1ga.png
        175 kB
      3. 3.6.1GA.png
        175 kB
      4. 3.6 report output.jpg
        57 kB
      5. 3.7 output (corrected).jpg
        65 kB
      6. 3.7 report output (not corrected).jpg
        67 kB
      7. prd3.6.1.png
        175 kB

        Activity

        Hide
        kcruzada Kurtis Cruzada added a comment -

        This is fixed. The problem is with the incompatibility.xml had a comma for the decimal. On English machines, the comma wasn't being treated as a decimal. I attached a new file that contains the period for the decimal.

        Show
        kcruzada Kurtis Cruzada added a comment - This is fixed. The problem is with the incompatibility.xml had a comma for the decimal. On English machines, the comma wasn't being treated as a decimal. I attached a new file that contains the period for the decimal.
        Hide
        wgorman Will Gorman (Inactive) added a comment -

        This fix was also included in reporting patch 3.7.0.1

        Show
        wgorman Will Gorman (Inactive) added a comment - This fix was also included in reporting patch 3.7.0.1
        Hide
        jagdeesh.ss Jagdeesh.SS (Inactive) added a comment -

        Hi Kurtis,

        The rounding issue seems to be working fine in 3.8GA after applying the patch "libformat-1.2.4.jar".
        But, in PRD 3.6.1GA the problem seem to persist.

        I have attached a report file and the related screenshot which is a preview within the report designer.

        a.Odd numbers are rounding correctly Eg: 1.0 - 1 and 1.5 - 2
        b.There is an issue rounding the even numbers, Eg:2.0 - 2 and 2.5 - 2

        So, kindly let us know how to go about this scenario using PRD 3.6.1GA.Is there any workaround as such?

        Thanks,
        Jagdeesh

        Show
        jagdeesh.ss Jagdeesh.SS (Inactive) added a comment - Hi Kurtis, The rounding issue seems to be working fine in 3.8GA after applying the patch "libformat-1.2.4.jar". But, in PRD 3.6.1GA the problem seem to persist. I have attached a report file and the related screenshot which is a preview within the report designer. a.Odd numbers are rounding correctly Eg: 1.0 - 1 and 1.5 - 2 b.There is an issue rounding the even numbers, Eg:2.0 - 2 and 2.5 - 2 So, kindly let us know how to go about this scenario using PRD 3.6.1GA.Is there any workaround as such? Thanks, Jagdeesh
        Hide
        tmorgner Thomas Morgner added a comment -

        There is no fix for 3.6.1, as 3.6.1 uses the JDK classes for formatting numbers. Therefore there is no way we can patch that safely. Upgrade.

        Show
        tmorgner Thomas Morgner added a comment - There is no fix for 3.6.1, as 3.6.1 uses the JDK classes for formatting numbers. Therefore there is no way we can patch that safely. Upgrade.
        Hide
        tmorgner Thomas Morgner added a comment -

        FYI: The rounding to even numbers is just the american way of rounding, and is the default behaviour of the JDK.

        Show
        tmorgner Thomas Morgner added a comment - FYI: The rounding to even numbers is just the american way of rounding, and is the default behaviour of the JDK.

          People

          • Assignee:
            kcruzada Kurtis Cruzada
            Reporter:
            begunrom gunter rombauts
          • Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: