O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

BIRT 2.6 Data Analysis and Reporting

Book Description

Create, Design, Format, and Deploy Reports with the world's most popular Eclipse-based Business Intelligence and Reporting Tool

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

  • Crosstab reports using the new BIRT cube designer

  • Transform raw data into visual and interactive reports

  • Includes a case study (Building Reports for Bugzilla) at the end along with a real-world example that runs throughout the book

  • In Detail

    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.

    Learn to develop reports quickly using BIRT 2.6

    Table of Contents

    1. BIRT 2.6 Data Analysis and Reporting
      1. BIRT 2.6 Data Analysis and Reporting
      2. Credits
      3. About the Author
      4. About the Reviewers
      5. Preface
        1. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
        5. Reader feedback
        6. Customer support
          1. Errata
          2. Piracy
          3. Questions
      6. 1. Getting Started
        1. Introduction to BI
        2. The current state of the BI market
        3. The need for open source reporting
        4. Why BIRT?
        5. What is BIRT?
        6. The origins of BIRT
        7. Features of BIRT
        8. Eclipse framework
        9. BIRT distributions
        10. Conventions used in this book
        11. Summary
      7. 2. Installing BIRT
        1. BIRT prerequisites
          1. Software requirements
          2. Hardware requirements
        2. Where do I get BIRT?
        3. Installing BIRT from the All-In-One package
        4. Installing BIRT All-in-One under Linux
        5. Installation of BIRT through the Eclipse Plugin update program
        6. Building BIRT from source
        7. Summary
      8. 3. The BIRT Environment and 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. Resource Explorer
          6. Property Editor
              1. Report Designer
        4. Setting up a simple project
        5. Creating a simple report
        6. The hidden views
        7. Getting access to cheat sheets and the simple listing report tutorial within Eclipse
        8. Summary
      9. 4. Visual Report Items
        1. Labels
        2. Images
        3. Text and Dynamic Text
        4. Grid
        5. Aggregation
        6. Summary
      10. 5. Working with Data
        1. BIRT data capabilities
        2. Understanding the data components of BIRT
        3. The Data Source
        4. XML Data Source
        5. Flat file data adapter
          1. The JDBC Data Source
        6. Datasets
          1. Dataset for flat files
          2. JDBC Datasets
          3. Joined Dataset
        7. Creating data using the data store
        8. Tables
          1. Creating tables using drag and drop
          2. Creating tables manually
        9. Groups
        10. Lists
        11. Aggregations
        12. Web service Data Source
        13. Adding additional data aware components to the palette
        14. Summary
      11. 6. Report Parameters
        1. Why parameterize reports?
        2. Dataset parameters and report parameters
          1. Getting input from the user
          2. Creating parameter binding the easy way
        3. Dynamic Report Parameters and Filters
        4. Cascading parameters
        5. Parameter grouping and reports with multiple parameters
        6. Setting default parameter values
        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 data source to a library
          4. Adding a visual element to a library
          5. Using components stored in a library
          6. Updating components in the library to update reports
          7. Adding existing components in reports to libraries
        6. Master Pages
        7. Summary
      13. 8. Charts, Hyperlinks, and Drilldowns
        1. Pie chart
          1. Pie chart with explosions
          2. Pie charts—working with percentages
        2. Gauge chart
        3. Bar chart
        4. Summary
      14. 9. Scripting and Event Handling
        1. Types of Scripting
          1. Expressions
          2. Event Handling
          3. Contexts
            1. Adding elements to report
            2. Removing elements from a report
            3. Adding sorting conditions
          4. Affecting behavior of report rendering based on condition through script
          5. Scripted data source
          6. Using Java objects as Event Handlers
          7. How Chart Event Handling differs from other report items
          8. Chart events and the bookmark property for interactivity
        2. Multiselecting parameters and binding them to a dataset through Property Binding
        3. Using the MultiSelect parameter in an Event Handler
        4. Using the Innovent Custom Script Libraries for query binding
          1. More scripting examples
        5. Summary
      15. 10. 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. Outputing to different formats
        5. Summary