SUN Report Builder/Functions
From Apache OpenOffice Wiki
The Sun Report Builder supplies the following functions:
Datetime
Function Name | Description | Example |
Date | ||
Datetime | ||
Day | ||
Hour | ||
Month | ||
Now | ||
Year | ||
Today | ||
Weekday | ||
Time |
Financial
Function Name | Description | Example |
Financial |
Information
Function Name | Description | Example |
Choose | ||
HasChanged | ||
Information | ||
IsBlank | ||
IsErr | ||
IsError | ||
IsEven | ||
IsLogical | ||
IsNA | ||
IsNonText | ||
IsNumber | ||
IsOdd | ||
IsRef | ||
IsText | ||
Na |
Logical
Function Name | Description | Example |
And | ||
False | ||
If | ||
Not | ||
Or | ||
True | ||
Xor |
Math
Function Name | Description | Example |
Abs | ||
Average | ||
Even | ||
Odd | ||
Sum |
Rounding
Function Name | Description | Example |
Int |
Text
Function Name | Description | Example |
Exact | ||
Find | ||
Left | ||
Len | ||
Lower | ||
Mid | ||
Replace | ||
Rept | ||
Right | ||
Substitute | ||
Text | ||
T | ||
Trim | ||
Upper | ||
URL |
Userdefined
Function Name | Description | Example |
Mapped | ||
Null |