Feeding the report data from a database using SQL

Report data can come from a database, using SQL to extract the data. The report application can be hand-coded or generated.

For an example of feeding the report data from a database using SQL, examine OrderReportJDBCModel.java in the OrderReportJava demo application.

If you would rather generate your report application, you can use the Business Application Modeler to create an application that feeds the report data from a database using SQL. See Quick Start: Generate a Java report application.

Tip: Where possible, use a single data set, gathering multiple database tables into this data set. The database can then use a single SELECT statement, which allows for better performance than running multiple queries. However, multiple data sets are necessary in some cases; for example, you need multiple independent lists of data in your reports, or your query is too complex for the database engine.