What is a report generator variable?

From Catalyst
Revision as of 10:00, 25 June 2008 by Les Ward (talk | contribs) (Example)
Jump to: navigation, search

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