SUN Report Builder/Example

From Apache OpenOffice Wiki
Jump to: navigation, search

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.

Sum exmp qry.gif


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.


Group Report Totals.gif

Final report output


Sum exmp rpt.gif
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools