Difference between revisions of "SUN Report Builder/Documentation"
DrewJensen (Talk | contribs) m |
DrewJensen (Talk | contribs) (→Added Function Names) |
||
Line 32: | Line 32: | ||
== Supported Functions == | == Supported Functions == | ||
Generally all functions which are defined in the [http://wiki.oasis-open.org/office/About_OpenFormula OpenFormula] should be supported. But this is currently still ongoing work and may change after each release of the Sun Report Builder. | Generally all functions which are defined in the [http://wiki.oasis-open.org/office/About_OpenFormula OpenFormula] should be supported. But this is currently still ongoing work and may change after each release of the Sun Report Builder. | ||
+ | |||
+ | The Sun Report Builder Verson 1.0.x includes functions in the following categories: | ||
+ | |||
+ | '''Datetime''' functions<br> | ||
+ | Date, Datetime, Day, Hour, Month, Now, Year, Today, Weekday, Time, | ||
+ | |||
+ | '''Financial''' functions<br> | ||
+ | Financial | ||
+ | |||
+ | '''Information''' functions<br> | ||
+ | Choose, HasChanged, Information, IsBlank, IsErr, IsError, IsEven, IsLogical, IsNA, IsNonText, IsNumber, IsOdd, IsRef, IsText, Na | ||
+ | |||
+ | '''Logical''' functions<br> | ||
+ | And, False, If, Not, Or, True, Xor | ||
+ | |||
+ | '''Math''' functions<br> | ||
+ | Abs, Average, Even, Odd, Sum | ||
+ | |||
+ | '''Rounding''' functions<br> | ||
+ | Int | ||
+ | |||
+ | '''Text''' functions<br> | ||
+ | Exact, Find, Left, Len, Lower, Mid, Replace, Rept, Right, Substitute, Text, T, Trim, Upper, URL | ||
+ | |||
+ | '''Userdefined''' functions<br> | ||
+ | Mapped, Null | ||
[[Category: Database]] | [[Category: Database]] | ||
[[Category: Base Documentation]] | [[Category: Base Documentation]] |
Revision as of 08:06, 11 October 2007
Sun Report Builder
You can find the Sun Report Builder here.
Functions
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
- In the name field enter the name of the functions. E.g. PopulationCount
- Enter the function. E.g. [PopulationCount] + [Population] Where Population is a column of the table.
- Enter the inital value. E.g. [Population]
- 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
Syntax
- 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)
Supported Functions
Generally all functions which are defined in the OpenFormula should be supported. But this is currently still ongoing work and may change after each release of the Sun Report Builder.
The Sun Report Builder Verson 1.0.x includes functions in the following categories:
Datetime functions
Date, Datetime, Day, Hour, Month, Now, Year, Today, Weekday, Time,
Financial functions
Financial
Information functions
Choose, HasChanged, Information, IsBlank, IsErr, IsError, IsEven, IsLogical, IsNA, IsNonText, IsNumber, IsOdd, IsRef, IsText, Na
Logical functions
And, False, If, Not, Or, True, Xor
Math functions
Abs, Average, Even, Odd, Sum
Rounding functions
Int
Text functions
Exact, Find, Left, Len, Lower, Mid, Replace, Rept, Right, Substitute, Text, T, Trim, Upper, URL
Userdefined functions
Mapped, Null