VSV - Access any unit details (Unit Sales Report Generator function)
From Catalyst
Syntax
$VSV{unit, expression}
Description
Changes the unit being reported on.
Parameters
- unit
- A text parameter that can be omitted.
- Unit code to use (see below).
- expression
- A text or numeric parameter that can be omitted.
- Variable or formula to evaluate (see below).
Returns
A text or numeric (depending on the parameters) value. This function may be used in three ways.
- All parameters are supplied.
 | $VSV{"1000",V01} |
- The result of the given expression using the details of the unit supplied is returned. For the example above, (using the variable V01), the description of unit with stock number 1000 would be returned.
- No expression is supplied.
| $VSV{"1000"} |
- Changes the unit being reported on; i.e. all 'V' variables in the remainder of the current block will use the details from the unit supplied. If used in a Range screen then this will affect the whole report. If no expression is supplied, the actual result of the function will be numeric - "1" if the unit exists or "0" if otherwise.
- No parameters are supplied.
| $VSV{} |
- The function may be used in this way in a block after using the function as in method 2, to change the unit being reported on back to the previous value.
