Pentaho 8 reporting for Java developers : create pixel-perfect analytical reports using reporting tools / Francesco Corti.

Format:

Book

Author/Creator:

Corti, Francesco, author.

Language:

English

Subjects (All):

Java (Computer program language).

Business report writing--Data processing.

Business report writing.

Physical Description:

1 online resource (1 volume) : illustrations

Edition:

1st edition

Place of Publication:

Birmingham, England ; Mumbai, [India] : Packt Publishing, 2017.

System Details:

Mode of access: World Wide Web.

text file

Biography/History:

Corti Francesco: Francesco Corti is an enthusiastic consultant in software solutions and loves working in developer, sales, and customers teams. Proud of the role of a software engineer, he is often involved in pre-sales presentations, public speaking, and IT courses. Developing software, designing architectures, and defining solutions in ECM/BPM and BI are his favorite areas of interest. He has completed dozens of projects, from very small ones to more complex ones, in almost 20 years of experience. A product evangelist at Alfresco, Francesco represents the famous open source ECM in the developer community. In addition to helping developers adopt Alfresco technologies, he often helps Alfresco to improve the developer experience through talks, articles, blogging, user demonstrations, recorded demonstrations, or the creation of sample projects. He is the inventor and principal developer of Alflytics (previously named Alfresco Audit Analytics and Reporting), the main business intelligence solution over Alfresco ECM, entirely based on the Pentaho suite. He authored the Pentaho Reporting video course with more than 40 videos and courses on the Pentaho Reporting Designer and SDK. Francesco has specialty and principal experiences in enterprise content management solutions with Alfresco ECM and Hyland OnBase (he is an OnBase certified installer); business process management solutions with Activiti, JBPM, and Hyland OnBase; data capture solutions with Ephesoft, Hyland OnBase, and custom software; record management solutions with O'Neil software and custom software (using Alfresco ECM and Hyland OnBase); and portal and collaboration with Liferay and MS SharePoint.

Summary:

Create reports and solve common report problems with minimal fuss. About This Book Use this unique book to master the basics and advanced features of Pentaho 8 Reporting. A book showing developers and analysts with IT skills how to create and use the best possible reports using the Pentaho platform. Written with a very practical approach: full of tutorials and practical examples (source code included). Who This Book Is For This book is written for two types of professionals and students: Information Technologists with a basic knowledge of Databases and Java Developers with medium seniority. Developers will be interested to discover how to embed reports in a third-party Java application. What You Will Learn The basics of Pentaho Reporting (Designer and SDK) and its initial setup. Develop the most attractive reports on top of a wide range of data sources. Perform detailed customization of layout, parameterization, internationalization, behaviors, and more for your custom reports developed with Pentaho Reporting. Integrate Pentaho reports into third-party Java application with full control over interactions, layout, and behavior in general. Use Pentaho reports in the other components of the Pentaho Suite (BA Platform and PDI). In Detail 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. Style and approach A step-by-step guide covering technical topics relating to environments, best practices, and source code, to enable the reader to assemble the best reports and use them in existing Java applications.

Contents:

Cover

Title Page

Copyright

Credits

About the Author

About the Reviewers

www.PacktPub.com

Customer Feedback

Dedication

Table of Contents

Preface

Chapter 1: 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

Chapter 2: Getting Started with Report Designer

Prerequisites of your environment

Setting up the Pentaho Report Designer

The SamplaData&amp

#160

schema

Introduction to&amp

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&amp

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

Chapter 3: Getting Started with Reporting SDK

Obtaining&amp

the Pentaho Reporting SDK.

Anatomy of the Pentaho Reporting SDK

Using the included Eclipse project

Introducing the included&amp

examples

Creating a&amp

web application using Pentaho Reporting and Maven

Creating a web application in Java

Creating a Java web application using Apache Maven

Creating the&amp

first page&amp

of the&amp

Java&amp

web application

Including Pentaho Reporting Engine in a&amp

Adding the Pentaho repository

Adding the Pentaho&amp

dependencies

Showing&amp

an existing Pentaho report in a&amp

Including an existing Pentaho report

Including the SampleData schema

Updating the PentahoServlet

Previewing the Pentaho report

Chapter 4: Creating a Report with Report Designer

Creating a Pentaho report

Creating&amp

a new&amp

Pentaho report

datasource in&amp

Pentaho reports

Adding details to Pentaho reports

Previewing and saving a&amp

Customizing Pentaho reports

Customizing the font

Customizing the report header

Adding&amp

the&amp

details header and customizing the details

Customizing the page footer

Grouping the details

Adding charts

Previewing Pentaho&amp

reports in different formats

Train yourself to learn faster

Chapter 5: 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&amp

properties

Links properties

Excel properties

Page-behaviour&amp

Padding properties

Border&amp

Common properties in attributes

Query-metadata properties

Wizard properties

HTML&amp

Excel properties in attributes

HTML-events, PDF-events, and&amp

Swing-events properties

HTML-events properties

Pdf-events&amp

Master Report properties

Text properties

Page-behaviour properties

Query properties

Common properties in the attributes tab

Advanced properties

Pentaho properties

Page Header and Page Footer properties

Report Header and Report Footer properties

Group Header and Group Footer properties

Details body&amp

Watermark properties

Report elements

Text and text-spacing properties

Rotation properties

Object properties

Page-behavior properties

Padding and border properties

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&amp

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

Chapter 6: Configuring JDBC and Other Data Sources

Introducing data sources

Datasets&amp

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

Chapter 7: Including Graphics and Charts in Reports

Including static images&amp

in reports

Including dynamic&amp

images&amp

Including charts&amp

Types of&amp

datasets

Category dataset

Series&amp

Group&amp

Optional&amp

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&amp

Scripting&amp

Bar&amp

chart

Bar chart example

Line chart

Line chart example

Area chart

Area&amp

chart example

Pie chart

Pie&amp

Multipie chart

Multipie&amp

Bar line chart

Bar line&amp

#160.

chart example

Ring chart

Ring&amp

Bubble chart

Bubble&amp

Scatter plot chart

Scatter plot&amp

XY bar chart,&amp

XY line chart, and&amp

XY&amp

area chart

XY bar&amp

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&amp

XY area line chart

Thermometer chart

Thermometer&amp

Including sparkline charts in reports

Chapter 8: Parameterization, Functions, Variables, and Formulas

Report&amp

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&amp

functions

Example of function

Creating and using expressions

Example of expression

The available function&amp

types

Common functions

Report functions

Summary functions

Running functions

Advanced functions

Chart data and value data functions

Image functions

Script functions

Table of contents&amp

Environment variables

Working with formulas

formula

The&amp

formula syntax

Formula datatypes

Formula operators

The available formula&amp

categories

Date or time formulas

Database formulas

Information&amp

formulas

Logical formulas

Mathematical formulas

Rounding formulas

Text formulas

User-defined formulas

Chapter 9: Internationalization and Localization.

Internationalization and localization.

Notes:

Includes index.

Includes bibliographical references and index.

Description based on online resource; title from PDF title page (ebrary, viewed October 17, 2017).

OCLC:

1005351397