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

As a reporting user I want to use a default-value formula to get default values for cascading parameters when the parent parameter changes

    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.

      Description

      At the moment, the default value formula is only evaulated if the parameter has a null-value. If the user ends up with an invalid value after changing an other parameter, we should let the default-value-formula jump in again to provide a sensible default.

      Changes needed:
      (1) Change the parameter evaluation so that failed strict parameter checks revalidate with <null> values.
      (2) Change the Swing UI to actually pick up computed values during subsequent parameter updates
      (3) Make all of that configurable on a per-parameter basis via two new flags: "autofill-selection" and "re-evaluate-on-failed-values".

      1. parameter_problem.prpt
        5 kB
        Thomas Morgner
      2. tProduct Sales.prpt
        20 kB
        Thomas Morgner

        Issue Links

          Activity

          Hide
          tmorgner Thomas Morgner added a comment -

          Fixed. If we want to backport it to 3.8 (and I would recommend it as it makes working with params easier), then please reassign to me again with fix for 3.8 marked.

          Show
          tmorgner Thomas Morgner added a comment - Fixed. If we want to backport it to 3.8 (and I would recommend it as it makes working with params easier), then please reassign to me again with fix for 3.8 marked.
          Hide
          tmorgner Thomas Morgner added a comment -

          Showing the working example of using a formula in the default value selection. If the value currently selected becomes invalid (by changing product lines the selected product is invalid), the default value formula is now evaluated and the selection is updated.

          Show
          tmorgner Thomas Morgner added a comment - Showing the working example of using a formula in the default value selection. If the value currently selected becomes invalid (by changing product lines the selected product is invalid), the default value formula is now evaluated and the selection is updated.
          Hide
          tmorgner Thomas Morgner added a comment -

          The report shows the use of a post-processing formula and that its computed value is reflected in the selection. This can be used to correct invalid values (like rounding numbers or correcting texts (all chars upper case or so). Note that the report here is set up in a way that every user-input given for the second parameter is ignored. The post-processing formula always takes precedence.

          Show
          tmorgner Thomas Morgner added a comment - The report shows the use of a post-processing formula and that its computed value is reflected in the selection. This can be used to correct invalid values (like rounding numbers or correcting texts (all chars upper case or so). Note that the report here is set up in a way that every user-input given for the second parameter is ignored. The post-processing formula always takes precedence.
          Hide
          tmorgner Thomas Morgner added a comment -

          Reschedule for 3.8.1-RC and code backported.

          Show
          tmorgner Thomas Morgner added a comment - Reschedule for 3.8.1-RC and code backported.

            People

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

              Dates

              • Created:
                Updated:
                Resolved: