Search icon
Close icon
Search icon
CANCEL
Subscription
0
Cart icon
Cart
Close icon
You have no products in your basket yet
Save more on your purchases!
Buy 2 products and save 10%
Buy 3 products and save 15%
Buy 5 products and save 20%
Savings automatically calculated. No voucher code required
Profile icon
Account
Close icon
Sign in
New User?
Create Account
Your Subscription
Your Owned Titles
Your Account
Your Orders
Change country
Modal Close icon
Country selected
Country selected
United States
Country selected
United Kingdom
Country selected
India
Country selected
Germany
Country selected
France
Country selected
Canada
Country selected
Russia
Country selected
Spain
Country selected
Brazil
Country selected
Australia
Country selected
Argentina
Country selected
Austria
Country selected
Belgium
Country selected
Bulgaria
Country selected
Chile
Country selected
Colombia
Country selected
Cyprus
Country selected
Czechia
Country selected
Denmark
Country selected
Ecuador
Country selected
Egypt
Country selected
Estonia
Country selected
Finland
Country selected
Greece
Country selected
Hungary
Country selected
Indonesia
Country selected
Ireland
Country selected
Italy
Country selected
Japan
Country selected
Latvia
Country selected
Lithuania
Country selected
Luxembourg
Country selected
Malaysia
Country selected
Malta
Country selected
Mexico
Country selected
Netherlands
Country selected
New Zealand
Country selected
Norway
Country selected
Philippines
Country selected
Poland
Country selected
Portugal
Country selected
Romania
Country selected
Singapore
Country selected
Slovakia
Country selected
Slovenia
Country selected
South Africa
Country selected
South Korea
Country selected
Sweden
Country selected
Switzerland
Country selected
Taiwan
Country selected
Thailand
Country selected
Turkey
Country selected
Ukraine
Country selected
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Arrow up icon
GO TO
TOP
You're reading from
Pentaho 5.0 Reporting by Example: Beginner's Guide
Product type
Book
Published in
Aug 2013
Publisher
Packt
ISBN-13
9781782162247
Pages
342 pages
Edition
1st Edition
Languages
Concepts
Data Processing
Author (1):
Mariano, GARCIA MATTIO
Profile icon
Mariano, GARCIA MATTIO
LinkedIn
Read more
Toc
Table of Contents
(23) Chapters
close
Pentaho 5.0 Reporting by Example
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
1. What is Pentaho Report Designer?
Types of reports
Main features of Pentaho Report Designer
Examples of typical reports
Summary
2. 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
3. Start PRD and the User Interface (UI) Layout
Starting PRD
Time for action – starting PRD and creating a new report
PRD layout
Summary
4. 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
5. 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
6. 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
7. Adding Parameters
Starting practice
Time for action – creating a new report
Parameters
Time for action – adding parameters
Time for action – creating nested parameters
Summary
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
The customer table
Inventory
Business
Pop Quiz Answers
Chapter 2, Installation and Configuration
Chapter 3, Start PRD and the User Interface (UI) Layout
Chapter 4, Instant Gratification – creating your first report with PRD
Chapter 5, Adding a Relational Data Source
Chapter 6, Adding Groups
Chapter 7, Adding Parameters
Chapter 8, Using Formulas in Our Reports
Chapter 9, Adding Charts
Chapter 10, Adding Subreports
Chapter 11, Publish and Run Reports in Pentaho BA Server
Chapter 12, Making a Difference – Reports with Hyperlinks and Sparklines
Chapter 13, Environment, Stylesheets, and Crosstabs
Chapter 14, PRD Reports Embedded in Web Applications
Index
Chapter 8, Using Formulas in Our Reports
Pop quiz – formulas
Q1
1. True
2. False
3. True
4. True
5. False
6. False
The rest of the chapter is locked
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
Start free trial
Previous Section
Section 8 of 14
Next Section
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.
Sign up now
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
Start free trial
Renews at
£13.99/month
. Cancel anytime}
Authors (1)
Left arrow icon
Profile icon
Mariano, GARCIA MATTIO
LinkedIn
Read more
See other products by Mariano, GARCIA MATTIO
Right arrow icon
Personalised recommendations for you
Based on your interests and search pattern
Left arrow icon
Et al.
Read more
Ever wonder why speech recognition systems don't understand the Scottish accent, or what would happen if an astronaut only ate mac 'n' cheese, or other spurious reflections you'd have at a bar? We did, then collated those deliberations into absurd research articles with fake figures and methodologies inspired by even more fictionally absurd studies.
Read more
Aug 2023
7 hours 40 minutes
Generative AI with LangChain
Read more
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Read more
Dec 2023
12 hours 0 minutes
Generative AI with LangChain
Read more
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Read more
Dec 2023
12 hours 0 minutes
Generative AI with LangChain
Read more
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Read more
Dec 2023
12 hours 0 minutes
Generative AI with LangChain
Read more
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Read more
Dec 2023
12 hours 0 minutes
Mastering Tableau 2023
Read more
This book is a comprehensive resource to mastering your Tableau skills and becoming a BI expert. As you progress, you will learn how to build advanced dashboards and improve your storytelling to derive key business insight, as well as make you well-versed with advanced functionalities of Tableau in the business intelligence domain.
Read more
Aug 2023
22 hours 48 minutes
Building AI Applications with ChatGPT APIs
Read more
This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.
Read more
Sep 2023
8 hours 36 minutes
Building AI Applications with ChatGPT APIs
Read more
This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.
Read more
Sep 2023
8 hours 36 minutes
Data Engineering with AWS
Read more
Embark on a journey to master data engineering pipelines on AWS! Our book offers a hands-on experience of AWS services for ingesting, transforming, and consuming data. Whether you're an absolute beginner or someone with basic data engineering experience, this guide is an indispensable resource.
Read more
Oct 2023
21 hours 12 minutes
Modern Data Architecture on AWS
Read more
Every organization wants an agile, performant, and cost-effective data platform that meets all their current and future business needs. Purpose-built AWS analytics services and their features play a big part in building such a modern data platform. This book brings to you all the design and architectural patterns that’ll help you achieve this goal.
Read more
Aug 2023
14 hours 0 minutes
Practical Guide to Applied Conformal Prediction in Python
Read more
Discover the power of Conformal Prediction with the "Practical Guide to Applied Conformal Prediction in Python." Master the latest techniques to quantify uncertainty in machine learning and computer vision models, and seamlessly apply them to your industry applications.
Read more
Dec 2023
8 hours 0 minutes
TinyML Cookbook
Read more
With over 70 project-based recipes, the TinyML Cookbook is a practical guide that will help you to get the most out of your microcontrollers. It provides a comprehensive understanding of the theoretical foundations while giving you hands-on experience training ML models for deployment on Arduino Nano 33 BLE Sense, Raspberry Pi Pico, and SparkFun RedBoard Artemis Nano microcontrollers.
Read more
Nov 2023
22 hours 8 minutes
Right arrow icon