Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Pentaho 8 Reporting for Java Developers
  • Toc
  • feedback
Pentaho 8 Reporting for Java Developers

Pentaho 8 Reporting for Java Developers

By : Jasmine Kaur, Corti
4 (2)
close
Pentaho 8 Reporting for Java Developers

Pentaho 8 Reporting for Java Developers

4 (2)
By: Jasmine Kaur, Corti

Overview of this book

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.
Table of Contents (18 chapters)
close
close
Preface
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Free Chapter
1
Introduction to Pentaho Reporting
Introduction to Pentaho Reporting
Introducing Pentaho Reporting
Typical uses of Pentaho Reporting
Pentaho Reporting history
Feature overview
Pentaho Reporting architecture
Summary
2
Getting Started with Report Designer
Getting Started with Report Designer
Prerequisites of your environment
Setting up the Pentaho Report Designer
Introduction to the user interface
Creating your first report using the wizard
Previewing the report
Saving and opening the report
Summary
3
Getting Started with Reporting SDK
Getting Started with Reporting SDK
Obtaining the Pentaho Reporting SDK
Creating a web application using Pentaho Reporting and Maven
Summary
4
Creating a Report with Report Designer
Creating a Report with Report Designer
Creating a Pentaho report
Customizing Pentaho reports
Previewing Pentaho reports in different formats
Train yourself to learn faster
Summary
5
Design and Layout in Report Designer
Design and Layout in Report Designer
Report Designer user interface components
Master report and report bands properties
Report elements
Hiding and showing bands
Visual layout in Report Designer
Pentaho Report Designer shortcut keys
Considerations for different output formats
Summary
6
Configuring JDBC and Other Data Sources
chevron up
Configuring JDBC and Other Data Sources
Introducing data sources
The JDBC data source
The metadata data source
The MongoDB data source
The Pentaho Data Integration data source
The OLAP data source
The XML data source
The table data source
The advanced data source
The Pentaho community data access data source
Summary
7
Including Graphics and Charts in Reports
Including Graphics and Charts in Reports
Including static images in reports
Including dynamic images in reports
Including charts in reports
Including sparkline charts in reports
Summary
8
Parameterization, Functions, Variables, and Formulas
Parameterization, Functions, Variables, and Formulas
Report parameterization
Functions and expressions
Environment variables
Working with formulas
Summary
9
Internationalization and Localization
Internationalization and Localization
Internationalization and localization
Using resources to localize elements
Resources for localization
Testing the localization
An example of report localization
Summary
10
Subreports and Cross Tabs
Subreports and Cross Tabs
Subreports in Pentaho Report Designer
Table of contents and index elements
Cross tabs in Pentaho Report Designer
Summary
11
The PRPT Format and the Java API to Build It
The PRPT Format and the Java API to Build It
Understanding the serialized report format
Building a report using Pentaho Reporting Java API
Summary
12
Developing Using Data Sources
Developing Using Data Sources
Pentaho Reporting Engine Data API
Existing DataFactory implementations
Summary
13
Internationalization, Subreports, and Cross Tabs Using Java
Internationalization, Subreports, and Cross Tabs Using Java
Internationalization and localization using Java
Subreports using Java
Cross tab using Java
Summary
14
Building Interactive Reports
Building Interactive Reports
Interactive reports in HTML
Example of interactive reports using Java
Summary
15
Using Reports in Pentaho Business Analytics Platform
Using Reports in Pentaho Business Analytics Platform
Introducing Pentaho Business Analytics Platform
Publishing a report in the Business Analytics Platform
Previewing a report
Managing permits and schedule
Creating a dashboard with Pentaho reports
Summary
16
Using Reports in Pentaho Data Integration
Using Reports in Pentaho Data Integration
Introducing Pentaho Data Integration
Introduction of Spoon client
The Pentaho Reporting output step
Introducing Pan and Kitchen
Creating a transformation with Pentaho reports
Summary
17
Pentaho Reporting Nightly Build and Support
Pentaho Reporting Nightly Build and Support
Pentaho Report Designer nightly build
Pentaho Reporting SDK nightly build
Getting help from the community
What to do once you become an expert
Summary

The JDBC data source

The first type of data source in the list, and the most used one, is the JDBC data source. JDBC is an API for the Java language, which defines how a client may access a database. It provides methods to query (and update) data in a database and is oriented towards relational databases. See https://en.wikipedia.org/wiki/Java_Database_Connectivity for further details.

Once selected, a modal window, similar to the following one, appears:

The window contains two main sections: the connections (on the left) and the queries (on the right). The next two sections will introduce all the features for both the panels.

Adding or editing a JDBC connection

Even if the connection panel contains some SampleData connections, you can see here how to add a new one or how to edit an existing one. In the connection panel of the window, you can see:

  • A pencil icon (
    ) used to edit an existing connection
  • A green plus icon (
    ) used to add a new connection to the list of the available ones
  • A red icon ...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
End of Section 4
Next Section
bookmark search playlist download
font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete