Progress® Telerik® Reporting R2 2017

Text Functions

Use Text functions to manipulate the text in your report. Text functions can use the following data types: String and Integer.

String manipulation:

Format(format, value)Formats the value using the specified format string. Example: =Format(' LineTotal: {0} ', Fields.LineTotal). Detailed information about date and time format specifiers can be found in Standard Date and Time Format Strings and Custom Date and Time Format Strings articles.
IndexOfSubstr(string, substring)Returns the index of the first occurrence of a string, within the specified text.
IsValidXhtml(markup)Determines if the provided markup is valid XHTML that HtmlTextBox can parse.
Join(separator, strings)Returns a string created by joining a number of substrings contained in an array.
Len(string)Gets the number of characters in a string.
Replace(string, oldSubstring, newSubstring)Returns a new string in which all occurrences of a substring in the current string are replaced with another specified substring.
Space(count)Returns a string consisting of the specified number of spaces.
Split(separator, string)Returns a string array that contains the substrings in this instance that are delimited by the specified separator.
StringCompare(stringA, stringB)Compares two specified strings and returns an integer that indicates their relative position in the sort order.
StripHtmlTags(string)Strips the HTML tags from the input text.
Substr(string, startIndex, length)Retrieves a substring from a string. The substring starts at a specified character position and has a specified length. Example: =SubStr("Telerik", 0, 3) returns "Tel".
ToLower(string)Returns a copy of the specified string converted to lowercase.
ToUpper(string)Returns a copy of the specified string converted to uppercase.
Trim(string)Removes all leading and trailing whitespace from the passed in string.
TrimEnd(string)Removes all occurrences of white space characters from the end of this instance.
TrimStart(string)Removes all occurrences of white space characters from the beginning of this instance.