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

Regression: Sheetname style expression used on group header does not set the first sheet's sheetname

    Details

    • 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.
    • Operating System/s:
      Windows XP

      Description

      I have a report I started creating in 3.7-RC1. I have opened it in 3.8 without saving and I have a copy that was modified in 3.8.

      I have the Report Header sheetname property set to "Summary" then I have a page-break-before = true on the group header and have the group header "sheetname" property set with a style expression (="Const value " & [my_group_field]).

      In 3.7-RC1 and 3.7 GA this way of setting the worksheet name with a style-expression works fine. I can open up this report and run it in 3.7 and it breaks where I want and each of the sheets are named with the expression using the value of my group field. Even the report modified in 3.8 opens fine in 3.7 and the style expression still works.

      In 3.8 the first group sheet after the page break is called "Sheet 1" while the second sheet uses my expression.
      Since the group header is empty I have tried making it visible and invisible with no effect. I have also tried putting these two properties (page break and sheetname) at the Group level instead of the group header - again no effect.

      1. Copy of Refund Report 19.prpt
        17 kB
        britebyte
      2. page break excel sheet.prpt
        4 kB
        Kurtis Cruzada
      3. PRD-3431-1.prpt
        5 kB
        Thomas Morgner

        Activity

        Hide
        kcruzada Kurtis Cruzada added a comment -

        Can you attach your report?

        Show
        kcruzada Kurtis Cruzada added a comment - Can you attach your report?
        Hide
        britebyte britebyte added a comment -

        Hi, Here is the report. Apologies for the delay.

        Show
        britebyte britebyte added a comment - Hi, Here is the report. Apologies for the delay.
        Hide
        tmorgner Thomas Morgner added a comment -

        A simplified version of the report used to show the bug.

        Show
        tmorgner Thomas Morgner added a comment - A simplified version of the report used to show the bug.
        Hide
        tmorgner Thomas Morgner added a comment -

        Fixed.

        Show
        tmorgner Thomas Morgner added a comment - Fixed.
        Hide
        kcruzada Kurtis Cruzada added a comment -

        PRD-3431-1.prpt.... It still says "Sheet 1" instead of the name AuthorPublisher A. However, if I create the report from scratch it works fine (attached).

        Show
        kcruzada Kurtis Cruzada added a comment - PRD-3431 -1.prpt.... It still says "Sheet 1" instead of the name AuthorPublisher A. However, if I create the report from scratch it works fine (attached).
        Hide
        tmorgner Thomas Morgner added a comment -

        Fixed. There was a condition where zero rows where processed after the processing of the report-header. This triggered the creation of the second sheet before there was a group-header providing the sheetname.

        Show
        tmorgner Thomas Morgner added a comment - Fixed. There was a condition where zero rows where processed after the processing of the report-header. This triggered the creation of the second sheet before there was a group-header providing the sheetname.

          People

          • Assignee:
            kcruzada Kurtis Cruzada
            Reporter:
            britebyte britebyte
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: