Please see the following message for details: To copy and paste, use the following: Here is the resulting view in the Data Explorer resource view. Breadcrumbs Home Projects Forums. Report Design Here’s a rough design for our report with the groupings on Product and Component described earlier. Report message to a moderator. The table will now “break” on each new product, display a header for it and then list all the associated rows.

Uploader: Mezizuru
Date Added: 26 October 2005
File Size: 41.34 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 63253
Price: Free* [*Free Regsitration Required]

After entering the SQL, make sure it is performing the query we want by clicking in the Preview Results item in the list to the far left. Sample Database Section Contents. Line items within an order. The sample database is available in two forms: Grids, by contrast, are only used eclipsse provide structure and are not associated with a data set.

Let’s do another quick preview.

The list of scale model cars Product Lines: Now we’re ready to design the report layout. Page generated in 0. Developer Zone Downloads Documentation.

The database consists of eight tables: Report Design We will start by bringing the Palette to the foreground by clicking it’s tab as show below. Report Exception when run on server, but no problem running locally. It was designed to illustrate many of the features of the BIRT report designer. This will be a simple yet powerful report, showing groupings on Bugzilla Products and Components with totals, that should only take about 15 minutes to develop once you gain a modicum of familairty with BIRT.


The key information you need to get started is how to create a data source for the database.

Creating a new MySQL data set using BIRT

The sample database is open source; you are free to use it for your own use to experiment with other tools; to create samples for other tools, etc. We will eclipes a bugzilla database installed on MySQL as our data source.

To access it, simply select the “Classic Models Inc. What we would like to show in this report is a listing of all current bugs in the system.

Eclipse Community Forums: BIRT ยป JDBC Mysql connection

The schema is for Classic Models, a retailer of scale ecli;se of classic cars. As you can see a pretty nice report can be built using almost your mouse exclusively. Please see the following message for details: You will see that you are also able to build reports with this functionality just as quickly and easily using BIRT.

The list of product line classifcation. Let’s preview the results so far by clicking on the Preview tab at the bottom of the report design. This will bring up the New Data Source dialog. Next let’s count the number of bugs for each of the components and display the totals on the report.


In the Expression Builder create the desired display using the product data column and the Count aggregate function as we did earlier for our component group totals. Now we can drag our data fields to the report. When we drop the table control on the report design, a dialog will appear asking how many columns and detail rows we’d like. When you select the Insert Group menu item, a dialog will appear asking for the group definition.

At this point we have our blank report ready for us to start designing. Could someone please help? After you complete this click on the Test Connection button to see if the connection is successful.

Note that the steps in this example assume you have installed the 1. This time, instead of using the Preview tab at the bottom of the report design, we will use the BIRT viewer button in the Eclipse toolbar to see bort the report will look like when actually deployed.