This set of examples demonstrates how to create relational reports from relational
data sources using the Reporting Blox Tag Libary. All the examples JSP files
are located under <db2alphablox>/system/ApplicationStudio/Examples/AlphabloxReporting/html/examples,
where <db2alphablox>
is the DB2 Alphablox installation
directory. You can open these JSP files and examine the code and detailed comments
provided to learn how things are done.
Most of the examples use a relational canned data written in Java. You can run the examples right out of the box without having to define a data source. However, when you build your own relational reports, remember to define your relational data sources to DB2 Alphablox via the DB2 Alphablox home page.
The last example does require installation of a relational QCC (2003) data source. The relational sample data can be found on the installation CD with four versions: IBM DB2 UDB, MSSQL, Oracle, and Sybase. These are on the CD under sampledata/qcc/acs/.
Here are the members in this canned data:
Member | Data Type | Description |
---|---|---|
Week_Ending | timestamp | The week the data is for |
Area | string | Areas include N. Cal and S. Cal. |
Location | string | Each area includes several locations |
Product | string | Product name |
Code | integer | Product code; reflects the product family and chocolate type. All types of Chocolate Blocks-- QCC's' signature product--have a product code of 200s. |
Type | string | Milk, Dark, or White |
Cost | double | Total cost for units sold |
Units | double | Units sold |
Sales | double | Total sales |