Explore Categories

 

 PDF

Variable Related Functions

$$IsSysNameVar

This function checks if the variable has a value which is a sysName like ‘Not Applicable’, ‘End of List’, etc. In case of repeated variables, if any one value is a non-sysname, it returns FALSE.

Syntax

$$IsSysNameVar : <Variable Specification>

Where,

<Variable Specification> is the simple variable path specification.

Example

$$IsSysNameVar:EmpVar

Here, $$IsSysNameVar returns YES if variable EmpVar has Sysname as value, else returns NO.

$$IsDefaultVar

This function determines if the content of the variable has a “Default” or blank as the value. This function is applicable only for Simple variables. In case of simple repeated variable, if any one value is non-default, then this is not a default variable, and the function returns NO.

Syntax

$$IsDefaultVar : <Variable Specification>

Where,

<Variable Specification> is the simple variable path specification.

Example

[Field : DefaultVar]

Set as : $$IsDefaultVar:SVValuationMethod

$$IsDefaultVar returns YES if value of SV V aluationMethod is blank or Default, else returns NO.

$$IsActualsVar

This function checks if the content of the variable is blank or sysname or “ACTUALS”.

Syntax

$$IsActualsVar : <Variable Specification>

Where,

<Variable Specification> is the simple variable path specification.

Example

$$IsActualsVar:SVBudget

YES is returned if the value of Variable SVBudget is Blank or Sysname or “ACTUALS”, else NO.

$$IsCurrentVar

This function checks if the content of t h e variable is Blank or Sysname or “ Stock in hand”.

Syntax

$$IsCurrentVar : <Variable Specification>

Where,

<Variable Specification> is the simple variable path specification.

Example

$$IsCurrentVar:DSPOrderCombo

YES is returned if value of DSPOrderCombo is Blank or Sysname or Stock-In-Hand, else NO.

$$ExecVar

This fuction returns the value of a variable in the parent report chain.

Syntax

$$ExecVar : <Variable Specification>

Where,

<Variable Specification> is the simple variable path specification.

Example

$$ExecVar:DSPShowMonthly

Function $$ExecVar returns the value of the variable DSPShowMonthly from the parent report.

$$FieldVar

This function returns the value of the field which is acting as a variable with the specified name.

Syntax

$$FieldVar : <Variable Specification>

Where,

<Variable Specification> is the simple variable path specification.

Example

[Collection : GodownChildOfGodownName]

Type     : Godown

Child of : $$FieldVar:DSPGodownName

In this example, $$FieldVar is used to fetch the value of the variable DSPGodownName whose value is modified in a field. This value becomes the value for the ‘ChildOf’ attribute.

$$ParentFieldVar

This function gets the field variable value from its parent report.

Syntax

$$ParentFieldVar : <Variable Specification>

Where,

<Variable Specification> is the simple variable path specification.

Example

[Field : ParentFieldVar]

Set as : $$ParentFieldVar:SVStockItem

Here, the function returns field variable value from its parent report for the variable “SVStockItem”.

$$NumSets

It returns the number of columns in the report. It does not take any parameter. If the report is an auto report or sub report, it returns the number of columns in the parent of the auto/sub report. Number of set is the maximum number of values a repeated variable can hold in that report.

Syntax

$$NumSets

Example

[Field : CFBK Rep Col Total]

Use       : Qty Primary Field

Set as    : $$Total:CFBKRepParty

Border    : Thin Left

Invisible : $$Numsets=1

In this example, the ‘Total’ column will be invisible if there is only one column in the report.

$$LowValue

This function c a n be used to get the lowest value in a set o f values in the repeated variable.

Syntax

$$LowValue : <Variable Specification>

Where,

<Variable Specification> is a simple variable specification.

Example

Let us suppose that the Repeat Variables in a Columnar Report are SVFromDate and SVToDate. Consider the following Field Definition in the same report:

[Field : VariableLowValue]

Use    : Name Field

Set as : $$LowValue:SVFromDate

$$Lowvalue returns the lowest value in a set of values in the repeat variable SVFromDate.

$$HighValue

This function can be used to get the highest value in a set of values in the repeated variable.

Syntax

$$HighValue : <Variable Specification>

Where,

<Variable Specification> is a simple variable specification.

Example

Suppose that the Repeat Variables in a Columnar Report are SVFromDate and SVToDate. Consider the following Field definition in the same report:

[Field : VariableHighValue]

Use    : Name Field

Set as : $$HighValue:SVToDate

$$HighValue returns the highest value in a set of values in the repeat variable SVToDate.

$$IsCommon

This function is used with repeated variable to check if all the values in the repeat set are same.

Syntax

$$IsCommon : <Variable Specification>

Where,

<Variable Specification> is a simple variable specification.

Example

Suppose the Repeat Variable in a columnar report is SVCurrentCompany. Consider the following Field Definition in the same report:

[Field : VariableIsCommon]

Use    : Logical Field

Set as : $$IsCommon:SVCurrentCompany

$$IsCommon returns YES if all values in SVCurrentCompany are same, otherwise returns NO.

TallyHelpwhatsAppbanner
Is this information useful?
YesNo
Helpful?
/* */