Pentaho 8 Reporting for Java Developers电子书

Title Page

Copyright

Pentaho 8 Reporting for Java Developers

Credits

About the Author

About the Reviewers

www.PacktPub.com

Why subscribe?

Customer Feedback

Dedication

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Downloading the color images of this book

Errata

Piracy

Questions

Introduction to Pentaho Reporting

Introducing Pentaho Reporting

Introducing Pentaho Reporting tools

Types of users and required knowledge

Technological advantages

A business friendly open source license

Typical uses of Pentaho Reporting

Operational reporting

Business intelligence reporting

Financial reporting

Production reporting

Pentaho Reporting history

Feature overview

An advanced reporting algorithm

A multitude of available data sources

A wide variety of output formats

Pixel accurate rich formatting

Embedded charts

Report parameterization

Formulas and style expressions

Subreports

Cross tab reports

Interactive reporting

Rich authoring tools

Reporting server

Java API for building reports

Extensibility

Pentaho reporting website

Pentaho Reporting architecture

Reporting Engine's libraries

Reporting Engine core

Reporting Engine extensions

Summary

Getting Started with Report Designer

Prerequisites of your environment

Setting up the Pentaho Report Designer

The SamplaData schema

Introduction to the user interface

Menu and toolbar

Report element palette

Report canvas tab

Report explorer

Element properties

Messages

Creating your first report using the wizard

Introducing the Report Design Wizard

Defining the look and feel

Defining the data source and query

Defining the layout

Formatting the fields

Previewing the report

Saving and opening the report

Summary

Getting Started with Reporting SDK

Obtaining the Pentaho Reporting SDK

Anatomy of the Pentaho Reporting SDK

Using the included Eclipse project

Introducing the included examples

Creating a web application using Pentaho Reporting and Maven

Prerequisites of your environment

Creating a web application in Java

Creating a Java web application using Apache Maven

Creating the first page of the Java web application

Including Pentaho Reporting Engine in a web application

Adding the Pentaho repository

Adding the Pentaho dependencies

Showing an existing Pentaho report in a web application

Including an existing Pentaho report

Including the SampleData schema

Updating the PentahoServlet

Previewing the Pentaho report

Summary

Creating a Report with Report Designer

Creating a Pentaho report

Creating a new Pentaho report

Creating a datasource in Pentaho reports

Adding details to Pentaho reports

Previewing and saving a Pentaho report

Customizing Pentaho reports

Customizing the font

Customizing the report header

Adding the details header and customizing the details

Customizing the page footer

Grouping the details

Adding charts

Previewing Pentaho reports in different formats

Train yourself to learn faster

Summary

Design and Layout in Report Designer

Report Designer user interface components

The Structure tab in report explorer

The report element properties

Master report and report bands properties

Common properties

Size and position properties

Font, text, and text-spacing properties

Font properties

Text properties

Text-spacing properties

Object properties

Links properties

Excel properties

Page-behaviour properties

Padding properties

Border properties

Common properties in attributes

Query-metadata properties

Wizard properties

HTML properties

Excel properties in attributes

HTML-events, PDF-events, and Swing-events properties

HTML-events properties

Pdf-events properties

Swing-events properties

Master Report properties

Size and position properties

Text properties

Page-behaviour properties

Query properties

Common properties in the attributes tab

Wizard properties

Excel properties

Advanced properties

Pentaho properties

Page Header and Page Footer properties

Report Header and Report Footer properties

Group Header and Group Footer properties

Details body properties

Watermark properties

Report elements

Common properties

Size and position properties

Font properties

Text and text-spacing properties

Rotation properties

Object properties

Links properties

Excel properties

Page-behavior properties

Padding and border properties

Common properties in attributes

Query-metadata properties

Wizard properties

HTML properties

Excel properties in attributes

HTML-event, pdf-events, Swing-events properties

Label and message

Fields and resources

Image and image-field

Vertical-line, horizontal-line, rectangle, and eclipse

Survey-scale

Chart

Simple-barcodes

Bar-sparkline, line-sparkline, and pie-sparkline

Band

Sub-report

Table-of-content and index

Hiding and showing bands

Visual layout in Report Designer

The grid

Guide lines

Additional visual indicators

Moving and aligning single elements

Aligning groups of elements

Miscellaneous layout capabilities

Pentaho Report Designer shortcut keys

Considerations for different output formats

Cell output

Paging

Limits to rich graphics and charts

Summary

Configuring JDBC and Other Data Sources

Introducing data sources

Datasets in report explorer

The JDBC data source

Adding or editing a JDBC connection

About the JNDI access

Adding or editing a query

The metadata data source

The MongoDB data source

The Pentaho Data Integration data source

The OLAP data source

Pentaho analysis

OLAP4J

Pentaho analysis - custom

The XML data source

The table data source

The advanced data source

Scriptable

External

Sequence generator

OpenERP data access

The Pentaho community data access data source

Summary

Including Graphics and Charts in Reports

Including static images in reports

Including dynamic images in reports

Including charts in reports

Types of datasets

Category dataset

Common properties

Series properties

Group properties

Optional properties

Pie dataset

XY series and XYZ series dataset

Time series dataset

Thermometer dataset

Style and layout common properties

Required properties

Title properties

General properties

Legend properties

Scripting properties

Bar chart

Bar chart example

Line chart

Line chart example

Area chart

