PacktLib: Pentaho 5.0 Reporting by Example: Beginner’s Guide

Pentaho 5.0 Reporting by Example

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Preface

What is Pentaho Report Designer?

Types of reports

Main features of Pentaho Report Designer

Examples of typical reports

Summary

Installation and Configuration

Configuring the environment

Time for action – installing JDK and configuring the environment variables

Time for action – downloading, installing, and configuring PRD

Learning the Sakila database

Time for action – downloading and installing Sakila DB

Summary

Start PRD and the User Interface (UI) Layout

Starting PRD

Time for action – starting PRD and creating a new report

PRD layout

Summary

Instant Gratification – Creating Your First Report with PRD

Creating your first report with PRD

Time for action – creating a new report and creating a table based on data sets

Time for action – configuring the Report Header and Details Header sections

Time for action – configuring details

The second half of the report

Time for action – adding functions

Time for action – configuring the Details Footer section

Time for action – adding more details

Output types

Time for action – exporting in different formats

Summary

Adding a Relational Data Source

Learning about JDBC driver

Time for action – configuring drivers

Creating a new data set

Time for action – creating a new data set

Time for action – modifying the header and detail

Time for action – modifying the report's footer

Aggregation functions

Time for action – using functions to configure styles

Encoding charset

Summary

Adding Groups

Starting practice

Time for action – modifying the SQL query

Time for action – configuring the layout

Configuring the Group section

Time for action – adding groups

Modifying functions

Time for action – modifying functions and page breaks

Summary

Adding Parameters

Starting practice

Time for action – creating a new report

Parameters

Time for action – adding parameters

Time for action – creating nested parameters

Summary

Using Formulas in Our Reports

Starting practice

Time for action – making a copy of the previous report

Formulas

Time for action – creating a new formula

Time for action – styles with formulas

Summary

Adding Charts

Starting practice

Time for action – creating a new report

Charts

Restarting practice

Time for action – creating a pie chart

Time for action – creating a bar chart

Summary

Adding Subreports

Starting practice

Time for action – creating a new report

Subreports

Creating and configuring Subreports

Restarting practice

Time for action – creating our first Subreport

Time for action – configuring our first Subreport

Time for action – creating and configuring the second Subreport

Summary

Publishing and Running Reports in Pentaho BA Server

Learning Pentaho

Principal characteristics of Pentaho

Time for action – installing and running Pentaho BA Server

General layout of Pentaho User Console

Creating a new solutions folder

Time for action – publishing reports in Pentaho BA Server

Summary

Making a Difference – Reports with Hyperlinks and Sparklines

Starting practice

Time for action – configuring the layout

Learning about hyperlinks

Time for action – creating our first hyperlink

Time for action – hyperlinks in charts

Learning about sparklines

Time for action – creating our first sparkline

Summary

Environment Variables, Stylesheets, and Crosstabs

Learning about environment variables

Starting practice

Time for action – configuring the layout

Time for action – creating and applying our stylesheet

Trying out stylesheets

Crosstabs editor

Time for action – configuring the layout

Summary

PRD Reports Embedded in Web Applications

Tools and technologies we will be using

Time for action – installing and starting Apache Tomcat

Time for action – installing and initiating Eclipse WTP

Time for action – creating a new Dynamic Web project

Time for action – creating a Tomcat instance

Time for action – setting a JNDI/JDBC connection pool

Time for action – configuration of libraries and the PRD report

Time for action – creating a context Listener

Time for action – creating a web client

Time for action – creating a standalone application

Summary

Sakila DB Data Dictionary

Sakila DB Data Dictionary

Sakila DB Data Dictionary

Sakila DB Data Dictionary

Pop Quiz Answers

Pop Quiz Answers

Pop Quiz Answers

Pop Quiz Answers

Pop Quiz Answers

Pop Quiz Answers

Pop Quiz Answers

Pop Quiz Answers

Pop Quiz Answers

Pop Quiz Answers

Pop Quiz Answers

Pop Quiz Answers

Pop Quiz Answers

Pop Quiz Answers

Index