Why are there three report ranges?
 |
This article or section is under development. Be aware: Content will change as the document progresses. |
Summary
The three range screens in the Report Generator can speed up some reports considerably.
It is advisable you only use ranges 2 and 3 for complex reports.
More Information
Each range screen is processed in order form 1 to 3 and all variables on a range are evaluated before the range is executed. Variables on range 2 are not evaluated until range 1 has passed and variables on range 3 are not evaluated until range 2 has passed.
Using this information you can split up your ranges so that you spread your variables, save any time expensive evaluation variables (period totals, period balances etc) for ranges 2 or 3. Keep range 1 for simple variables such as codes, names, addresses, descriptions etc - these variables usually are usually entered on a "Property Screen".
- Period totals and balances have to be calculated and can therefore take a while, there is no reason to calculate these for the range if the data is for a stock line or account that falls outside the range.
Example
A report to list all accounts in account group 'MAIN' with a period turnover in the last 3 months over £2000.
- A01 = Account Ledger.
- Every transaction knows if it is on the Sales Ledger 'S' or Purchase Ledger 'P'.
- A07 = Account Group.
- Each account has it's group recorded.
- A08 = Period Balance.
- Time taken to evaluate is data dependant - Lots of transaction will take a while.
Range 1 A01 = "S" AND A07 = "MAIN"
Range 2
A08....
