• Login

DataSoft Corporation

Functions for Expression Bindings and Calculated Fields

Below is a list of functions that are used to construct expression bindings and calculated fields:

Function

Description

Example

NewLine()

Returns the newline string defined for the current environment.

[CategoryName]+NewLine()+[Description]

Result:

Beverages

Soft drinks, coffees, teas, beers and ales.

FormatString(Format, Value1, ... , ValueN)

Returns the specified string with formatted field values. 

FormatString('{0:$0.00}', [UnitPrice])

Result: $45.60

Rgb(Red, Green, Blue)

Returns a string defining a color using the Red, Green, and Blue color channel values.

Rgb(30,200,150)

Result: '30,200,150'

Argb(Alpha, Red, Green, Blue)

Returns a string defining a color using the Alpha, Red, Green, and Blue color channel values.

Argb(1,200, 30, 200)

Result: '1,200,30,200'

Join()

Concatenates the multi-value report parameter's values into a string. This function is useful when you bind a multi-value parameter to a label to display the parameter's values in a report.

This function has two overloads:

  • Join(parameter) - concatenates the specified parameter's values using comma as a separator.
  • Join(parameter, separator) - concatenates the specified parameter's values using the specified separator.

Join(?CategoriesParameter)

Result: Beverages, Condiments

Join(?CategoriesParameter, newline())

Result:

Beverages

Condiments

Thursday, 27 December 2018 Posted in Expressions Constants, Operators, and Functions