Packt+ | Advance your knowledge in tech

You're reading from Pentaho 8 Reporting for Java Developers Create pixel-perfect analytical reports using reporting tools

Product type Paperback

Published in Sep 2017

Publisher Packt

ISBN-13 9781788298995

Length 470 pages

Edition 1st Edition

Languages

Java

Tools

Pentaho

Concepts

Data Processing

Authors (2):

Francesco Corti

Jasmine Kaur

View More author details

Table of Contents (18) Chapters

Preface

1. Introduction to Pentaho Reporting FREE CHAPTER

2. Getting Started with Report Designer

3. Getting Started with Reporting SDK

4. Creating a Report with Report Designer

5. Design and Layout in Report Designer

6. Configuring JDBC and Other Data Sources

7. Including Graphics and Charts in Reports

8. Parameterization, Functions, Variables, and Formulas

9. Internationalization and Localization

10. Subreports and Cross Tabs

11. The PRPT Format and the Java API to Build It

12. Developing Using Data Sources

13. Internationalization, Subreports, and Cross Tabs Using Java

14. Building Interactive Reports

15. Using Reports in Pentaho Business Analytics Platform

16. Using Reports in Pentaho Data Integration

17. Pentaho Reporting Nightly Build and Support

Working with formulas

In addition to providing functions within reports, formulas may also be used to generate dynamic content in a report. Formulas may be used to derive element property and style values. Also, the Open Formula and Open Formula (Advanced) functions defined earlier may be used to combine the formula and function mechanisms in a report.

Formulas in Pentaho Reporting are based on the Open Formula standard. This standard is similar to Excel formula support, and is used in OpenOffice as well as other tools such as Pentaho Metadata. This formula system is often referred to as LibFormula, which is the library name for reporting's formula subproject.

Creating a formula

As you learnt in the section about functions and expressions, there are two places where Open Formula and Open Formula (Advanced) can be used: in the Data tab of report explorer and in each property expression in the element properties panel. Once Open Formula or Open Formula (Advanced) is requested, the formula editor...