Difference between revisions of "What is a report generator variable?"
(New page: == 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 ...) |
Dave Laundon (talk | contribs) |
||
| Line 1: | Line 1: | ||
== Summary == | == Summary == | ||
| − | This article | + | This article describes what a ''variable'' is and how they are used. |
== More Information == | == More Information == | ||
| − | === What | + | === What are they? === |
Essentially, a variable is a substitution for dynamic information. | Essentially, a variable is a substitution for dynamic information. | ||
=== How are they used? === | === How are they used? === | ||
| − | This information comes from your database ( | + | 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 == | == Example == | ||
| − | * A01 is the ''variable'' for | + | * A01 is the ''variable'' for whether an account is a customer or supplier. |
* A02 is the ''variable'' for a customer or supplier code. | * A02 is the ''variable'' for a customer or supplier code. | ||
| − | To | + | To produce a report for customer {{DataValue|ABC001}} you would need a ''range'' of: |
A01 = "S" AND A02 = "ABC001" | A01 = "S" AND A02 = "ABC001" | ||
| − | The ''variables'' {{DataValue|A01}} and {{DataValue|A02}} | + | The ''variables'' {{DataValue|A01}} and {{DataValue|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 {{DataValue|ABB001}} the range would be evaluated as : | + | For a customer code of {{DataValue|ABB001}} the range would be evaluated as: |
"S" = "S" AND "ABB001" = "ABC001" | "S" = "S" AND "ABB001" = "ABC001" | ||
| − | This | + | This test would fail as the second comparison doesn't match. |
| − | For a customer code of {{DataValue|ABC001}} the range would be evaluated as : | + | For a customer code of {{DataValue|ABC001}} the range would be evaluated as: |
"S" = "S" AND "ABC001" = "ABC001" | "S" = "S" AND "ABC001" = "ABC001" | ||
| − | This | + | This test would pass as both comparisons match. |
== Where Used == | == Where Used == | ||
Revision as of 08:51, 25 June 2008
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).
Example
- A01 is the variable for whether an account is a customer or supplier.
- A02 is the variable for a customer or supplier code.
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
