O'Reilly logo

BIRT 2.6 Data Analysis and Reporting by John Ward

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

Creating data using the data store

Introduced in BIRT 2.3 is a graphical query designer that is available every time a designer uses a data store. The idea is to provide a visual representation of tables and their relationships for report designers that may not be as fluent in SQL. This also gives developers a chance to quickly create a general SQL statement that can be refined without having to type code. In 2.5, this was expanded to be available from the JDBC Database Connection for Query Builder type of Data Source. Let's now follow these steps and create data:

  1. Create a new report titled dataStoreExample.rptDesign.
  2. Create a new Data Source.
  3. Choose the Create from a connection profile in profile store option in the New Data Source window.

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

Start Free Trial

No credit card required