SUN Report Builder/Documentation

From Apache OpenOffice Wiki
< SUN Report Builder
Revision as of 13:24, 22 August 2007 by Oj (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


A function can be created when opening the report navigator. In the context menu on the functions entry you can create one function.

This function can either be in the global context of the report itself or in any group.

For example:

- compute the sum of a field

  1. In the name field enter the name of the functions. E.g. PopulationCount
  2. Enter the function. E.g. [PopulationCount] + [Population] Where Population is a column of the table.
  3. Enter the inital value. E.g. [Population]
  4. Insert a new formatted field and select the [PopulationCount] on the data tab.

Computed fields

Computed fields can be created in that way that the formula is entered directly into the data field.

E.g. 100*[Population]/[PopulationCount] to get the percentage of the current population


  • quote for [ is \
  • \\
  • [] as reference for formula or field name
  • "" to quote strings
  • . as decimal separator
  • date as in java specific
  • parameter separator is ; (semicolon) and it is allowed to let some parameters empty inside a call like XYZ(;kk;;kkb)
Personal tools