Pentaho 8 Reporting for Java Developers

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.

Title Page

Credits

About the Author

About the Author

About the Reviewers

About the Reviewers

www.PacktPub.com

www.PacktPub.com

Customer Feedback

Customer Feedback

Dedication

Preface

Free Chapter

Introduction to Pentaho Reporting

Introduction to Pentaho Reporting

Introducing Pentaho Reporting

Typical uses of Pentaho Reporting

Pentaho Reporting history

Feature overview

Pentaho Reporting architecture

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

Getting Started with Reporting SDK

Getting Started with Reporting SDK

Obtaining the Pentaho Reporting SDK

Creating a web application using Pentaho Reporting and Maven

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

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

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

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

Parameterization, Functions, Variables, and Formulas

Parameterization, Functions, Variables, and Formulas

Report parameterization

Functions and expressions

Environment variables

Working with formulas

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

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

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

Developing Using Data Sources

Developing Using Data Sources

Pentaho Reporting Engine Data API

Existing DataFactory implementations

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

Building Interactive Reports

Building Interactive Reports

Interactive reports in HTML

Example of interactive reports using Java

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

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

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

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Summary

In this chapter, you learnt everything Pentaho Report Designer can do with data sources, discovering all the available types and their specific features. You started with an introduction to how a data source looks in the user interface and how the fields are used in the layout of the report. Then you moved on to discover how to manage all the possible types of data sources using Report Designer, finding out all about:

The JDBC data source
The metadata data source
The MongoDB data source
The Pentaho Data Integration transformation data source
The OLAP data source in various versions (legacy and generic, normalized and denormalized, standard, and custom)
The XML data source
The table data source
The advanced data sources (scriptable, external, sequence generator, and OpenERP)
The Pentaho community data access data source

Now that you have read this chapter, you should feel comfortable with all the ways Pentaho Report Designer offers to connect to a source. This is the very first step to go through...