Formula List - Aspose.Cells for Reporting Services

Report fields
Set Name	Formula Name	Description
Global fields	ExecutionTime	The date and time when the report began to run.
	ReportServerUrl	The URL of the report server on which the report is being run.
	ReportName	The name of the report as it is stored in the report server database.
	ReportFolder	The full path to the folder containing the report. This does not include the report server URL.
User	UserID	The ID of the user running the report.
User	Language	The language ID of the user running the report.

Report fields
Set Name	Description
Parameters	The Parameters collection contains the report parameters within the report. Parameters can be passed to queries, used in filters or used in other functions that alter the report appearance based on the parameter.
Fields	The Fields collection contains the fields within the current dataset.
DataSet

Operators Arithmetic operators are used to combine numbers, numeric variables, numeric fields and numeric functions to get another number. Comparison operators are usually used to compare operands for a condition in a control structure such as an If statement. Boolean operators are typically used with comparison operators to generate conditions for control structures.
Set Name	Formula name	Description
Arithmetic	^	Exponentiation e.g. 2^3.
	*	Multiplication e.g. 2*3.
	/	division e.g. 2/3.
	\\	Integer Division e.g. 2\\3.
	Mod	Modulus e.g. 4 Mod 3.
	+	Addition e.g. 4 + 3.
	-	subtraction e.g. 4 – 3.
Comparison	<	less than e.g. 4 < 3 false.
	<=	less than or equal e.g. 4 <= 3 false.
	>	greater than e.g. 4 > 3 true.
	>=	greater than or equal e.g. 4 >= 3 true.
	=	equal e.g. 4 = 3 false.
	<>	not equal e.g. 4 <> 3 true.
	Like	Compares a string against a pattern. e.g. result = string Like pattern.
	Is	Compares two object reference variables e.g. asp Is aspose.
Concatenation	&	Generates a string concatenation of two expressions.
Concatenation	+	Adds two numbers or returns the positive value of a numeric expression. Can also be used to concatenate two string expressions.
Logical/Bitwise	And	Performs a logical conjunction on two Boolean expressions, or a bitwise conjunction on two numeric expressions.
	Not	Performs logical negation on a Boolean expression, or bitwise negation on a numeric expression.
	Or	Performs a logical disjunction on two Boolean expressions, or a bitwise disjunction on two numeric expressions.
	Xor	Performs a logical exclusion on two Boolean expressions, or a bitwise exclusion on two numeric expressions.
	AndAlso	Performs short-circuiting logical conjunction on two expressions.
	OrElse	Performs short-circuiting inclusive logical disjunction on two expressions.
Bit Shift	>>	Performs an arithmetic left shift on a bit pattern.
Bit Shift	<<	Performs an arithmetic right shift on a bit pattern.

Common Functions
Set Name	Formula Name	Description
Text	Asc	Returns an Integer value representing the character code corresponding to a character.　e.g. Asc("A")
	AscW
	Chr	Returns the character associated with the specified character code. e.g. Chr(62)
	ChrW
	Filter	Returns a zero-based array containing a subset of a String array based on specified filter criteria. e.g. subStrings = Filter(TestStrings, "is", True, CompareMethod.Binary)
	Format	Returns a string formatted according to instructions contained in a format String expression.
	FormatCurrency	Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.
	FormatDateTime	Returns a string expression representing a date/time value.
	FormatNumber	Returns an expression formatted as a number.
	FormatPercent	Returns an expression formatted as a percentage (that is, multiplied by 100) with a trailing % character.
	GetChar	Returns a Char value representing the character from the specified index in the supplied string
	InStr	Returns an integer specifying the start position of the first occurrence of one string within another
	InStrRev	Returns the position of the first occurrence of one string within another, starting from the right side of the string
	Join	Returns a string created by joining a number of substrings contained in an array
	LCase	Returns a string or character converted to lowercase
	Left	Returns a string containing a specified number of characters from the left side of a string
	Len	Returns an integer containing either the number of characters in a string or the nominal number of bytes required to store a variable
	LSet	Returns a left-aligned string containing the specified string adjusted to the specified length
	LTrim	Returns a string containing a copy of a specified string with no leading spaces
	Mid	Returns a string containing a specified number of characters from a string.
	Replace	Returns a string in which a specified substring has been replaced with another substring a specified number of times.
	Right	Returns a str