You are previewing Practical Data Analysis and Reporting with BIRT.
O'Reilly logo
Practical Data Analysis and Reporting with BIRT

Book Description

Use the open-source Eclipse-based Business Intelligence and Reporting Tools system to design and create reports quickly

  • Get started with BIRT Report Designer

  • Develop the skills to get the most from it

  • Transform raw data into visual and interactive content

  • Design, manage, format, and deploy high-quality reports

  • This book covers BIRT version 2.2

In Detail

BIRT, which stands for Business Intelligence and Reporting Tools, is actually a development framework. Including the word "Tools" in the acronym is appropriate, since BIRT is in fact a collection of development tools and technologies used for report development utilizing the BIRT framework. BIRT is essentially not a product, but a series of core technologies on top of which products and solutions are built, similar in fashion to the Eclipse framework.

The focus of this book is on the most visible and familiar product built with the BIRT framework, which is the BIRT Report Designer. The BIRT Report Designer is an Eclipse plug-in that utilizes BIRT technologies to allow users to design reports in the BIRT document format. You can integrate it with your Java/J2EE applications to produce compelling reports.

Table of Contents

  1. Practical Data Analysis and Reporting with BIRT
  2. Credits
  3. About the Author
  4. About the Reviewer
  5. Preface
    1. What This Book Covers
    2. What You Need for This Book
    3. Conventions
    4. Reader Feedback
    5. Customer Support
      1. Downloading the Example Code for the Book
      2. Errata
      3. Questions
  6. 1. Introduction
    1. Introduction to Business Intelligence
    2. The Current State of the BI Market
    3. The Need for Open-Source Reporting
    4. What is BIRT
    5. The Origins of BIRT
    6. Features of BIRT
    7. Eclipse Framework
    8. BIRT Distributions
    9. Why BIRT?
    10. Conventions Used in This Book
    11. Summary
  7. 2. Installing BIRT
    1. Requirements
    2. Where Do I Get BIRT?
    3. Installing BIRT from the All-in-One Installation
    4. Installing BIRT All-In-One under Linux
    5. Installing iText for PDF Support
    6. Installation of BIRT through the Eclipse Plug-in Update Program
    7. Summary
  8. 3. The BIRT Environment and Your First Report
    1. A Basic Scenario
    2. The BIRT Perspective
    3. The BIRT Workbench
      1. The Navigator
      2. The Outline
      3. The Palette
      4. The Data Explorer
      5. Property Editor
      6. Report Designer
    4. Setting up a Simple Project
    5. Creating a Simple Report
    6. Summary
  9. 4. Visual Report Components
    1. Adding Labels
    2. Adding Images
    3. Using Text and Dynamic Text
    4. Adding Grids
    5. Summary
  10. 5. Working with Data
    1. BIRT Data Capabilities
    2. Understanding the Data Components of BIRT
    3. The Data Source
      1. The JDBC Data Source
    4. Data Sets
      1. Data Set for Flat Files
    5. Tables
      1. Creating Tables Using Drag and Drop
      2. Creating Tables Manually
    6. Groups
    7. Lists
    8. Aggregation
    9. Table of Contents
    10. Crosstab
    11. Summary
  11. 6. Report Parameters
    1. Why Parameterize Reports?
    2. Data Set Parameters and Report Parameters
    3. Getting Input from the User
      1. Creating Parameter Binding the Easy Way
    4. Dynamic Report Parameters and Filters
    5. Cascading Parameters
    6. Parameter Grouping and Reports with Multiple Parameters
    7. Summary
  12. 7. Report Projects and Libraries
    1. Report Projects
    2. Creating New Report Projects
    3. Importing and Exporting Report Projects
    4. Other Project Options
    5. Libraries
      1. Creating a New Library
      2. Adding Components to a Library
      3. Adding a Visual Element to a Library
      4. Using Components Stored in a Library
      5. Updating Components in the Library to Update Reports
      6. Adding Existing Components in Reports to Libraries
    6. Summary
  13. 8. Styles, Themes, and Templates
    1. Style Sheets
      1. Custom Style Sheets
      2. Editing Style Sheets
      3. Alternating Row Colors Using Highlights
    2. Creating Themes
    3. Using External CSS Style Sheets
      1. Importing CSS Files
      2. Using CSS as a Resource
    4. Templates
      1. Building a Report from a Template
      2. Creating a Template
    5. Summary
  14. 9. Charts, Hyperlinks, and Drill-Downs
    1. Pie Chart
      1. Modifying Chart Properties
      2. Using Percentages
    2. Gauge Chart
    3. Bar Chart
    4. Summary
  15. 10. Scripting and Event Handling
    1. Types of Scripting
    2. Expressions
      1. Using Expressions in Data Elements
      2. Calling Java Objects in Expressions
    3. Event Handling
      1. Contexts
      2. Adding Elements to Reports
      3. Removing Elements from a Report
      4. Adding Sorting Conditions
    4. Scripted Data Source
    5. Using Java Objects as Event Handlers
    6. Summary
  16. 11. Deployment
    1. BIRT Viewer
      1. Installing Reports into the Web Viewer
      2. Accessing Reports in the Web Viewer
    2. Command-Line Tools
    3. Report Engine API
    4. Outputting to Different Formats
    5. Summary
  17. 12. Practical Example— Building Reports for Bugzilla
    1. The Environment
    2. Requirements
    3. Create the Libraries
    4. First Report—Bug Detail Report
    5. Bug Status
    6. Developer Issues Reports
    7. Summary
    8. Conclusion