• Birt Pojo Data Source Example
• Birt Pojo Data Source Generator
• Birt Report Pojo Data Source Example
• Eclipse Birt Pojo Data Source
• Birt Pojo Data Sources

JasperReports includes JDBC- wrapped data providers for Relational Databases (RDBMS), JavaBeans (EJB, Hibernate), plain old Java objects (POJO), CSV file and XML data sources. The data sources supported in Birt are: JDBC data sources, text file, POJO and XML data. There is no support for Hibernate’s HQL in BIRT. POJO data source is pretty badly documented and to reveal how to do it I needed to read some of BIRT sources. But what I discovered during this work is that the data set for the BIRT design time can be any class providing public Object next method (it goes then through PojoDataSetFromCustomClass in the BIRT engine).

Want to build compelling and meaningful data visualizations that can be integrated into rich-client or web applications? Go with BIRT. With components for both designing and deploying data visualizations, BIRT provides core features such as design layout, data access and scripting.

I have compiled this overview to provide a practical introduction to both the design and deployment aspects of BIRT. I start by describing the overall BIRT architecture and the various packages available for download from eclipse.org. Then I introduce the report designer tool, called BIRT Designer; I also describe some basic options for customizing BIRT designs, walk you through creation of a simple design and explore some scripting possibilities.

Next, I’ll explain some of the options BIRT gives you to deploy your visualizations. You can run BIRT reports directly from BIRT Designer, but if you need to reach large groups of users you’ll want to explore some of the other deployment options I describe, such as BIRT Runtime or BIRT Web Viewer. I’ll conclude the article by listing some resources you’ll need as you explore BIRT.

Report Design and Report Engine Components

Open Source BIRT has two main components: a design engine that is integrated into the report designer based on Eclipse and the report engine which you can add to your application. The BIRT Web Viewer is also available as an example web application deployment that uses the report engine to render reports. These components will be discussed in more detail throughout the article.

Where to download and which version to get?

Open source BIRT can be downloaded from http://download.eclipse.org/birt/downloads. There are several different packages containing BIRT, so you can choose one that is right for your needs.

Tour the BIRT Designer

BIRT Designer is a visual report development tool with task-specific editors, builders and wizards that enable you to create data visualizations that can be integrated into web applications. The BIRT report designer supports:

• A component-based model for reuse of designs and elements
• Ease of use features in a drag-and-drop, WYSIWYG format
• Support for a wide range of reports, layouts and formatting
• Programmatic control, so report content can be built and controlled through scripting
• Data access across multiple data sources

The BIRT Designer window. Red numbers refer to descriptions below.

BIRT Navigator (1)

This is where you start when you open BIRT for the first time. In this area, you’ll see all of the projects in your workspace. When you want to create a new Report Design Project or a new BIRT file within a project, this is the place to go. Below you’ll see a table of the different file types you can create in BIRT.

Data Explorer (2)

Once you have created your project and design file in the Navigator, go here next. This is where you create and view all of the Data Sources, Data Sets, Data Cubes and Report and Page Variables.

Data Sources

The BIRT project has been designed to natively access and support many data sources, as shown in the table below. Supported data sources can be extended using the Eclipse ODA framework to support any data to which you have access. In addition to the list below, BIRT ships with a connection to a sample database (called Classic Models). BIRT also includes a Joint Data Set which allows you to join data across data sources, no matter the type.

Resource Explorer (3)

Next to the Data Explorer, you’ll see the Resource Explorer. This is where you’ll find all of your resources that can be used in your design, such as libraries, images and js files.

Layout (4)

The main portion of the designer is the Layout view. This is where you create your WYSIWYG design. Below this window, you’ll also see tabs that will allow you to see your Master Page, the Script on a selected element, the design’s XML Source and a Preview of your design.

Palette (5)

Now that you’ve created your project and your design and connected to your data, you’re ready to start building the design layout. To insert an element into your layout from the Palette, simply drag and drop it. The table below lists available items, including a breakdown of the available chart types.

Chart Types

The chart types you’ll find out-of-the-box with BIRT are shown below. Several of the charts are offered in 2D, 2D with depth and 3D formats. Most charts also have more than one sub-type, such as a bar chart with options of side-by-side, stacked and percent stacked, or a stock chart with options of candlestick and bar-stick. If you don’t find what you’re looking for, you can create a custom chart plug-in.

Property Editor (7)

Just below the layout window, you’ll find the property editor. This area allows you to customize your design or individual elements with just a few clicks. Options include filtering, grouping, sorting, mapping and highlighting.

Outline (8)

The outline shows your design in a tree structure. You also use the outline view to create and edit master pages, add styles, import CSS formatting, embed images and locate scripts within your design.

Tutorial: Creating a Simple Listing Design

Now that you’ve taken a quick tour of BIRT Designer, let’s build a very simple design. This tutorial assumes you’ve already installed BIRT and are in the Report Design perspective.

1. Right click in the Navigator and create a new Project by selecting Report Project under Business Intelligence and Reporting Tools. Enter a name for your project and hit Finish.
2. Right click on your new project in the Navigator and create a new report. Be sure your project is selected, give the design a name and hit Next. Here you’ll have several template options for getting started. As stated above in the BIRT Files list, you can create your own templates to add to this list. Choose the blank template and hit Finish.
3. Go to the Data Explorer, right-click on Data Sources and create a new data source. Choose the Classic Models database, give your Data Source a name and hit Finish. Next, right-click on Data Sets and create a new data set. Make sure your data source is selected, give your data set a name and hit Next. Enter the following query, then hit Finish:
   select * from payments
   Click Preview Results, then click OK.
   
