How do I create a report sort order?
 |
This article or section is under review. Be aware: Content may change as the document is reviewed. |
 |
This article or section is under development. Be aware: Content will change as the document progresses. |
Summary
This article explains how to create and use the "Sort Order" in the Report Generator.
More Information
The "Sort Order" has a number of purposes.
The obvious purpose is to put the report into the order in which you want to see the information. If you want a report sorted by 'Account Code', then this would be the first variable in your "Sort Order".
The other purposes are important so that you get the correct information from the report.
The variables in your "Sort Order" must be unique for every record that you want to include. If they are not, then records will be excluded.
For example, if you want a report to show customer names and email addresses, then the "Sort Order" can be 'Account Code'. This will be unique for every customer hence, depending on your "Range Filter", you will get every customer that you want.
If, however, you want to report on customer transactions, then you will need more than just the Template:Account Code as this will not be unique for every transaction. You will need 'Document Number' and 'Document Count' to make the "Sort Order" unique.
