What is a report generator variable?

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

Feedback

Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'

Keywords AND Misspellings

report generator variable, data, information