Packt+ | Advance your knowledge in tech

You're reading from Pentaho 8 Reporting for Java Developers

Product type Book

Published in Sep 2017

Publisher Packt

ISBN-13 9781788298995

Pages 470 pages

Edition 1st Edition

Languages

Java

Concepts

Data Processing

Authors (2):

Jasmine Kaur

Francesco Corti

View More author details

Table of Contents (25) Chapters

Title Page

Credits

About the Author

About the Reviewers

www.PacktPub.com

Customer Feedback

Dedication

Preface

1. Introduction to Pentaho Reporting

2. Getting Started with Report Designer

3. Getting Started with Reporting SDK

4. Creating a Report with Report Designer

5. Design and Layout in Report Designer

6. Configuring JDBC and Other Data Sources

7. Including Graphics and Charts in Reports

8. Parameterization, Functions, Variables, and Formulas

9. Internationalization and Localization

10. Subreports and Cross Tabs

11. The PRPT Format and the Java API to Build It

12. Developing Using Data Sources

13. Internationalization, Subreports, and Cross Tabs Using Java

14. Building Interactive Reports

15. Using Reports in Pentaho Business Analytics Platform

16. Using Reports in Pentaho Data Integration

17. Pentaho Reporting Nightly Build and Support

Cross tabs in Pentaho Report Designer

A cross tabulation (or cross tab) allows you to view dimensional data in a report. Using cross tabs, you can easily view two or more fields and how they relate based on a measure. Cross tabs summarize the information in your database and they lay out in a grid, with rows representing dimensions (for example, country, date, or salesperson), columns representing another dimensions, and the intersection containing the aggregations (usually sums). Cross tabs are similar to pivot tables in Microsoft Excel.

Pentaho Reporting offers the ability to create cross tab based reports. These are special type of reports that render differently than most standard reports. These reports also expect the data to be in a particular format. Cross tab reports can be driven by multidimensional queries (as highlighted in Chapter 6, Configuring JDBC and Other Data Sources, Pentaho Reporting offers a Mondrian and OLAP4j data source for providing multidimensional data to a report...