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

Functions and expressions

Pentaho Reporting provides many functions and expressions that may be used during report creation. A function in Pentaho Reporting is used to calculate a computed value, while an expression in Pentaho Reporting is a function whose scope is limited to the current dataset row. A function may maintain state, having access to many rows of data.

Functions and expressions in Report Designer

Starting from the Report Designer user interface, functions and expressions live in two different places because their scope is different. Functions can be found in report explorer, in particular, in the Data tab under the Functions group. The following screenshot shows how the report explorer looks with two functions defined:

Expressions, being related to the dataset, live in a different place: in the element properties panel. In particular, expressions live on each property of the panel, in the fourth column of the table showing an icon. There are two possible icons: the green plus...