Introduction


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/.

  1. There is a readme.txt file in each version of QCC. Follow the instructions in this file to install the sample data.
  2. Once the data is installed, it needs to be defined to DB2 Alphablox through the DB2 Alphablox Admin Pages. Instructions for defining data sources are available on-line on the Admin Pages as well as in the Administrator's Guide. The data source should be named qcc2003-rdb.

Members in the Canned Data

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