User`s guide

• Record retrieval. Where possible record selection and sorting are pushed down to the database in
this step.
• Evaluation of recurring formulas. These formulas are those that contain database fields but do not
contain references to subtotals or summary information. This evaluation time is known as
"WhileReadingRecords." 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.
B.1.4 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.
B.1.5 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:
• Group selection formulas.
• Running totals.
• Calculation of formulas marked "WhilePrinting Records."
2012-03-14672
Report Processing Model