- Getting Started
- Administration Guide
- User Guide
- Developer Guide
Values
Common 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 onto the design surface or add and modify the values from the Expression Editor. Following is a list of the values that you can see under the Values node in the Report Explorer and the Expression Editor.
COMMON VALUES
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. |
|
Page Number | Displays the current page number. It can be used in the Page Header and Page Footer. |
|
Total Pages | Displays the total number of pages. It can be used in the Page Header and Page Footer. |
|
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 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. |
|
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. |
|
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. |
|
Report Name | Displays the name of the report. |
|
User ID | Displays the User ID of the user previewing the report. |
|
User Language | Displays the Language of the user previewing the report as per system settings. |
|
User Context | "Use only with function, e.g. UserContext.GetValue(""name""), UserContext.NumberToWords(123)." |
|
OPERATIONS
Arithmetic
Value | Description | Syntax (S) and Example (E) |
---|---|---|
^ | Raises a number to the power of another number. | S: |
* | Evaluates the multiplication of two numbers. | S: |
/ | Divides two numbers (numerator by denominator) and returns the quotient as a floating-point number. | S: |
** | Divides two numbers and returns an integer result. | S: |
Mod | Divides two numbers and returns the remainder. | S: |
+ | Evaluates the sum of two numbers or concatenates two strings. | S: |
- | Evaluates the difference between two numbers or negates the value of a numeric expression. | S: |
Comparision
Value | Description | Syntax (S) and Example (E) |
---|---|---|
< | Returns True if the left operand is less than the right operand. | S: |
<= | Returns True if the left operand is less than or equal to the right operand. | S: |
> | Returns True if the left operand is greater than the right operand. | S: |
>= | Returns True if the left operand is greater than or equal to the right operand. | S: |
= | Returns True if the left operand is equal to the right operand. | S: |
<> | Returns True if the left operand is not equal to the right operand. | S: |
Like | Compares two strings and returns True if the left operand is the same as the right operand. | S: |
Is | Compares two object references and returns True if the left operand is identical to the right operand. | S: |
Concatenation
Value | Description | Syntax (S) and Example (E) |
---|---|---|
& | Returns the string value of the concatenation of two expressions that individually evaluate to strings. | S: |
+ | Evaluates the sum of two numbers or concatenates two strings. | S: |
Logical / Bitwise
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: |
Not | Returns the logical negation of a Boolean expression, or the bitwise negation of a numeric expression. | S: |
Or | Returns the logical disjunction of two Boolean expressions, or the bitwise disjunction of two numeric values. | S: |
Xor | Returns a logical exclusion operation of two Boolean expressions, or a bitwise exclusion of two numeric expressions. | S: |
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: |
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: |
Bit Shift
Value | Description | Syntax (S) and Example (E) |
---|---|---|
<< | Performs an arithmetic left shift on a bit pattern. | S: |
>> | Performs an arithmetic right shift on a bit pattern. | S: |
DOCUMENT MAP
Value | Description | Expression |
---|---|---|
Path | Returns the path of the TOC level. |
|