Welcome!

Jason Weathersby

Subscribe to Jason Weathersby: eMailAlertsEmail Alerts
Get Jason Weathersby via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Related Topics: Java Developer Magazine, MySQL Journal

Blog Feed Post

BIRT 2.5.2 Enhancements

The SQL Query Builder is now directly available without creating a connection profile

As BIRT 2.5.2 was released recently, I wanted to post on some of the new features available in the release. BIRT 2.5.2 represents a maintenance release, which is generally dominated with bug fixes and not new enhancements, but this release does have a few that are worth noting.

SQL Query Builder

The SQL Query Builder is now directly available without creating a connection profile. When adding a new data source, the query builder is listed as one of the data sources available.



After selecting the Query Builder data source you are prompted with a list of available databases. Once you select the type of database you can then specify the specific driver and connection properties that will be used.


One of the advantages to using this driver is that the jar location of the driver is a data source property and can be changed using Property Binding or an Event Handler Script.

&ltproperty name="jarList"&gtC:\birt\mysql\mysql-connector-java-5.0.4-bin.jar</property>

After the data source is created, you create a dataset just like you would with any other BIRT data source. The editor allows graphic query creation as shown in the following image.

Designer Classpath Configuration
In prior releases of BIRT, the classloader while in the designer would search all projects within the workspace to locate a class that was used within the design. This would happen for classes invoked used in expressions or JavaScript event handlers. Event handlers written in Java where located in this fashion as well. In BIRT 2.5.2 you can now configure the classpath for the workspace or for the individual project that BIRT will use. To set this preference select the window->preferences->Report Design->Classpath entry.



Sorting Enhancement
BIRT provides sorting on many report items, such as tables, group sections, and crosstabs. New for BIRT 2.5.2 is ability to set the collation strength and locale for the sorter.


Crosstab Cheat Sheet and Template
A new Report Template and Cheat Sheet are available for creating a cross tab style report.



Other enhancements are also in BIRT 2.5.2 and these can be viewed in bugzilla. The full list of bug fixes is also available with this query. You can download BIRT 2.5.2 here.

More Stories By Jason Weathersby

Jason Weathersby is a member of the extended BIRT development team at Actuate Corporation and has backgrounds in both computer science and technical writing. He has many years experience in technical consulting, training, writing, and publishing about reporting, business intelligence tools, and database technologies.