Hitachi Vantara Pentaho Community Wiki
Skip to end of metadata
Go to start of metadata

Available Advanced Calculations

  • CreateGroupAnchorsFunctionAdds an anchor to a group to all elements with the name specified in element.
  • CreateHyperLinksFunctionAdds hyperlinks to all elements (objects) with the name specified in element.
  • ElementColorFunctionA function that alternates between true and false for each item within a group. The function value determines when to use an object's color.
  • ElementVisibilitySwitchFunctionA function that alternates between true and false for each item within a group. The functions value affects a defined objects visibility.
  • HideElementByNameFunctionThis function hides all objects with a given name, as long as the defined field does not contain the element name.
  • HidePageBandForTableExportHide the page header and footer if the current export type is not a pageable export (like printing, PDF or plain text).
  • PageFunctionA report function that counts pages.
  • PageOfPagesFunctionA report function that combines the PageFunction and PageTotalFunction.
  • PageTotalFunctionPrints the total number of pages of an report.
  • property-refExposes values and properties that are available in the reporting object.
  • TextFormatExpressionUses a java.text.MessageFormat to format a string message.
  • No labels

1 Comment

  1. user-beb0e

    Is there any user (non-technical) information for the ElementTrafficLightFunction? I am using version 1.6.0. I set the default color to not set so the field/cell in the report would not change (row banding colors etc) if the values did not fall within the trafficlight min/max limits. I save the change and it works fine as long as I don't close and re-open the report. If I close and re-open the report, the default color reflects the color associated with the 3rd (last) setting. How can I keep the default color to not set?