Accessing data using a graphical query
In addition to providing a query editor for typing the SQL statement to specify the data to retrieve, BIRT Designer provides a SQL query builder that you can use to create SQL statements graphically. The query builder provides several advantages over the query editor:
*The ability to create and edit SQL statements quickly without typing SQL code. This feature is particularly useful when creating multiple joins, using SQL functions, or writing complex expressions.
*The ability for BIRT to modify a SQL query when you sort, group, or filter data using the graphical tools. BIRT maps these user-interface actions to the equivalent SQL expressions, and because the database processes the data, the report’s performance improves.
*Join pushdown. In many cases, joins created in the query builder are processed by the database, or “pushed down.” The database can process joins far more efficiently than BIRT can.
This topic describes how to access database data using the query builder. For information about using the query editor, see Accessing data using a textual query or stored procedure.
As with other types of data sources, for a report to retrieve data from a database using the query builder, you must create the following BIRT objects:
*A data source that contains the information to connect to the database
*A data set that specifies the data to retrieve from the database