Pentaho Reporting 3.5 for Java Developers电子书

Pentaho Reporting 3.5 for Java Developers

Pentaho Reporting 3.5 for Java Developers

Credits

Foreword

About the Author

About the Reviewers

Preface

What this book covers

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code for the book

Errata

Piracy

Questions

1. An Introduction to Pentaho Reporting

Typical uses of Pentaho Reporting

Operational reporting

Business intelligence reporting

Financial reporting

Production reporting

Pentaho Reporting history

Pentaho Reporting timeline

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

Sub-reports

Cross Tab Reports

Interactive reporting

Rich authoring tools

Reporting server

Java API for building reports

Extensibility

A business friendly open source license

Pentaho reporting roadmap

Pentaho Reporting architecture

LibBase

LibDocBundle

LibFonts

LibFormat

LibFormula

LibLoader

LibRepository

LibSerializer

LibXml

Report Engine Core

Report Engine Extensions

Summary

2. Pentaho Reporting Client and Enterprise Examples

Pentaho Reporting and example prerequisites

Setting up Pentaho Reporting

Building your first report

Report Designer introduction

Creating and configuring your first data source

Report layout

Creating the report title

Creating column headings

Populating the details band

Creating a report summary

Previewing and saving your report

Embedding your report in a Swing application

Setting up the Swing example application

Incorporating Pentaho Reporting into the application

Embedding your report in an enterprise web application

Setting up the example Tomcat application

Incorporating Pentaho Reporting into the web application

Adding additional output formats

Summary

3. Pentaho Reporting Examples in the Real World

Setting up the example data source

ElectroBarn inventory report

Configuring the data source

Creating a query

Creating the Report Header and Page Footer

Defining the Group Header

Defining the Details band

Defining the Group Footer and the Report Footer band

Adding a pie chart

Incorporating the inventory report into your J2EE environment

Adding re port selection as an input to the servlet

Compiling and deploying the report servlet

End of the day cashier balances

Configuring an input parameter

Configuring the data source query

Creating the Report Header and Page Footer

Defining the Details band

Defining the Group bands

Defining the main Group Header

Incorporating the End of Day report into your J2EE environment

ElectroBarn invoice example

Configuring the data source query

Defining the Group Header

Defining the sub-report

Defining the Details band

Defining the Group Footer and Page Footer

Incorporating the invoice report into your J2EE environment

Summary

4. Design and Layout in Pentaho's Report Designer

Report Designer user interface components

Menu and toolbar

Report element palette

Report canvas tab panel

Report Explorer

Element Properties

Messages

Report bands

Common properties

Size and position properties

Padding and border properties

Page behavior properties

Foreground and background color properties

Excel properties

Attribute properties

Style inheritance

Page Header and Page Footer

Report Header and Report Footer

Group Header and Group Footer

Details Body

Watermark

Report elements

Common properties

Common text properties

Font style properties

Text style properties

Text spacing properties

Link properties

Excel properties

label

text-field

message

number-field

date-field

resource-label

resource-message

resource-field

chart

content (static image)

content-field (dynamic image)

rectangle

ellipse

horizontal-line and vertical-line

band

sub-report

survey-scale

line-sparkline

bar-sparkline

pie-sparkline

simple-barcodes

Visual layout in Report Designer

The Grid

Guide lines

Additional visual indicators

Moving and aligning single elements

Ali gning groups of elements

Miscellaneous layout capabilities

Pentaho Report Designer shortcut keys

Working with fonts

Considerations for different output formats

Cell output

Paging

Limits to rich graphics and charts

Summary

5. Working with Data Sources

Pentaho Reporting Engine Data API

The DataFactory interface

The ContextAwareDataFactory interface

The TableModel interface

DataFactory serialization

Additional data source metadata

Existing DataFactory implementations

TableDataFactory

NamedStaticDataFactory

Query syntax

NamedStaticDataFactory example

SQLReportDataFactory

StaticConnectionProvider

DriverConnectionProvider

JndiConnectionProvider

SQLReportDataFactory example

XPathDataFactory

XPathDataFactory example

HQLDataFactory

StaticSessionProvider

DefaultSessionProvider

HQLDataFactory Example

PmdDataFactory

