Pentaho Reporting 3.5 for Java Developers -- Table of Contents -- 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.