Expression Editor values

NAVIGATION   Modules > Advanced Reporting > Categories icon > click a row > Edit > click an element >  Properties > Data Binding > Expressions > Values

SECURITY  Advanced Reporting > View Reporting and run reports

Values are run-time values available for every property in each report. You can directly drag and drop these common values from the report Explorer pane into the design area or add and modify the values from the Expression Editor.

Refer to the following tables that contain details about each of the values included in Advanced Reporting

To learn more about how to apply values, refer to Advanced Reporting: Expression Editor.

Value Description Expression
Current Date and Time Displays the current date and time. The date and time are displayed in MM/DD/YYYY and HH:mm:ss 12-hour format. It can be used in the Page Header and Page Footer. {&ExecutionTime}
Page Number Displays the current page number. It can be used in the Page Header and Page Footer. {&PageNumber}
Total Pages Displays the total number of pages. It can be used in the Page Header and Page Footer. {&TotalPages}
Page N of M Displays the current page number (N) and the total number of pages (M) in the format 'N of M'. It can be used in the Page Header and Page Footer. Page {&PageNumber} of {&TotalPages}
Page Number (Section) Displays the current page number of the section to which the function belongs. The section can be a report or a data region. {&PageNumberInSection}
Total Pages (Section) Displays the total number of pages of the section to which the function belongs. The section can be a report or a data region. {&TotalPagesInSection}
Page N of M (Section) Displays the current page number (N) and the total number of pages (M) in the format 'N of M,' of the section to which the function belongs. The section can be a report or a data region. Page {&PageNumberInSection} of {&TotalPagesInSection}
Report Name Displays the name of the report. {&ReportName}
User ID Displays the User ID of the user previewing the report. {User!UserID}
User Language Displays the Language of the user previewing the report as per system settings. {User!Language}
User Context "Use only with function, e.g. UserContext.GetValue(""name""), UserContext.NumberToWords(123)." {UserContext}
Value Description Syntax (S) and Example (E)
^ Raises a number to the power of another number.

S: <Number1> ^ <Number2>

E: {Quantity ^ 2}
* Evaluates the multiplication of two numbers.

S:<Number1> * <Number2>

E: {Quantity * 5}
/ Divides two numbers (numerator by denominator) and returns the quotient as a floating-point number.

S: <Number1> / <Number2>

E: {Quantity / 2}

** Divides two numbers and returns an integer result.

S: <Number1> \ <Number2>

E: {Quantity \ 2}

Mod Divides two numbers and returns the remainder.

S: <Number1> Mod <Number2>

E: {Quantity Mod 12}

+ Evaluates the sum of two numbers or concatenates two strings.

S: <Value1> + <Value2>

E: {Quantity + 2}

- Evaluates the difference between two numbers or negates the value of a numeric expression.

S: <Number1> - <Number2>

E: {Quantity - 2}
Value Description Syntax (S) and Example (E)
< Returns True if the left operand is less than the right operand.

S: <Value1> < <Value2>

E: {Quantity < 80000}
<= Returns True if the left operand is less than or equal to the right operand.

S:<Value1> <= <Value2>

E: {Quantity <= 500}
> Returns True if the left operand is greater than the right operand.

S: <Value1> > <Value2>

E: {Quantity > 2}

>= Returns True if the left operand is greater than or equal to the right operand.

S: <Value1> >= <Value2>

E: {Quantity >= 2}

= Returns True if the left operand is equal to the right operand.

S: <Value1> = <Value2>

E: {Quantity = 500}

<> Returns True if the left operand is not equal to the right operand.

S: <Value1> <> <Value2>

E: {Quantity <> 2}

Like Compares two strings and returns True if the left operand is the same as the right operand.

S: <String1> Like <String2>

E: {OperatingSystem Like "Windows*"}
Is Compares two object references and returns True if the left operand is identical to the right operand.

S: <Value1> Is <Value2>

E: DeviceId Is DeviceName
Value Description Syntax (S) and Example (E)
& Returns the string value of the concatenation of two expressions that individually evaluate to strings.

S: <String1> & <String2>

E: {SiteName & " - " & DeviceName}
+ Evaluates the sum of two numbers or concatenates two strings.

S:<String1> + <String2>

E: {FirstName + " " + LastName}
Value Description Syntax (S) and Example (E)
And Returns the logical conjunction of two Boolean expressions, or the bitwise conjunction of two numeric expressions.

S: <Value1> And <Value2>

E: {DeviceCount > 50 And Quantity > 5}
Not Returns the logical negation of a Boolean expression, or the bitwise negation of a numeric expression.

S:Not <Value>

E: {Not DeviceCount > 800}
Or Returns the logical disjunction of two Boolean expressions, or the bitwise disjunction of two numeric values.

S: <Value1> Or <Value2>

E: {DeviceCount > 50 Or Quantity > 5}

Xor Returns a logical exclusion operation of two Boolean expressions, or a bitwise exclusion of two numeric expressions.

S: <Value1> Xor <Value2>

E: {DeviceCount > 50 Xor Quantity > 5}
AndAlso Returns the logical conjunction of two Boolean expressions by skipping evaluation of the other expression if the evaluation of the first expression provides the result.

S: <Boolean1> AndAlso <Boolean2>

E: {Quantity < 15 AndAlso Quantity > 1}

OrElse Returns the logical disjunction of two Boolean expressions by skipping evaluation of one expression if the evaluation of the other expression provides the result.

S: <Boolean1> OrElse <Boolean2>

E: {Quantity < 15 OrElse Quantity > 1}
Value Description Syntax (S) and Example (E)
<< Performs an arithmetic left shift on a bit pattern.

S: <Number1> << <Number2>

E: {RegionID << 2}
>> Performs an arithmetic right shift on a bit pattern.

S:<Number1> >> <Number2>

E: {RegionID >> 2}
Value Description Expression
Path Returns the path of the TOC level.

{DocumentMap.Path}