Progress
Report Builder
User’s Guide
Processing Rate
The processing rate determines when Report Builder processes the values of the aggregate field. Table 5–4 describes the processing options.
Specify Pre-pass if you want to:
- Place an aggregate field that calculates a grand total (total with the reset level at no-reset) in any band other than a summary band line or a group total (total with the reset level set for the group) in a group header band or record band of a report.
- Create a calculated field such as a percent-of-total field that compares a value in each record to a final value based on all records in a group or report.
- Use an aggregate field to sort a report.
- Use an aggregate field in a filter.
Because Report Builder accumulates prepass aggregates in a single preliminary pass through the data, you cannot prepass any aggregates that involve page formatting. See the following section for more information about this restriction.
Prepass Processing Restrictions
You cannot specify prepass processing for:
- Pagination-related aggregates such as page totals, aggregates whose accumulation frequency has been set to once per page, and aggregates involving calculated fields that use the PAGE-NUMBER( ) function. This restriction applies because Report Builder does not evaluate page formatting in the preliminary aggregate evaluation process.
- Aggregates of certain prepass aggregates such as any total-of-total fields where the total-of-total accumulates more frequently than the field being totalled resets (for example, a grand total, accumulating once per record, of a pre-processed group one subtotal). This restriction applies because the Report Builder evaluates prepass aggregates in a single extra pass. For these aggregates to be prepass, two extra passes are required: one for the first prepass aggregate and another for the field that totals it.
- Aggregates that reset or accumulate on group fields that are themselves prepass aggregates (or calculated fields whose expressions include prepass aggregates). This restriction is also a result of the single pass used to accumulate prepass aggregates. For these fields, two passes are required.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |