SunSystems Reporting Services Functions

You can use a number of SunSystems Reporting Services in-built functions as expressions:

Balance

Returns the aggregate value of the expression for all rows that are less than or equal to the value specified as the Sequence parameter:

BALANCE(Expression, Sequence, Calculation Type, Scope)

OpeningBalance

Returns the aggregate value of the expression for all rows that are less than the value specified as the Sequence parameter. Generally the sequence is set to a period parameter. The syntax for this function is:

OPENINGBALANCE(Expression, Sequence, Calculation Type, Scope)

SSLanguageToLocale

Converts the SunsSystems5 language code to the user's locale. The syntax for this function is:

SSLANGUAGETOLOCALE(Expression)

Example:

SSLANGUAGETOLOCALE("2") = en-GB

SSRound

The most common rounding method where values are rounded up or down to the nearest number of places before or after the decimal.

Note: This is not the equivalent of the Visual Basic Round method which rounds 5 to the nearest even number. For example ROUND(0.025) = 0.02, whereas SSROUND(0.025) = 0.03

The syntax for this function is:

SSROUND(numeric_expression, digit, reverse_negatives)

numeric_expression

numeric expression is any numeric expression

digit

digit specifies the number of digits to which you want to round the number derived from the numeric expression. When specifying the number of digits:

If digit is greater than 0 zero, then number is rounded to the specified number of decimal places.
If digit is 0, then number is rounded to the nearest integer.
If digit is less than 0, then number is rounded to the left of the decimal point.

You can also use a value of c for digit, which uses the currency number of decimals for the field.

reverse_negatives

reverse_negatives is a boolean. This only affects the rounding of negative numbers. When FALSE then rounding up is away from zero and rounding down is towards zero. When TRUE, then rounding up a negative number rounds towards zero, and rounding down a negative number rounds away from zero.

Example:

SSROUND(2767.345, 2, FALSE) = 2767.35
SSROUND(2767.345, -2, FALSE) = 2800.00


Negative Rounding Expressions	SSRound	SSRoundUp	SSRoundDown
(2767.345, -2, FALSE)	2767.35	2767.35	2767.34
(-2767.345, -2, FALSE)	-2767.35	-2767.35	-2767.34
(2767.344, -2, FALSE)	2767.34	2767.35	2767.34
(2767.344, -2, FALSE)	-2767.34	-2767.35	-2767.34
(2767.345, -2, TRUE)	2767.35	2767.35	2767.34
(2767.345, -2, TRUE)	-2767.35	-2767.35	-2767.34
(2767.344, -2, TRUE)	2767.34	2767.35	2767.34
(2767.344, -2, TRUE)	-2767.34	-2767.34	-2767.35

SSRoundUp

Numbers are rounded up away from zero when reverse_negatives is FALSE, and to a larger number when reverse_negatives is TRUE. The syntax for this function is:

SSROUNDUP(numeric_expression, digit, reverse_negatives)

Example:

SSROUNDUP(2767.344, 2, FALSE) = 2767.35

SSRoundDown

Numbers are rounded down away from zero when reverse_negatives is FALSE, and to a smaller number when reverse_negatives is TRUE. The syntax for this function is:

SSROUNDUP(numeric_expression, digit, reverse_negatives)

Example:

SSROUNDUP(2767.345, 2, FALSE) = 2767.34

SSMRound

Values are rounded up or down to the nearest multiple of the unit specified. The syntax for this function is:

SSMROUND(numeric_expression, multiple_unit, reverse_negatives)

numeric_expression: numeric expression is any numeric expression
multiple_unit: multiple_unit is always a positive number
reverse_negatives: reverse_negatives is a boolean. When FALSE then any rounding up or down is away or towards zero. When TRUE, then any rounding up results in a larger number and rounding down results in a smaller number.

Example:

SSMROUND(2767.345, 2, FALSE) = 2768
SSROUND(10, 3, FALSE) = 9

SSMRoundUp

Values are rounded up to the nearest multiple of the unit specified.

SSMRoundDown

Values are rounded down to the nearest multiple of the unit specified.