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 casesensitive 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 URLEncoding to a text given in the first parameter using the encoding specified in the second parameter. If no encoding is given, ISO88591 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

