Difference between revisions of "SUN Report Builder/Example"
From Apache OpenOffice Wiki
DrewJensen (Talk | contribs) (→data) |
DrewJensen (Talk | contribs) (→query image) |
||
Line 80: | Line 80: | ||
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. | 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. | ||
+ | [[Image:Sum_exmp_qry.gif]] | ||
− | Report layout | + | 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. | The Sun Report Builder allows creation of user defined functions at two levels. The report level and the group level. | ||
Line 91: | Line 89: | ||
[[Image:Group Report Totals.gif|550px]] | [[Image:Group Report Totals.gif|550px]] | ||
+ | |||
+ | Final report output |
Revision as of 15:43, 17 October 2007
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 )
|
|
|
|
|
|
|
|
|
|
Product Cost Table ( Table1 )
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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