What is a report generator variable?
Summary
This article attempts to describe what a variable is and how they are used.
More Information
What is it?
Essentially, a variable is a substitution for dynamic information.
How are they used?
This information comes from your database (customer, supplier, stock, vehicle etc) and is inserted into report. They can also be calculated from a collection of information (period balances etc).
Example
- A01 is the variable for if an account is a customer or supplier.
- A02 is the variable for a customer or supplier code.
To filter a report for a customer code of 'ABC001' you would need a range of :-
A01 = "S" AND A02 = "ABC001"
The variables 'A01' and 'A02' would be replaced with the values from your customer database before the range was executed.
For a customer code of 'ABB001' the range would be evaluated as :-
"S" = "S" AND "ABB001" = "ABC001"
This range would fail as the second comparison doesn't match.
For a customer code of 'ABC001' the range would be evaluated as :-
"S" = "S" AND "ABC001" = "ABC001"
This range would pass as the both comparisons match.
Where Used
- Sort Order
- Ranges
- Columns
