Hi Mechtilde, Ocke
Here is a list of functions that appear to be working in SRB -most
likely not exhaustive.
Date/Time functions
Date
DateDif
Time
DateValue
Now
Today
Day
Month
Year
WeekDay.
Hour
Logical functions
And
False
If
Not
Or
True
Xor
Mathematical functions
Sum
Abs
Average
Odd
Even
Text functions
Len
Lower
Upper
Trim
Text
T
Find
Exact
Rept
Mid
Left
Right
UrlEncode
Replace
Substitute
Rounding functions
Int - note this seems to truncate not round, which is actually what I
expected...but the OASIS doc says it should round?
Information functions
HasChanged
IsBlank
Na
IsNa
IsLogical
IsText
IsErr
IsError
Choose
IsRef
IsNumber
IsOdd
IsEven
IsNonText
Null
Operators (inFix)
+ Add.
- Subtract
* Multiply
/ Divide
= Equal
<> NotEqual
< Lesser
Greater
<= LesserEqual
= GreaterEqual
& Concat
^ Power
( postFix )
% Percentage
+ Plus
- Minus
.
Ocke Janssen wrote:
Hello Mechtilde,
I created a wiki page for the Sun Report Builder.
http://wiki.services.openoffice.org/wiki/SUN_Report_Builder
It's still the begining of that page ;-)
Best regards,
Ocke
Mechtilde schrieb:
Hello,
Is there a reference which funktions I can use in the new report
builder?
I also look for the exact syntax I have to use.
For example: I have report containing two columns with currency values
which I want to sum. Also I want to sum these two sum.
where can I look for it?
Regards
Mechtilde
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
