- GettingStarted
- DeveloperGuide
-
ReportAuthorGuide
- Tabular Reports
- Get Started with the Standalone Report Designer
- Quick Start
- Summary Reports
- Layout type
- Banded Reports
- Drill Down Reports
- Report Designer Interface
- Report Viewer Interface
- Fixed Layout Reports
- Drill Through Reports
- Data Binding
- Report Themes
- Report Parameters
- Interactive Reports
- Expressions
- Report-Items
- Hyperlinks
- Drill-down
- Overview
- Tutorial-3-Master-Report
- Drill-through
Text Functions
Contains
Returns a boolean value indicating whether a specified substring occurs within the calling string. This function performs a case-sensitive comparison.
Syntax
<String>.Contains(substring)
Arguments
substring- the string to seek.
Examples
You can use the following expression to find out whether the current ProductName field value contains the MP3 string.
{ProductName.Contains("MP3")}
EndsWith
Returns a boolean value indicating whether the end of the calling string instance matches a specified string. This function performs a case-sensitive comparison.
Syntax
<String>.EndsWith(str)
Arguments
str- the string to compare to the substring at the end of the calling string.
Examples
You can use the following expression to find out whether the current ProductName field value ends with the player string.
{ProductName.EndsWith("player")}
IndexOf
Returns the zero-based index of the first occurrence of a specified string within the calling string. The method returns -1 if the string is not found. This function performs a case-sensitive comparison.
Syntax
<String>.IndexOf(str, [startIndex])
Arguments
str- the string to seek.startIndex- an optional number indicating the search starting position
Examples
You can use the following expression to return the first whitespace's position in the current ProductName field value.
{ProductName.IndexOf(" ")}
InStr
Returns a number specifying the 1-based position of the first occurrence of one string within another.
Syntax
InStr(string1, string2)
Arguments
string1- the string being searched.string2- the string to seek.
Examples
You can use the following expression to return the first whitespace's position in the current ProductName field value.
{InStr(ProductName, " ")}
LastIndexOf
Returns the zero-based index of the last occurrence of a specified string within the calling string. The method returns -1 if the string is not found. This function performs a case-sensitive comparison.
Syntax
<String>.LastIndexOf(str, [startIndex])
Arguments
str- the string to seek.startIndex- an optional number indicating the search starting position
Examples
You can use the following expression to return the last whitespace's position in the current ProductName field value.
{ProductName.LastIndexOf(" ")}
Replace
Returns a new string in which all occurrences of a specified string in the calling string are replaced with another specified string.
Syntax
<String>.Replace(oldValue, newValue)
Arguments
oldValue- the string to be replaced.newValue- the string to replace all occurrences ofoldValue.
Examples
You can use the following expression to remove all whitespaces in the current ProductName field value.
{ProductName.Replace(" ", "")}
StartsWith
Returns a boolean value indicating whether the beginning of the calling string matches the specified string. This function performs a case-sensitive comparison.
Syntax
<String>.StartsWith(str)
Arguments
str- the string to compare to the substring at the beginning of the calling string.
Examples
You can use the following expression to find out whether the current ProductName field value starts with the TV string.
{ProductName.StartsWith("TV")}
Substring
Returns a substring from the calling string. The substring starts at a specified position and has a specified length.
Syntax
<String>.Substring(startIndex, [length])
Arguments
startIndex- the zero-based starting position of a substring in the calling string.length- an optional number of characters in the substring.
Examples
You can use the following expression to extract the substring starting from the first whitespace's position from the current ProductName field value.
{ProductName.Substring(productName.indexOf(" ") + 1)}
ToLower
Returns a copy of the calling string converted to lower case.
Syntax
<String>.ToLower()
Examples
You can use the following expression to convert the current ProductName field value to lower case.
{ProductName.ToLower()}
ToUpper
Returns a copy of the calling string converted to upper case.
Syntax
<String>.ToUpper()
Examples
You can use the following expression to convert the current ProductDescription field value to upper case.
{ProductDescription.ToUpper()}
Trim
Returns a new string in which all leading and trailing white-space characters from the calling string are removed.
Syntax
<String>.Trim()
Examples
You can use the following expression to remove all leading and trailing white-space characters from the current value of the ProductName field.
{ProductName.Trim()}
TrimEnd
Returns a new string in which all trailing white-space characters from the calling string are removed.
Syntax
<String>.TrimEnd()
Examples
You can use the following expression to remove all trailing white-space characters from the current value of the ProductName field.
{ProductName.TrimEnd()}
TrimStart
Returns a new string in which all leading white-space characters from the calling string are removed.
Syntax
<String>.TrimStart()
Examples
You can use the following expression to remove all leading white-space characters from the current value of the ProductName field.
{ProductName.TrimStart()}