Book Image

BIRT 2.6 Data Analysis and Reporting

By : John Ward
Book Image

BIRT 2.6 Data Analysis and Reporting

By: John Ward

Overview of this book

BIRT is an Eclipse-based open source reporting system for web applications based on Java and Java EE. To address a wide range of reporting needs within a typical application, ranging from operational or enterprise reporting to multi-dimensional online analytical processing (OLAP), you need to know BIRT from head to toe. If you wish to start making reports easily and quickly, and also want to be up-to-date with the latest developments in BIRT, then this book is for you. It will guide you from scratch to develop reports using the Eclipse BIRT project. You will learn how to connect to data, use report items to display and format data, and use scripting to build advanced reports and charts.The book steers you through each step of report setup, to creating, designing, formatting, and deploying reports with data from a wide range of data sources. Its focus is on familiarizing you with the most visible and familiar product built with the BIRT framework – the BIRT Report Designer. It starts by introducing the concepts of business intelligence and open source software, and different installation methods. It will introduce you to the various visual report elements that can be used to design BIRT reports, such as the Palette and Grid components. You will learn the details of the data components of BIRT (the Data Source and the Data Set), different types of source data that BIRT supports such as XML files, flat text files, and databases, and the creation of all of the elements while connecting to Data Sources in reports and Report Projects. By the end of the book, you will be able to enhance the presentation of your report using Charts, Hyperlinks, and Drill Through. You will also be able to take advantage of the scripting capabilities that BIRT has to offer with Expressions and Event Handlers and successfully deploy BIRT reports.The book includes a case study at the end along with a real-world example that runs throughout the book.
Table of Contents (15 chapters)
BIRT 2.6 Data Analysis and Reporting
Credits
About the Author
About the Reviewers
Preface

Conventions used in this book


The purpose of this book is to familiarize users with the BIRT Report Designer. In order to do so, I have decided to alternate between two different scenarios in order to demonstrate the capabilities of BIRT to familiarize you, the reader, with BIRT features, and to allow you an opportunity to follow along.

One set of reports will be built using the Classic Cars example database that comes with every BIRT distribution. This gives us an opportunity to allow you to follow along with examples and try them out on your own. The data schema used in Classic Cars is a simple schema, but it will require at least a basic understanding of SQL to follow along. This will allow me to give you some basic reporting examples such as listing reports, drill down reports, some basic charts, and some of the other BIRT features such as parameters, scripting, and the BIRT report emitters.

However, unlike most other books, I am also providing you an opportunity to follow along with a real life reporting scenario as well. With cooperation from the Eclipse BIRT Project Management Committee, I am also including examples of reports for the BIRT Bugzilla database. I feel these are beneficial to readers not only as a source of learning, but as an example of how the BIRT platform can be used in a real world scenario. This lets the user know that a whole lot of theory and sales pitches aren't the only thing BIRT is good for, but also demonstrates some real world usage of BIRT. This also gives us a chance to demonstrate some of the more advanced capabilities of BIRT itself.