XMI file

Domain Id

IPmdConnectionProvider

Registering MQL Queries

PmdDataFactory example

KettleDataFactory

KettleDataFactory example

BandedMDXDataFactory

BandedMDXDataFactory example

DenormalizedMDXDataFactory

CompoundDataFactory

Experimental data factories

Accessing data throughout a report

Summary

6. Including Charts and Graphics in Reports

Supported charts

Common chart rendering properties

Common category series rendering properties

Common XY series rendering properties

Common dataset properties

Common category series dataset properties

Common XY series dataset properties

Area chart

Area chart example

Bar chart

Bar chart example

Line chart

Line chart example

Pie chart

Pie chart example

Ring chart

Ring chart example

Multi pie chart

Multi pie chart example

Waterfall chart

Waterfall chart example

Bar line chart

Bar line chart example

Bubble chart

Bubble chart example

Scatter chart

Scatter chart example

XY Area, XY Bar and XY Line charts

XY charts example

Extended XY Line chart

Extended XY Line chart example

Radar chart

Radar chart example

Including static images in your report

Including dynamic images in your report

Summary

7. Parameterization, Functions, Formulas, and Internationalization in Reports

Report parameterization

Providing report parameters

Available report parameter types

Working with functions and expressions

Common functions

Report functions

Summary functions

Running functions

Advanced functions

Image functions

Script functions

Working with formulas

Formula syntax

Formula data types

Formula operators

Formula functions

Date time functions

Logical functions

Mathematical functions

Text functions

Reporting Specific functions

Miscellaneous functions

Internationalization and localization of reports

Localizing fields

Localization example

Summary

8. Adding Sub-Reports and Cross Tabs to Reports

Adding sub-reports

Multi-page sub-report example

Chart sub-report example

Side-by-side sub-report example

Adding cross tabs

Cross tab MDX example

Cross tab SQL example

Multiple row and column cross tab example

Summary

9. Building Interactive Reports

Interactive reports in Swing

Registering event callbacks

ReportHyperlinkListener

ReportActionListener

ReportMouseListener

Interactive Swing example

Interactive reports in HTML

Interactive HTML report properties

Manipulating the reporting HTML DOM

Including an external CSS or JavaScript resource

Interactive HTML example

Adding interactive elements to the dashboard

Summary

10. API-based Report Generation

Understanding the serialized report format

settings.xml

datadefinition.xml and the datasources folder

Parameters

Data source reference

Functions and expressions

Data sources folder

layout.xml

Group and detail band hierarchy

Report elements

Example layout.xml file

styles.xml

Example styles.xml file

Additional required files

Building and running a .prpt bundle example file

Building a report using Pentaho Reporting's Java API

Adding a data source

Defining parameters

Including functions and expressions

Defining the report's layout

Common report bands

Group band hierarchy

Adding elements to the report

Java API example

Wizard Java API

Summary

11. Extending Pentaho Reporting

Implementing report functions and expressions

Implementing expressions

Defining an expression class

Defining expression metadata

An example expression

Implementing functions

Implementing a formula function

Regex formula function example

Implementing BeanShell expressions

Example BSHExpression

Implementing a report element

Defining an ElementType class

Defining element metadata

Defining read and write handlers

An example report element

Summary

12. Additional Pentaho Reporting Topics

Using Pentaho Reporting with Pentaho's Business Intelligence Server

Downloading and Installing the BI Server

Publishing a report to the BI Server

Scheduling reports

Configuring permissions

Report emailing and bursting

Managing database connections and users

Creating ad hoc reports

Mobile reporting

Mobile report server

Mobile report design

Example: Pentaho's iPhone BI extension

Data source metadata in Pentaho Reporting

MetaTableModel API

Mapping external metadata

Using metadata attributes in a report

Current MetaTableModel implementations

Metadata example: DefaultMetaTableModel

Working with Pentaho Reporting's output layer

The OutputProcessorMetaData interface

The OutputProcessor interface

RenderNode Document Object Model

Updating Report Designer

Example: PojoObject output

The Pentaho community—getting help and contributing

Asking questions, helping others

Online documentation

Submitting bugs and viewing backlogs

Contributing code

Enterprise support

Summary