Area chart example

Pie chart

Pie chart example

Multipie chart

Multipie chart example

Bar line chart

Bar line chart example

Ring chart

Ring chart example

Bubble chart

Bubble chart example

Scatter plot chart

Scatter plot chart example

XY bar chart, XY line chart, and XY area chart

XY bar chart, XY line chart, and XY area chart examples

Extended XY line chart

Extended XY line chart example

Waterfall chart

Waterfall chart example

Radar chart

Radar chart example

XY area line chart

Thermometer chart

Thermometer chart example

Including sparkline charts in reports

Summary

Parameterization, Functions, Variables, and Formulas

Report parameterization

Using report parameters

The available report parameter types

Creating parameters

Creating a report using parameters

Functions and expressions

Functions and expressions in Report Designer

Creating and using functions

Example of function

Creating and using expressions

Example of expression

The available function types

Common functions

Report functions

Summary functions

Running functions

Advanced functions

Chart data and value data functions

Image functions

Script functions

Table of contents functions

Environment variables

Working with formulas

Creating a formula

The formula syntax

Formula datatypes

Formula operators

The available formula categories

Date or time formulas

Database formulas

Information formulas

Logical formulas

Mathematical formulas

Rounding formulas

Text formulas

User-defined formulas

Summary

Internationalization and Localization

Internationalization and localization

Using resources to localize elements

Resources for localization

Managing resource bundles

Testing the localization

An example of report localization

Summary

Subreports and Cross Tabs

Subreports in Pentaho Report Designer

Subreport example

Other subreport examples

Table of contents and index elements

Example of index

Cross tabs in Pentaho Report Designer

Cross tab examples

Summary

The PRPT Format and the Java API to Build It

Understanding the serialized report format

Anatomy of a .prpt bundle file

The datadefintion.xml file and datasources folder

Parameters

Data source reference

Functions and expressions

Datasources folder

layout.xml file

Group and detail band hierarchy

Report elements

settings.xml file

styles.xml file

Manual creation of a .prpt bundle file

Building a report using Pentaho Reporting Java API

Adding a data source

Defining parameters

Including functions and expressions

Defining the report layout

Common report bands

Group band hierarchy

Adding elements to the report

Adding a label element

Adding a chart element

Developing an example of Pentaho report

Summary

Developing Using Data Sources

Pentaho Reporting Engine Data API

The DataFactory interface

The TableModel interface

DataFactory serialization

Additional data source metadata

Accessing data throughout a report

Existing DataFactory implementations

TableDataFactory

TableDataFactory example

SQLReportDataFactory

StaticConnectionProvider

DriverConnectionProvider

JndiConnectionProvider

Using SQLReportDataFactory

SQLReportDataFactory example

XPathDataFactory

XPathDataFactory example

HQLDataFactory

StaticSessionProvider

DefaultSessionProvider

PmdDataFactory

XMI file

Domain Id

IPmdConnectionProvider

PmdDataFactory example

KettleDataFactory

KettleDataFactory example

BandedMDXDataFactory and DenormalizedMDXDataFactory

BandedMDXDataFactory

DenormalizedMDXDataFactory

BandedMDXDataFactory example

CompoundDataFactory

ScriptableDataFactory

Summary

Internationalization, Subreports, and Cross Tabs Using Java

Internationalization and localization using Java

Resources for localization using Java

Testing the localization using Java

An example of report localization using Java

Subreports using Java

Subreports using Java

An example of subreport using Java

Cross tab using Java

Cross tabs using Java

An example of cross tab using Java

Summary

Building Interactive Reports

Interactive reports in HTML

Manipulating the reporting HTML DOM

Including an external CSS or JavaScript resource

Example of interactive reports using Java

Opening a static URL from a Pentaho report

Opening a dynamic URL from a Pentaho report

Manipulating the content of a Pentaho report

Example of master/details report interaction

Summary

Using Reports in Pentaho Business Analytics Platform

Introducing Pentaho Business Analytics Platform

Installing the Business Analytics Platform

Basics of the Business Analytics Platform

Publishing a report in the Business Analytics Platform

Manually uploading a report

Publishing a report using the Pentaho Report Designer

Managing data sources

Previewing a report

Previewing a report from the browse files page

Previewing a report using a direct link

The bundled report preview

Managing permits and schedule

Creating a dashboard with Pentaho reports

Community dashboard editor basics

Introduction of the report components

PRPT Component

Execute Prpt Component

Schedule PRPT Component

Example of CDE dashboard

Summary

Using Reports in Pentaho Data Integration

Introducing Pentaho Data Integration

Installing Pentaho Data Integration

Basics of Pentaho Data Integration

Jobs and transformations

Steps and entries

Database connections

Storage and reuse

Introduction of Spoon client

The Pentaho Reporting output step

Introducing Pan and Kitchen

Creating a transformation with Pentaho reports

Executing the transformation using Pan

Summary

Pentaho Reporting Nightly Build and Support

Pentaho Report Designer nightly build

Prerequisites for building the project

Cloning the GitHub repository

Building the release

Installing and running the nightly build

Pentaho Reporting SDK nightly build

Updating the pom.xml file

Adding the nightly build libraries

Compiling and running the project

Getting help from the community

Asking questions and helping others

Online documentation

Submitting bugs and viewing backlogs

Contributing code

Enterprise support

What to do once you become an expert

Summary