beautypg.com

Pre-pass 2, Pass 2 – HP Intelligent Management Center Standard Software Platform User Manual

Page 751

background image

Formulas that contain references to subtotals or summary information
are processed in the second pass.

Application of the record selection locally. If the record selection is too
complex to be pushed down to the database, it is applied by Crystal
Reports in this step.

Application of the saved data record selection formulas. When records
return to the report, they are further filtered through any existing saved
data formulas.

Sorting, grouping, and totaling. In this step, Crystal Reports sorts the
records, separates them into groups, and then calculates the subtotals
and summaries needed for each group.

Cross-Tab, chart, and map generation. Only Cross-Tabs, charts, and
maps that are based entirely on database fields and recurring formulas
are generated in Pass 1. If these objects include running totals and/or
PrintTime formulas, they are generated in Pass 2.

Storage of saved data. After the totaling process is complete, all of the
records and totals are stored in memory and to temporary files. Crystal
Reports does not read the database again, but instead uses this saved
data during all subsequent processing.

Pre-pass 2

During Pre-Pass 2, Crystal Reports orders the groups in the report for
Top/Bottom N or Hierarchical Grouping. The records are not read in this
process, instead Crystal Reports only looks at group instances from Pass
1, and takes the Top N as appropriate, or orders the groups based on the
Hierarchical Grouping settings specified.

Pass 2

Crystal Reports enters the second pass through the data to format pages.
The pages are formatted on demand. This means that Crystal Reports will
not format a page until it is requested by the user, or until it is required for
the total page count in Pass 3.

During page formatting, Crystal Reports does the following:

Crystal Reports 2008 SP3 User's Guide

751

A

Report Processing Model

Overview