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

From Catalyst
Jump to: navigation, search
(See Also)
Line 45: Line 45:
 
* [[How do I use Calculation Sequence?]]
 
* [[How do I use Calculation Sequence?]]
 
* [[Why are there three ranges?]]
 
* [[Why are there three ranges?]]
* [[What is a Report Generator variable?]]
 
 
* [[REF:rprgvc01|Accessing the values of other columns.]]
 
* [[REF:rprgvc01|Accessing the values of other columns.]]
 
* [[Useful Keys]]
 
* [[Useful Keys]]
  
 
{{FAQ}}{{MClass}}{{KB_Tags|report generator variable, data, information}}{{KB_RGen}}
 
{{FAQ}}{{MClass}}{{KB_Tags|report generator variable, data, information}}{{KB_RGen}}

Revision as of 14:36, 1 August 2013

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

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