List of ER functions in the type conversion category

Electronic reporting (ER) type conversion functions can be used to convert values between types. This article provides a summary of these functions.

Type conversion functions

Function Description
Int64Value This function returns an Int64 value that represents the specified string.
IntValue This function returns an Int value that represents the specified string.
NumberValue This function returns a Real value that is converted from the specified String value. During the conversion, the specified decimal and digit grouping separators are considered.
Value This function returns a Real value that is converted from the specified String value.

Type conversion functions in the container category

The following table describes the type conversion functions in the container category.

Function Description
Base64StringToContainer This function converts the specified input of the String type to a data item of the Container type.

Type conversion functions in the date and time category

The following table describes the type conversion functions in the date and time category.

Function Description
DateTimeValue This function returns a DateTime value that is converted from a given String value in the specified format and in an optionally specified culture to a date/time value.
DateToDateTime This function returns a DateTime value that is converted from a given Date value to a date/time value in Coordinated Universal Time (Greenwich Mean Time [GMT]).
DateValue This function returns a Date value that is converted from a given String value in the specified format and in an optionally specified culture to a date value.

Type conversion functions in the list category

The following table describes the type conversion functions in the list category.

Function Description
List This function returns a Record list value as a new list that is created from specified arguments of the Container (record) type.
ListOfFields This function returns a Record list value that is created based on the structure of a given argument of the Enumeration or Container (record) type.
Split This function splits the specified String value into substrings and returns the result as a new Record list value.
StringJoin This function returns a String value that consists of concatenated values of the specified field from the specified Record list value. The values can be separated by the specified delimiter.

Type conversion functions in the text category

The following table describes the type conversion functions in the text category.

Function Description
Char This function returns a String value that represents a single character that is referenced by the specified Unicode number.
GuidValue This function converts the specified input of the String type to a data item of the GUID type.
NumberFormat This function returns a String value that represents the specified number in the specified format and in an optionally specified culture.
QrCode This function returns a Container value that presents the Quick Response code (QR code) image for the specified string in binary format.
Text This function returns a String value that represents the specified number after it has been converted to a text string that is formatted according to the server locale settings of the current application instance.

Additional resources

Electronic Reporting overview

Formula designer in Electronic reporting

Electronic reporting formula language