Book Image

Pentaho 5.0 Reporting by Example: Beginner's Guide

By : Mariano, GARCIA MATTIO
Book Image

Pentaho 5.0 Reporting by Example: Beginner's Guide

By: Mariano, GARCIA MATTIO

Overview of this book

Open source reporting tools and techniques, such as PRD, have been comparable in quality to their commercial counterparts this is largely due to the market's marked tendency to choose open source solutions. PRD is a very powerful tool and in order to take full advantage of it you need to pay attention to the important details. Pentaho 5.0 Reporting by Example: Beginner's Guide clearly explains the the foundation and then puts those concepts into practice through step-by-step visual guides. Feeling confident with your newly discovered, desirable, skill you will have the power to create your very own professional reports including graphics, formulas, sub-reports and many other forms of data reporting.Pentaho 5.0 Reporting By Example: Beginner's Guide is a step-by-step guide to create high quality, professional reports. Starting with the basics we will explore each feature to ensure a thorough understanding to peel back the curtain and take full advantage of the power that Pentaho puts at our fingertips. This book gives you the necessary resources to create a great variety of reports. You will be able to make reports that contain sub-reports, include graphics, sparklines and so on. You will also be able to parameterize your reports so that the final user can decide what information to visualize. You will be able to create your own stoplight type indicators and drill down in your reports. and execute your reports from your own web application. Pentaho 5.0 Reporting By Example: Beginner's Guide lets you learn everything necessary to work seriously with one of the world's most popular open source reporting tools. This book will guide you chapter by chapter through examples, graphics, and theoretical explanations so that you feel comfortable interacting with Pentaho Report Designer and creating your own reports.
Table of Contents (23 chapters)
Pentaho 5.0 Reporting by Example
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

The customer table


The customer table contains information about all customers described as follows:

Column

Description

customer_id

A primary key used to uniquely identify each customer in the table.

store_id

A foreign key identifying the customer's "home store". Customers are not limited to renting only from this store, but this is the store they generally shop at.

first_name

The customer's first name.

last_name

The customer's last name.

email

The customer's e-mail address.

address_id

A foreign key identifying the customer's address in the address table.

active

Indicates if the customer is an active customer. Setting this to FALSE serves as a logical deletion of the customer.

create_date

The date when the customer was added to the database.

last_update

The most recent row update. It has not been used in this book.

This information of all the customers is shown in a pictorial format in the following screenshot:

The address table

The address table contains the address information of customers, staff, and stores described as follows:

Column

Description

address_id

A primary key used to uniquely identify each customer in the table.

address

A line of address information.

address2

Another line of address information that is used if the first line is not enough.

district

The region of an address; this may be a state, province, prefecture, and so on.

city_id

A foreign key identifying the city of the address in the city table.

postal_code

The postal code or zip code of the address.

phone

The phone number for the address.

last_update

The most recent row update. It has not been used in this book.

An example of the address table is shown in the following screenshot:

The city table

The city table contains a list of cities described as follows:

Column

Description

city_id

A primary key used to uniquely identify each city in the table.

city

The name of the city.

country_id

A foreign key identifying the country the city belongs to in the country table.

last_update

The most recent row update. It has not been used in this book.

An example of the city table is shown in the following screenshot:

The country table

The country table contains a list of countries described as follows:

Column

Description

country_id

A primary key used to uniquely identify each country in the table.

country

The name of the country.

last_update

The most recent row update. It has not been used in this book.

An example of the country table is shown in the following screenshot: