SUN Report Builder/Functions

The Sun Report Builder supplies the following functions:

Rounding

Function Name	Description	Parameters	Example
INT	Returns a number down to the nearest integer

Information

Function Name	Description	Parameters	Example
CHOOSE	Uses an index to return a value from a list of values.
HASCHANGED	Checks, whether the columns specified by the given names has changed.
ISBLANK	Checks, whether the value is undefined (null).
ISERR	Tells if the parameter is of error type but returns false if the error is of type NA.
ISERROR	Tells if the parameter is of error type but returns false.
ISEVEN	Checks whatever the value is an even number.
ISLOGICAL	Checks whatever the value is of type Logical.
ISNA	Tells if the parameter is of error type NA.
ISNONTEXT	Checks whatever the value is not of type Text.
ISNUMBER	Checks whatever the value is of type Number.
ISODD	Checks whatever the value is an odd number.
ISREF	Checks whatever the value is a reference.
ISTEXT	Checks whatever the value is of type Text.
NA	Returns the constant error NA.

Date/Time

Function Name	Description	Parameters	Example
DATE	Returns the number of days since 01.01.1900 Parameter Description Month Day
DATEDIF	Returns the number of years, months, or days between two dates. Parameter Description Date2 Format
DATEVALUE	Returns date serial number from given text.
DAY	Returns the day of a date
HOUR	Returns the hour (0 through 23) from a time.
MONTH	Returns the month of a date
NOW	Returns the current time
TIME	Returns the time Parameter Description Minute. Second
TODAY	Returns the current date
WEEKDAY	Returns the day of week from a date. Parameter Description Type
YEAR	Returns the year of a date

Text

Function Name	Description	Parameters	Example
EXACT	Reports if two text values are exactly equal using a case-sensitive comparison. Parameter Description Text2
FIND	Returns the starting position of a given text. Parameter Description Text Index
LEFT	Returns a selected number of text characters from the left. Parameter Description Length
LEN	Returns the lengh in characters of the given value.
LOWER	Returns the given text in lower case.
MID	Returns extracted text, given an original text, starting position, and length. Parameter Description Start Length
REPLACE	Returns text where an old text is substituted with a new text within the start index and length range. Parameter Description Start Len New
REPT	Returns text repeated Count times.. Parameter Description Count
RIGHT	Returns a selected number of text characters from the right. Parameter Description Count
SUBSTITUTE	Returns text where an old text is substituted with a new text. If which is specified, only this occurrance will be replaced otherwise every occurrance will be replaced. Parameter Description Old New Which
T	Returns the given text value or a zero lenght string for non text type.
TEXT	Returns the given value as text.
LOWER	Returns the given text free of leading and trailing spaces. Internal multiple spaces are replaced by one.
UPPER	Returns the given text in upper case.
URLENCODE	Applies URL-Encoding to a text given in the first parameter using the encoding specified in the second parameter. If no encoding is given, ISO-8859-1 is assumed. Parameter Description Encoding

Mathematical

Function Name	Description	Parameters	Example
ABS	Returns the absolute (nonnegative) of the value.
AVERAGE	Average a list of numeric values.
Even	Returns the rounding a number up to the nearest even integer.
MAX	Returns the maximum from a set of numbers.
MIN	Returns the minimum from a set of numbers.
MOD	Returns the remainder when one number is divided by another number. Parameter Description Divisor
ODD	Returns the rounding a number up to the nearest odd integer.
SUM	Sum a list of numeric values.

Logical

Function Name	Description	Parameters	Example
AND	Logical AND
FALSE	Logical FALSE
IF	Conditional execution Parameter Description A term that is evaluated if the condition evaluates to true. A term that is evaluated if the condition evaluates to false.
AND	Logical AND
OR	Logical OR
TRUE	Logical TRUE
XOR	Logical XOR