Enterprise
Schedule Free DemoSupportBlogDemos
Try it Free
Search results
Suggest a FeaturePDF

Built-in Functions

Text Functions

References Description Example
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 formatted string according to the instructions 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). =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 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. =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 the string without left side trailing spaces in the given string. =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. =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 the string without right side trailing spaces in the given string. =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 the string without trailing spaces in the given string =Trim(Fields!Description.Value)
UCase Returns a string or character containing the specified string converted to uppercase. =UCase(Fields!Description.Value)

Date Time Functions

References Description Example
CDate Convert to date. =CDate(Fields!BirthDate.Value)
DateAdd Returns a long value specifying the number of time intervals between two date values. =DateAdd("d",3,Fields!BirthDate.Value)
DatePart Returns an integer value containing the specified component of a given date value. =DatePart("q",Fields!BirthDate.Value,0,0)
DateSerial Returns a date value representing a specified year, month, and day, with the time information set to midnight (00:00:00). =DateSerial(DatePart("yyyy",Fields!BirthDate.Value)-10, DatePart("m",Fields!BirthDate.Value)+3,DatePart("d",Fields!BirthDate.Value)-1)
DateString Returns or sets a string value representing the current date according to your system. =DatePart("m",DateString())
DateValue Returns a date value containing the date information represented by a string, with the time information. =DateValue("January 15, 2010")
Day Returns an integer value from 1 through 31 representing the day of the month. =Day(Fields!BirthDate.Value)
FormatDateTime Returns a string expression representing date/time value. =FormatDateTime(Fields!BirthDate.Value,DateFormat.ShortDate)
Hour Returns an integer value from 0 through 23 representing the hour of the day. =Hour(Fields!BirthDate.Value)
Minute Returns an integer value from 0 through 59 representing the minute of the hour. =Minute(Fields!BirthDate.Value)
Month Returns an integer value from 1 through 12 representing the month of the year. =Month(Fields!BirthDate.Value)
MonthName Returns a string value containing the name of the specified month. =MonthName(10,True)
Now Returns a date value containing the current date and time according to your system. ="This time tomorrow is " & DateAdd("d", 1, Now())
Second Returns an integer value from 0 through 59 representing the second of the minute. =Second(Fields!BirthDate.Value)
TimeOfDay Returns or sets a date value containing the current time of day according to your system. ="Time of the day is " & TimeOfDay()
Timer Returns a double value representing the number of seconds elapsed since midnight. ="Number of seconds since midnight " & Timer()
TimeSerial Returns a date value representing a specified hour, minute, and second, with the date information set relative to January 1 of the year 1. =TimeSerial(DatePart("h",Fields!BirthDate.Value), 'DatePart("n",Fields!BirthDate.Value),DatePart("s",Fields!BirthDate.Value))
TimeString Returns or sets a string value representing the current time of day according to your system. =TimeString()
TimeValue Returns a date value containing the time information represented by a string, with the date information set to January 1 of the year 1. =TimeValue(Fields!BirthDate.Value)
Today Returns or sets a date value containing the current date according to your system. ="Tomorrow is " & DateAdd("d", 1, Today())
Weekday Returns an integer value containing a number that represents the day of the week. =Weekday(Fields!BirthDate.Value,0)
WeekdayName Returns a string value containing the name of the specified weekday. =WeekdayName(2,True,0)
Year Returns an integer value from 1 through 9999 representing the year. =Year(Fields!BirthDate.Value)

Math Functions

References Description Example
Abs Returns the absolute value of a single-precision floating-point number. =Abs(Fields!YearlyIncome.Value - 80000)
Acos Returns the angle whose cosine is the specified number. =Acos(Fields!Angle.Value)
Asin Returns the angle whose sine is the specified number. =Asin(Fields!Angle.Value)
Atan Returns the angle whose tangent is the specified number. =Atan(Fields!Tangent.Value)
tan2 Returns the angle whose tangent is the quotient of two specified numbers. =Atan2(Fields!CoordinateY.Value,Fields!CoordinateX.Value)
BigMul Produces the full product of two 32-bit numbers. =`BigMul(Fields!Int32Value.Value, Fields!Int32Value.Value)
Ceiling Returns the smallest integer that is greater than or equal to the specified integer. =Ceiling(Fields!YearlyIncome.Value / 7)
Cos Returns the cosine of the specified angle. =Cos(Fields!Angle.Value)
Cosh Returns the hyperbolic cosine of the specified angle. =Cosh(Fields!Angle.Value)
Exp Returns e raised to the specified power. =Exp(Fields!IntegerCounter.Value)
Fix Returns an integer portion of a number. =Fix(Fields!YearlyIncome.Value /-3)
Floor Returns the largest integer less than or equal to the specified integer. =Floor(Fields!YearlyIncome.Value / 12)
Int Returns an integer portion of a number. =Int(Fields!YearlyIncome.Value / 12)
Log Returns the natural (base e) logarithm of a specified number. =Log(Fields!NumberValue.Value)
Log10 Returns the base 10 logarithm of a specified number. =Log10(Fields!NumberValue.Value)
Max Returns the maximum value from all non-null values of the specified expression. =Max(Fields!YearlyIncome.Value, "AdventureWorks", Recursive)
Min Returns the minimum value from all non-null values of the specified expression. =Min(Fields!YearlyIncome.Value, "AdventureWorks", Recursive)
Pow Returns a specified number raised to the specified power. =Pow(Fields!YearlyIncome.Value,2)
Rnd Returns a random number of single type. =Rnd(-1)
Round Rounds a double-precision floating-point value to the nearest integer. =Round(Fields!YearlyIncome.Value / 12, 2)
Sign Returns a value indicating the sign of an 8-bit signed integer. =Sign(Fields!YearlyIncome.Value - 60000)
Sin Returns the sine of the specified angle. =Sin(Fields!Angle.Value)
Sinh Returns the hyperbolic sine of the specified angle. =Sinh(Fields!Angle.Value)
Sqrt Returns the square root of a specified number. =Sqrt(Fields!Area.Value)
Tan Returns the tangent of the specified angle. =Tan(Fields!Angle.Value)
Tanh Returns the hyperbolic tangent of the specified angle. =Tanh(Fields!Angle.Value)

Inspection Functions

References Description Example
IsArray Returns a Boolean value indicating whether variable points to an array. =IsArray(Parameters!Initials.Value)
IsDate Returns a Boolean value indicating whether an expression represents a valid. =IsDate(Fields!BirthDate.Value)
IsNothing Returns a Boolean value indicating whether an expression has no object. =IsNothing(Fields!MiddleInitial.Value)
IsNumeric Returns a Boolean value indicating whether an expression can be evaluated as a number. =IsNumeric(Fields!YearlyIncome.Value)

Program Flow Functions

References Description Example
Choose Selects and returns a value from a list of arguments. =Tanh(Fields!Angle.Value)=Choose(Datepart("w", Fields!BirthDate.Value), "First", "Second", "Third", "Fourth", "Fifth", "Sixth", "Seventh")
IIf Returns one of two objects depending upon the evaluation of an expression. =Tanh(Fields!Angle.Value) =IIf(Fields!YearlyIncome.Value >= 60000,"High","Low")
Switch Evaluates a list of expressions and returns an object value corresponding to the first expression in the list that is true. =Switch(Fields!FirstName.Value = "Sue", "Susan",Fields!FirstName.Value = "Bob", "Robert")

Aggregate Functions

References Description Example
Avg Returns the average of all non-null values from the specified expression. =Avg(Fields!YearlyIncome.Value, "GroupByGender", Recursive)
Count Returns a count of the values from the specified expression. =CountDistinct(Fields!MiddleInitial.Value, "GroupByInitial", Recursive)
CountDistinct Returns a count of all distinct values from the specified expression. =CountDistinct(Fields!MiddleInitial.Value, "GroupByInitial", Recursive)
CountRows Returns a count of rows within the specified scope. =CountRows("GroupByInitial", Recursive)
First Returns the first value from the specified expression. =First(Fields!MiddleInitial.Value, "AdventureWorks")
Last Returns the last value from the specified expression. =Last(Fields!MiddleInitial.Value, "AdventureWorks")
Max Returns the maximum value in the given expression. =Max(Fields!YearlyIncome.Value, "AdventureWorks", Recursive)
Min Returns the minimum value in the given expression. =Min(Fields!YearlyIncome.Value, "AdventureWorks", Recursive)
StDev Returns the standard deviation of all non-null values of the specified expression. =StDev(Fields!YearlyIncome.Value,"GroupByInitial",Recursive)
StDevP Returns the population standard deviation of all non-null values of the specified expression. =StDevP(Fields!YearlyIncome.Value,"GroupByInitial",Recursive)
Sum Returns a sum of the values of the specified expression. =Sum(Fields!YearlyIncome.Value,"GroupByInitial",Recursive)
Var Returns the variance of all non-null values of the specified expression. =Var(Fields!YearlyIncome.Value,"GroupByInitial",Recursive)
VarP Returns the population variance of all non-null values of the specified expression. =VarP(Fields!YearlyIncome.Value,"GroupByInitial")
RunningValue Uses a specified function to return a running aggregate of the specified expression. =RunningValue(Fields!YearlyIncome.Value,Sum,"AdventureWorks")
Aggregate Returns a custom aggregate of the specified expression, as defined by the data provider. =Aggregate(Fields!Order_Count.Value)

Financial Functions

References Description Example
DDB Returns a double value specifying the depreciation of an asset for a specific time period using the double-declining balance method or some other method you specify. =DDB(Fields!CostOfProperty.Value,Fields!Salvage.Value,Parameters!Life.Value,Parameters!Period.Value,2)
FV Returns double value specifying the future value of an annuity based on periodic fixed payments and a fixed interest rate. =FV(Parameters!Rate.Value,Parameters!NumberOfPayments.Value, Parameters!PaymentAmount.Value,Fields!PropertyCost.Value,DueDate.EndOfPeriod)
IPmt Returns double value specifying the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate. =IPmt(Parameters!Rate.Value, Parameters!PaymentPeriod.Value, Parameters!NumberOfPayments.Value, 'Parameters!PresentValue.Value, 0,DueDate.EndOfPeriod)
NPer Returns a double value specifying the number of periods for an annuity based on periodic fixed payments and a fixed interest rate. =NPer(Parameters!Rate.Value, Parameters!PaymentAmount.Value,Parameters!PresentValue.Value,0,DueDate.EndOfPeriod)
Pmt Returns a double value specifying the payment for an annuity based on periodic, fixed payments and a fixed interest rate. =Pmt(Parameters!Rate.Value, Parameters!NumberOfPayments.Value,Fields!PropertyCost.Value,0, DueDate.EndOfPeriod)
PPmt Returns a double value specifying the principal payment for a given period of an annuity based on periodic fixed payments and a fixed interest rate. =PPmt(Parameters!Rate.Value,Parameters!Period.Value,Parameters!NumberOfPayments.Value, Fields!PropertyCost.Value,0,DueDate.EndOfPeriod)
PV Returns a double value specifying the present value of an annuity based on periodic, fixed payments to be paid in the future and a fixed interest rate. =PV(Parameters!Rate.Value, Parameters!NumberOfPayments.Value,Fields!PaymentAmount.Value,0,DueDate.EndOfPeriod)
Rate Returns a double value specifying the interest rate per period for an annuity. =Rate(Parameters!NumberOfPayments.Value,Parameters!PaymentAmount.Value,Parameters!PresentValue.Value, DueDate.EndOfPeriod,0.1)
SLN Returns a double value specifying the straight-line depreciation of an asset for a single period. =SLN(Fields!PropertyCost.Value,Parameters!Salvage.Value,Parameters!Life.Value)
SYD Returns a double value specifying the sum-of-years digits depreciation of an asset for a specified period. =SYD(Fields!PropertyCost.Value,Parameters!Salvage.Value, Parameters!Life.Value,Parameters!Period.Value)

Conversion Functions

References Description Example
CBool Convert to Boolean. =CBool(Fields!HouseOwnerFlag.Value)
CByte Convert to byte. =CByte(Fields!Number.Value)
CChar Convert to char. =CChar(Fields!MaritalStatus.Value)
CDate Convert to date. =CDate(Fields!BirthDate.Value)
CDbl Convert to double. =CDbl(Fields!YearlyIncome.Value)
CDec Convert to decimal. =CDec(Fields!YearlyIncome.Value)
CInt Convert to integer. =CInt(Fields!YearlyIncome.Value)
CLng Convert to lone. =CLng(Fields!YearlyIncome.Value)
CObj Convert to object. =CObj(Fields!YearlyIncome.Value)
CShort Convert to short. =CShort(Fields!NumberCarsOwned.Value)
CSng Convert to single. =CSng(Fields!YearlyIncome.Value)
CStr Convert to string. =CStr(Fields!YearlyIncome.Value)
Fix Returns an integer portion of a number. =Fix(Fields!YearlyIncome.Value / -3)
Hex Returns a string representing the hexadecimal value of a number. =Hex(Fields!CellColor.Value)
Int Returns an integer portion of a number. =Int(Fields!YearlyIncome.Value / 12)
Oct Returns a string representing the octal value of a number. =Oct(Fields!BitString.Value)
Str Returns a string that represents a number. =Str(Fields!YearlyIncome.Value)
Val Returns numbers in a string as a numeric value of appropriate type. =Val(Fields!AddressLine1.Value)

Miscellaneous Functions

References Description Example
InScope Returns true if the current instance is within the specified scope. =InScope("table1_Group1")
Level Returns a zero-based integer representing the current depth level. =Level("GroupByInitial")
Lookup Use Lookup to retrieve the value from the specified dataset for a name-value pair where there is a 1-to-1 relationship. =Lookup(Fields!SaleProdId.Value, Fields!ProductID.Value, Fields!Name.Value, "Product")
LookupSet Use LookupSet to retrieve a set of values from the specified dataset for a name-value pair where there is a 1-to-many relationship. =LookupSet(Fields!TerritoryGroupID.Value, Fields!TerritoryID.Value, Fields!StoreName.value, "Stores")
Previous Returns the value of the expression for the previous row of data. =Previous(Fields!FirstName.Value)
RowNumber Returns a running count of all rows in the specified scope. =RowNumber("AdventureWorks")