Common Functions


Text Functions


Asc
Returns an Integer value representing the character code corresponding to a character.
=Asc(Fields!Description.Value)

AscW
Returns an Integer value representing the character code corresponding to a character.
=AscW(Fields!Description.Value)

Chr
Returns the character associated with the specified character code.
=Chr(65)

ChrW
Returns the character associated with the specified character code.
=ChrW(241)

Filter
Returns a zero-based array containing a subset of a String array based on specified filter criteria.
=Filter(Parameters!MultivalueParameter.Value, "3", True, CompareMethod.Binary)

Format
Returns a string formatted according to instructions contained in a format String expression.
=Format(Globals!ExecutionTime, "Long Date")

FormatCurrency
Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.
=FormatCurrency(Fields!YearlyIncome.Value,0)

FormatDateTime
Returns a string expression representing a date/time value.
=FormatDateTime(Fields!BirthDate.Value,DateFormat.ShortDate)

FormatNumber
Returns an expression formatted as a number.
=FormatNumber(Fields!Weight.Value,2)

FormatPercent
Returns an expression formatted as a percentage (that is, multiplied by 100) with a trailing % character.
=FormatPercent(Fields!Sales.Value/Sum(Fields!Sales.Value, "DataSet1"),0)

GetChar
Returns a Char value representing the character from the specified index in the supplied string.
=GetChar(Fields!Description.Value, 5)

InStr
Returns an integer specifying the start position of the first occurrence of one string within another.
=InStr(Fields!Description.Value, "car")

InStrRev
Returns the position of the first occurrence of one string within another, starting from the right side of the string.
=InStrRev(Fields!Description.Value, "car")

Join
Returns a string created by joining a number of substrings contained in an array.
=Join(Parameters!MultivalueParameter.Value,",")

LCase
Returns a string or character converted to lowercase.
=LCase(Fields!Description.Value)

Left
Returns a string containing a specified number of characters from the left side of a string.
=Left(Fields!Description.Value,4)

Len
Returns an integer containing either the number of characters in a string or the number of bytes required to store a variable.
=Len(Fields!Description.Value)

LSet
Returns a left-aligned string containing the specified string adjusted to the specified length.
=LSet(Fields!Description.Value,4)

LTrim
Returns a string containing a copy of a specified string with no leading spaces (LTrim), no trailing spaces (RTrim), or no leading or trailing spaces (Trim).
=LTrim(Fields!Description.Value)

Mid
Returns a string containing a specified number of characters from a string.
=Mid(Fields!Description.Value,3,4)

Replace
Returns a string in which a specified substring has been replaced with another substring a specified number of times.
=Replace(Fields!Description.Value,"tube","headlight")

Right
Returns a string containing a specified number of characters from the right side of a string.
=Right(Fields!Description.Value,4)

RSet
Returns a right-aligned string containing the specified string adjusted to the specified length.
=RSet(Fields!Description.Value,4)

RTrim
Returns a string containing a copy of a specified string with no leading spaces (LTrim), no trailing spaces (RTrim), or no leading or trailing spaces (Trim).
=RTrim(Fields!Description.Value)

Space
Returns a string consisting of the specified number of spaces.
=Space(3)

Split
Returns a zero-based, one-dimensional array containing a specified number of substrings.
=Split(Fields!ListWithCommas.Value,",")

StrComp
Returns -1, 0, or 1, based on the result of a string comparison.
=StrComp(Fields!Description.Value,First(Fields!Description.Value))

StrConv
Returns a string converted as specified.
=StrConv(Fields!Description.Value,vbProperCase)

StrDup
Returns a string or object consisting of the specified character repeated the specified number of times.
=StrDup(3,"M")

StrReverse
Returns a string in which the character order of a specified string is reversed.
=StrReverse(Fields!Description.Value)

Trim
Returns a string containing a copy of a specified string with no leading spaces (LTrim), no trailing spaces (RTrim), or no leading or trailing spaces (Trim).
=Trim(Fields!Description.Value)

UCase
Returns a string or character containing the specified string converted to uppercase.
=UCase(Fields!Description.Value)