4. Drag a Label from the Palette into the layout window and enter My First Report. Drag your data set from the Data Explorer into your layout, below the label. Select all of the columns in the pop-up and click OK.
5. Select the table in the layout by hovering over the lower-left corner of the table and selecting the “Table” tab. You’ll notice the Property Editor changes to reflect the fact that you’re working on a table. Go to the Groups tab in the property editor and select Add. Name your group, then select CUSTOMERNUMBER from the Group On drop-down menu. Hit OK and delete the CUSTOMERNUMBER data element from the detail row (not the group header). Go to Run -> View Report -> In Web Viewer.

In five short steps, you’ve created a very simple report with a table listing your data. Take some time to explore other options in the property editor, e.g., add a chart, or add a CSS style. You’ll see how quickly you can take this simple design to the next level.

Advanced Design Customization

Now that we’ve gone through the basics and you’ve created your first design, it’s time to learn how to customize and personalize your design to fit the needs of your application. Customization, in this case, refers to things like localization, internationalization, styles and scripting.

Localization

BIRT supports internationalization of report data, including support for bidirectional text. BIRT also supports the localization of static report elements within a report, allowing you to replace report labels, table headers and chart titles with localized text. BIRT allows the use of multiple resource files with name/value pairs and a *.properties file extension. For example, a file called MyLocalizedText_de.properties can include a line that says “welcomeMessage=Willkommen”.

To use the properties files within a BIRT report:

Styles

Reports created with BIRT Designer can be richly formatted to adapt the look and feel of your existing web application or company color scheme.

I have collected some examples of CSS styles here.

Customization with Expressions, Scripting and Events

You can modify many aspects of reports in BIRT Designer using drag-and-drop capabilities and by setting properties, but the designer also supports more advanced customizations through expressions, scripting and events.

The expression builder in BIRT allows you to do conditional report processing instead of hard coding values. For example, the expression below will include the ADDRESSLINE2 field in an address if it’s not null.

Scripting of BIRT content can be done in either JavaScript or Java. You can add scripting to report object, data source and data element event types. Each of these event types has several events that you can overwrite. I have collected a variety of sample scripts here.

You can also use head.js() in the report’s clientScripts method to load external JavaScript libraries for use on the client side. For an example on this, see this blog post.

BIRT Deployment Options

Now that you’ve created your designs, you’re ready to deploy them. There are several different ways to generate the output. You can run these designs directly from the BIRT Designer, or generate them from your Java application using the BIRT APIs.

BIRT Runtime Engine

BIRT supplies several APIs and an example Java EE application for generating and viewing reports. The major APIs are the Design Engine API (DEAPI), Report Engine API (REAPI) and the Chart Engine API (CEAPI). In addition to the APIs, BIRT supports scripting using either Java or JavaScript within report designs.

To see API examples, visit http://developer.actuate.com/community/devshare and perform a search for “API.”

BIRT Report Engine Tasks

There are several tasks supplied by the REAPI that can be used to generate report output. A few key tasks are listed below.

Example of BIRT Runtime Engine

With some simple code you can start up the BIRT Runtime Engine and Platform, create a task to accept the parameter value, generate and render the design to PDF, then destroy the engine and shut down the platform when finished. I have collected sample code to do that here. In an actual application, you’d want to separate the BIRT Runtime Engine and Platform code and only shut them down when you terminate your application.

Web Viewer

The BIRT Web Viewer is an example application that illustrates generating and rendering BIRT design outputs in a web application. This viewer demonstrates report pagination, an integrated table of contents, report export to several formats and printing to local and server side printers.

BIRT Web Viewer

The BIRT Web Viewer can be used in a variety of ways:

The BIRT Web Viewer consists of two main Servlets: the ViewerServlet and the BirtEngineServlet. These Servlets handle three mappings: (/frameset, /run and /preview).

Other BIRT Web Viewer Settings

Many URL parameters can be used with the Servlet mappings. The BIRT Web Viewer itself has several key settings that can be configured by modifying the web.xml file located in the WebViewerExample/WEB-INF folder. The BIRT Web Viewer also includes a set of JSP tags, available from the BIRT Web Tools Integration download, that make it easy to integrate BIRT reports into browser pages. All of these options are described in the BIRT Web Viewer documentation here: https://eclipse.org/birt/documentation/integrating/viewer-usage.php.

BIRT Output Formats

In addition to delivering paginated report content to a web browser, BIRT also supports several other output formats. These formats listed below are supported by both the Report Engine API as well as the BIRT Web Viewer.

BIRT Extension Points

The APIs in BIRT define extension points that let the developer add custom functionality to the BIRT framework. These extensions can be in the form of custom data sources, report items, chart types, output formats and functions. Once implemented, these custom extensions will show along with the built-in types. For example, you can create a custom report item, like a rotated text label, that will show up in the BIRT Palette along with the existing items. Below are some of the most used extension points.

BIRT Resources

Birt Pojo Data Source Example

1. Just plain SQL on Hibernate database.
2. Scripting data source.
3. Hibernate ODA data source.

Model + Data Set

Report design

Birt Pojo Data Source Generator

The runtime

1. Any object providing public Object next() method, using PojoDataSetFromCustomClass.
2. Collection, using PojoDataSetFromCollection.
3. Array of objects, using PojoDataSetFromArray.
4. Iterator, using PojoDataSetFromIterator.

Birt Report Pojo Data Source Example

Eclipse Birt Pojo Data Source

Birt Pojo Data Sources