![]() |
|
|
|
|
|
The most common requirement for multiple-pass reports in QUIZ involves summary values (count, total, average) that have to be calculated in the first pass, so that the result can be used in the second.
In a sales report, for example, you may wish to show the percentage that each line contributes towards a customer's total amount. This is easily achieved by using Suprtool to prepare a subfile of subtotals, which QUIZ can link back to the original data files. This subfile need only contain the subtotal and the sort field, which is used for linking back to the data file. There is a useful side-effect to having a sorted subfile: when the records are linked back to the data file, the record complexes will be built in sorted order.