Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Pentaho 5.0 Reporting by Example: Beginner's Guide

You're reading from   Pentaho 5.0 Reporting by Example: Beginner's Guide Learn to use the power of Pentaho for Business Intelligence reporting in a series of simple, logical stages. From installation in Windows or Linux right through to publishing your own Java web application, it's all here.

Arrow left icon
Product type Paperback
Published in Aug 2013
Publisher Packt
ISBN-13 9781782162247
Length 342 pages
Edition 1st Edition
Tools
Arrow right icon
Author (1):
Arrow left icon
Mariano, GARCIA MATTIO Mariano, GARCIA MATTIO
Author Profile Icon Mariano, GARCIA MATTIO
Mariano, GARCIA MATTIO
Arrow right icon
View More author details
Toc

Table of Contents (18) Chapters Close

Preface 1. What is Pentaho Report Designer? FREE CHAPTER 2. Installation and Configuration 3. Start PRD and the User Interface (UI) Layout 4. Instant Gratification – Creating Your First Report with PRD 5. Adding a Relational Data Source 6. Adding Groups 7. Adding Parameters 8. Using Formulas in Our Reports 9. Adding Charts 10. Adding Subreports 11. Publishing and Running Reports in Pentaho BA Server 12. Making a Difference – Reports with Hyperlinks and Sparklines 13. Environment Variables, Stylesheets, and Crosstabs 14. PRD Reports Embedded in Web Applications A. Sakila DB Data Dictionary B. Pop Quiz Answers Index

Chapter 1. What is Pentaho Report Designer?

In this chapter, we will explain what Pentaho Report Designer (PRD) is, and we will discuss its engine and its Graphical User Interface (GUI). We will also discuss the advantages that its open source license entails.

We will describe the two most common uses of PRD, which are embedding in Java projects and publishing to the Pentaho BA Server.

We will present the principal types of reports: Transactional Reporting, Tactical Reporting, Strategic Reporting, and Helper Reporting. As we will see throughout this book, PRD supports all of these types of reports.

Later, we will list the main features of PRD; this includes inserting charts (sparklines and JFreeCharts), a variety of export formats, parameterization, style expressions, crosstab reports, interactive reports, Java API, integration with the Pentaho suite, and abstraction layers.

We will make a brief review of the landmarks in the evolution of PRD and its different versions.

At the end of the chapter, we will display a series of PRD reports in order to show the scope of the potential capacities that PRD possesses.

Pentaho Reporting is a technology that allows you to design and build reports for the Pentaho BA platform and other application servers. Pentaho Report Designer (PRD) is a graphics tool that implements the report-editing function. The project from which PRD originated was originally called JFreeReport.

PRD is an open source tool licensed under the GNU Lesser General Public License (GNU LGPL). This license provides the four basic freedoms of free software and the GNU GPL. And the L (Lesser) in LGPL indicates that this software can be used as part of or in combination with proprietary software, which provides greater flexibility for different licenses and software to coexist.

Note

For more information about free software and the GNU project, visit http://www.gnu.org/.

To read more about the GNU GPL and GNU LGPL licenses, visit http://www.gnu.org/licenses/licenses.en.html.

PRD contains a Java-based report engine that provides scalability, portability, and integration. Additionally, the editor's UI is implemented with Swing widgets, which give it a friendly, multiplatform look and feel. This UI is very intuitive, and it allows you to become familiar with the tools quickly.

PRD lets you create simple reports, wizard-based reports, advanced reports, reports with charts, subreports, parameterized reports, and others. Once a report has been created, PRD lets you export it in a variety of formats, such as PDF, Excel, HTML, and CSV, or preview it using Swing.

Since the beginning, PRD has benefitted from multiple contributions from the community, and currently the community supporting this project is growing and becoming more stable and contributing regularly in the form of code, wikis, documentation, forums, bug reports, tutorials, and so on.

PRD has two typical uses as follows:

  • It can be embedded in Java projects in desktop and web applications. In this book, we will develop a good example of how to embed PRD reports in web applications.
  • It can, in a few steps, publish reports to the Pentaho BA Server to be used from there. It can, furthermore, be embedded in other application servers. These points will also be addressed in this book.
You have been reading a chapter from
Pentaho 5.0 Reporting by Example: Beginner's Guide
Published in: Aug 2013
Publisher: Packt
ISBN-13: 9781782162247
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime