SUN Report Builder/Example

Data Model

The example will use a very simple, and common, data model. Two tables, one a list of products and the other a list of the cost for multiple purchases of each product. Referred to as One to Many ( 1..n) relation.

Products Table ( Table2 )

ProductID	ProductName
0	Apples
1	Oranges
2	Grapes
3	Melons

Product Cost Table ( Table1 )

ProdID	Cost
0	2
0	1
0	3
0	4
1	1
1
1	4
1	7
2	9
3
3

The report will display all cost records for each product, and group by the product name. Therefore a query is used to put the data from the two tables into one contiguous result set, for use by the report builder.

Report layout - User defined functions

The Sun Report Builder allows creation of user defined functions at two levels. The report level and the group level.

Final report output