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

Environment variables

If you are publishing your Pentaho reports to the Business Analytics Platform (see Chapter 15, Using Reports in Pentaho Business Analytics Platform for an introduction), you can use certain environment variables to customize and control the behavior. The environment variables are available by default in a Pentaho report when it's created, and they live in the Data tab of the report explorer. The following screenshot shows how the report explorer looks with the environment variable expanded:

Environment variable can be used as usual, by dragging and dropping it into the right place of the report. The following is a list of the variables with brief descriptions of their meanings:

Name	Description
`env:hostColonPort`	The hostname and port number for the Business Analytics Platform.
`env:locale`	Info about locale of the client requesting the report. `env:locale-language` and `env:locale-short` are other two variables available.
`env:pentahoBaseURL`	The complete URL to the Business Analytics...