Book Image

Pentaho 8 Reporting for Java Developers

By : Jasmine Kaur, Francesco Corti
Book Image

Pentaho 8 Reporting for Java Developers

By: Jasmine Kaur, Francesco Corti

Overview of this book

This hands-on tutorial, filled with exercises and examples, introduces the reader to a variety of concepts within Pentaho Reporting. With screenshots that show you how reports look at design time as well as how they should look when rendered as PDF, Excel, HTML, Text, Rich-Text-File, XML, and CSV, this book also contains complete example source code that you can copy and paste into your environment to get up-and-running quickly. Updated to cover the features of Pentaho 8, this book will teach you everything you need to know to build fast, efficient reports using Pentaho. If your interest lies in the technical details of creating reports and you want to see how to solve common reporting problems with a minimum of fuss, this is the book for you.

Related Content you might be interested in

Current Title:

Small book image
Pentaho 8 Reporting for Java Developers
Jasmine Kaur | Francesco Corti
Sep, 2017 | 470 pages
Small book image
Learning Pentaho Data Integration 8 CE
María Carina Roldán
Dec, 2017 | 500 pages
Table of Contents (25 chapters)
Title Page
Title Page
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Customer Feedback
Customer Feedback
Dedication
Dedication
Preface
Preface
Free Chapter
1
Introduction to Pentaho Reporting
Introduction to Pentaho Reporting
Introducing Pentaho Reporting
Typical uses of Pentaho Reporting
Pentaho Reporting history
Feature overview
Pentaho Reporting architecture
Summary
2
Getting Started with Report Designer
Getting Started with Report Designer
Prerequisites of your environment
Setting up the Pentaho Report Designer
Introduction to the user interface
Creating your first report using the wizard
Previewing the report
Saving and opening the report
Summary
3
Getting Started with Reporting SDK
Getting Started with Reporting SDK
Obtaining the Pentaho Reporting SDK
Creating a web application using Pentaho Reporting and Maven
Summary
4
Creating a Report with Report Designer
Creating a Report with Report Designer
Creating a Pentaho report
Customizing Pentaho reports
Previewing Pentaho reports in different formats
Train yourself to learn faster
Summary
5
Design and Layout in Report Designer
Design and Layout in Report Designer
Report Designer user interface components
Master report and report bands properties
Report elements
Hiding and showing bands
Visual layout in Report Designer
Pentaho Report Designer shortcut keys
Considerations for different output formats
Summary
6
Configuring JDBC and Other Data Sources
Configuring JDBC and Other Data Sources
Introducing data sources
The JDBC data source
The metadata data source
The MongoDB data source
The Pentaho Data Integration data source
The OLAP data source
The XML data source
The table data source
The advanced data source
The Pentaho community data access data source
Summary
7
Including Graphics and Charts in Reports
Including Graphics and Charts in Reports
Including static images in reports
Including dynamic images in reports
Including charts in reports
Including sparkline charts in reports
Summary
8
Parameterization, Functions, Variables, and Formulas
Parameterization, Functions, Variables, and Formulas
Report parameterization
Functions and expressions
Environment variables
Working with formulas
Summary
9
Internationalization and Localization
Internationalization and Localization
Internationalization and localization
Using resources to localize elements
Resources for localization
Testing the localization
An example of report localization
Summary
10
Subreports and Cross Tabs
Subreports and Cross Tabs
Subreports in Pentaho Report Designer
Table of contents and index elements
Cross tabs in Pentaho Report Designer
Summary
11
The PRPT Format and the Java API to Build It
The PRPT Format and the Java API to Build It
Understanding the serialized report format
Building a report using Pentaho Reporting Java API
Summary
12
Developing Using Data Sources
Developing Using Data Sources
Pentaho Reporting Engine Data API
Existing DataFactory implementations
Summary
13
Internationalization, Subreports, and Cross Tabs Using Java
Internationalization, Subreports, and Cross Tabs Using Java
Internationalization and localization using Java
Subreports using Java
Cross tab using Java
Summary
14
Building Interactive Reports
Building Interactive Reports
Interactive reports in HTML
Example of interactive reports using Java
Summary
15
Using Reports in Pentaho Business Analytics Platform
Using Reports in Pentaho Business Analytics Platform
Introducing Pentaho Business Analytics Platform
Publishing a report in the Business Analytics Platform
Previewing a report
Managing permits and schedule
Creating a dashboard with Pentaho reports
Summary
16
Using Reports in Pentaho Data Integration
Using Reports in Pentaho Data Integration
Introducing Pentaho Data Integration
Introduction of Spoon client
The Pentaho Reporting output step
Introducing Pan and Kitchen
Creating a transformation with Pentaho reports
Summary
17
Pentaho Reporting Nightly Build and Support
Pentaho Reporting Nightly Build and Support
Pentaho Report Designer nightly build
Pentaho Reporting SDK nightly build
Getting help from the community
What to do once you become an expert
Summary

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...

Previous Section
End of Section 5
Next Section