Difference between revisions of "What is a report generator variable?"
(→See Also) |
|||
| Line 9: | Line 9: | ||
This information comes from your database (customers, suppliers, stock, vehicles, etc.) and is inserted into a report. The information can also be calculated from a collection of information (period balances, etc). | This information comes from your database (customers, suppliers, stock, vehicles, etc.) and is inserted into a report. The information can also be calculated from a collection of information (period balances, etc). | ||
| − | + | {{Example|text= | |
* [[REF:rprgva01|A01]] is the ''variable'' for whether an account is a customer or supplier. | * [[REF:rprgva01|A01]] is the ''variable'' for whether an account is a customer or supplier. | ||
* [[REF:rprgva02|A02]] is the ''variable'' for a customer or supplier code. | * [[REF:rprgva02|A02]] is the ''variable'' for a customer or supplier code. | ||
| Line 30: | Line 30: | ||
This test would pass as both comparisons match. | This test would pass as both comparisons match. | ||
| + | }} | ||
| − | == Where Used == | + | === Where Used === |
* Sort Order | * Sort Order | ||
* Ranges | * Ranges | ||
| Line 37: | Line 38: | ||
== See Also == | == See Also == | ||
| − | |||
| − | |||
* [[:Category:Reports & Parameters Report Generator functions|Report Generator functions]] | * [[:Category:Reports & Parameters Report Generator functions|Report Generator functions]] | ||
* [[Report Generator - Getting Started]] | * [[Report Generator - Getting Started]] | ||
| Line 47: | Line 46: | ||
* [[Why are there three ranges?]] | * [[Why are there three ranges?]] | ||
* [[REF:rprgvc01|Accessing the values of other columns.]] | * [[REF:rprgvc01|Accessing the values of other columns.]] | ||
| − | |||
| − | + | {{KB_Tags|report generator variable, data, information}} | |
| + | {{FAQ}} {{KB_RGen}} {{MClass}} | ||
Revision as of 15:18, 7 October 2013
Contents
Summary
This article describes what a variable is and how they are used.
More Information
What are they?
Essentially, a variable is a substitution for dynamic information.
How are they used?
This information comes from your database (customers, suppliers, stock, vehicles, etc.) and is inserted into a report. The information can also be calculated from a collection of information (period balances, etc).
 |
To produce a report for customer 'ABC001' you would need a range of: A01 = "S" AND A02 = "ABC001" The variables 'A01' and 'A02' are substituted with the values from your customer database and then the range is tested. "=" indicates a comparison that tests whether two values match. For a customer code of 'ABB001' the range would be evaluated as: "S" = "S" AND "ABB001" = "ABC001" This test 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 test would pass as both comparisons match. |
Where Used
- Sort Order
- Ranges
- Columns
See Also
- Report Generator functions
- Report Generator - Getting Started
- Data Import - Getting Started
- Column Types in the Report Generator
- Hidden Report Generator Columns
- How do I use Calculation Sequence?
- Why are there three ranges?
- Accessing the values of other columns.
