Formula List

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.
	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 other functions that alter the report appearance based on the parameters.
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, for example 2^3.
	*	Multiplication, for example 2*3.
	/	Division, for example 2/3.
	\	Integer division, for example 2\3.
	Mod	Modulus, for example 4 Mod 3.
	+	Addition, for example 4 + 3.
	-	Subtraction, for example 4 - 3.
Comparison	<	Less than, for example 4 < 3, which is false.
	<=	Less than or equal, for example 4 <= 3, which is false.
	>	Greater than, for example 4 > 3, which is true.
	>=	Greater than or equal, for example 4 >= 3, which is true.
	=	Equal, for example 4 = 3, which is false.
	<>	Not equal, for example 4 <> 3, which is true.
	Like	Compares a string against a pattern. For example, result = string Like pattern.
	Is	Compares two object reference variables, for example, asp Is aspose.
Concatenation	&	Generates a string concatenation of two expressions.
	+	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 exclusive‑or on two Boolean expressions, or a bitwise exclusive‑or 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 right shift on a bit pattern.
	«	Performs an arithmetic left shift on a bit pattern.