Sort/query/total order

[Scott_Pierson_(Guest)]

I^m trying to get a better idea of the sequence in which RR builds reports.____First you get one pre-processed total scan. One can have as many pre-processed totals as one wishes as long as they calculate within that one scan. If you have calculated fields that preceed the pre-processed total, do these fields automatically pre-process or do all calculated fields process during this pre-scan? What about calculated fields based on non-preprocessed totals? Is it correct to say that they process later?____Then you get a sort-just one sort, no pre-sort. And you can^t sort on anything but existing table fields, calculated fields that don^t contain themselves, and pre-processed totals.____After that comes the last scan which runs the non preprocessed totals. calculated fields based on these non-preprocessed totals will process at the same time.____Queries, on the other hand, seem to be able to filter information during different stages of report generation. It seems to me that queries can filter original table records, total/calculated fields relating to the pre-scan, calculated fields relating to the sort as well as calculated fields related to the second/final total scan. The one thing to be aware of, though, is that a query based on an original table record could extensibly alter/limit the result of a ^later^ query such as one based on a calculated field that generates from a final scan total.____Is this close to being in the right ballpark?____

[kfleming]

The basic process behind the scenes is that R&R processes the master table records one at a time and from them builds any required relations. This create the composite database. This database is then sorted and grouped as required and then additionally filtered based on any query. You can sort on calculated fields that do not combine database fields and total fields.__The addition of pre-processed totals adds a layer of complexity to all of this in that you need to make a first pass to collect the totals and a second pass to use those totals. And the presence of pre-processed totals can restrict what fields are available for sorting and grouping.____Kathleen__R&R Support