Difference between revisions of "What is a report generator variable?"

From Catalyst
Jump to: navigation, search
(See Also)
m
Line 38: Line 38:
  
 
== See also ==
 
== See also ==
* [[:Category:Reports & Parameters Report Generator functions|Report Generator functions]]
+
* [[:Category:Reports & Settings Report Generator functions|Report Generator functions]]
 
* [[Column Types in the Report Generator]]
 
* [[Column Types in the Report Generator]]
 
* [[Hidden Report Generator Columns]]
 
* [[Hidden Report Generator Columns]]

Revision as of 10:52, 28 September 2016

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).

  • 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

See also


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