Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 3.8.0 (3.8.0 GA Platform Release)
    • Component/s: Charting
    • Labels:
      None
    • Environment:
      both OSX and Ubuntu 10.10
    • 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

      in NL, dates are written as dd-MM-yyyy. PRD keeps outputting yyyy-MM-dd, even though default is set as dd-MM-yyyy in PRD settings, locale is set as nl_NL, and y-axis date format as dd-MM-yyyy. I'd hate to propose using BIRT to this customer, but for this case, this is a blocker

      1. dateformat.prpt
        5 kB
        Thomas Morgner
      2. PRD-3420.prpt
        5 kB
        Thomas Morgner

        Activity

        Hide
        jvdongen Jos van Dongen added a comment -

        I mean the 'X' axis of course. Btw, rotating of the labels doesn't work either

        Show
        jvdongen Jos van Dongen added a comment - I mean the 'X' axis of course. Btw, rotating of the labels doesn't work either
        Hide
        kcruzada Kurtis Cruzada added a comment -

        updated the summary to X-Axis instead of Y-Axis per Jos' comment.

        Show
        kcruzada Kurtis Cruzada added a comment - updated the summary to X-Axis instead of Y-Axis per Jos' comment.
        Hide
        kcruzada Kurtis Cruzada added a comment -

        We should address this.

        Show
        kcruzada Kurtis Cruzada added a comment - We should address this.
        Hide
        tmorgner Thomas Morgner added a comment -

        This is a quirk in the way the legacy charts work for categorical charts.

        X-Axis works fine for date-formats, provided you set either a date or a number format. If you set a number format, then this will take precedence over the date-format. So make sure that if you set the date format, you clear the "numeric-format" property first.

        There is nothing I can fix without breaking all existing reports that use these format strings. The thing has been ill-defined in the past.

        The property "x-axis-label-rotation" works as well.

        There is a second property called "label-rotation" along with the "show-labels" property. This one controls the value-labels that are printed on the data-items and it works once the "show-labels" property is set to "show labels". These two properties make no sense in the "X-axis grouping". (PRD-3461 asks for moving these properties away from the x-axis).

        Show
        tmorgner Thomas Morgner added a comment - This is a quirk in the way the legacy charts work for categorical charts. X-Axis works fine for date-formats, provided you set either a date or a number format. If you set a number format, then this will take precedence over the date-format. So make sure that if you set the date format, you clear the "numeric-format" property first. There is nothing I can fix without breaking all existing reports that use these format strings. The thing has been ill-defined in the past. The property "x-axis-label-rotation" works as well. There is a second property called "label-rotation" along with the "show-labels" property. This one controls the value-labels that are printed on the data-items and it works once the "show-labels" property is set to "show labels". These two properties make no sense in the "X-axis grouping". ( PRD-3461 asks for moving these properties away from the x-axis).
        Hide
        tmorgner Thomas Morgner added a comment -

        Does this address the issue?

        Show
        tmorgner Thomas Morgner added a comment - Does this address the issue?
        Hide
        jvdongen Jos van Dongen added a comment -

        Nope, but it's an acceptable workaround. As for "X-Axis works fine for date-formats, provided you set either a date or a number format. If you set a number format, then this will take precedence over the date-format. So make sure that if you set the date format, you clear the "numeric-format" property first.": nope, I haven't set a number format, only date format is set to dd-MM-yyyy but PRD keeps displaying yyyy-MM-dd. But with a formula =DAY([ORDERDATE]) & "" & MONTH([ORDERDATE]) & "" & YEAR([ORDERDATE]) on the X-axis it works. Not pretty, but workable

        Show
        jvdongen Jos van Dongen added a comment - Nope, but it's an acceptable workaround. As for "X-Axis works fine for date-formats, provided you set either a date or a number format. If you set a number format, then this will take precedence over the date-format. So make sure that if you set the date format, you clear the "numeric-format" property first.": nope, I haven't set a number format, only date format is set to dd-MM-yyyy but PRD keeps displaying yyyy-MM-dd. But with a formula =DAY( [ORDERDATE] ) & " " & MONTH( [ORDERDATE] ) & " " & YEAR( [ORDERDATE] ) on the X-axis it works. Not pretty, but workable
        Hide
        tmorgner Thomas Morgner added a comment -

        Then I am totally lost and would not be able to fix it without a replication report that shows the buggy behaviour. I simply do not see the sort of behaviour you are seeing.

        Show
        tmorgner Thomas Morgner added a comment - Then I am totally lost and would not be able to fix it without a replication report that shows the buggy behaviour. I simply do not see the sort of behaviour you are seeing.
        Hide
        tmorgner Thomas Morgner added a comment -

        Fixed.

        There was no property for formatting the
        x-axis-ticks. The existing properties controlled the
        item-label, and that really confused me. I moved them
        out into a new group, so that the risk is minimized.

        You now find a new property "x-axis-tick-format" in
        all categorical charts. This is a message format string
        and with that you now can configure your ticks in any
        way you want. There is only one argument set, so only
        the

        {0,..}

        works, of course.

        Show
        tmorgner Thomas Morgner added a comment - Fixed. There was no property for formatting the x-axis-ticks. The existing properties controlled the item-label, and that really confused me. I moved them out into a new group, so that the risk is minimized. You now find a new property "x-axis-tick-format" in all categorical charts. This is a message format string and with that you now can configure your ticks in any way you want. There is only one argument set, so only the {0,..} works, of course.
        Hide
        tmorgner Thomas Morgner added a comment -

        A sample report.

        Show
        tmorgner Thomas Morgner added a comment - A sample report.

          People

          • Assignee:
            kcruzada Kurtis Cruzada
            Reporter:
            jvdongen Jos van Dongen
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: