2594391 - How is a report processed in Crystal Reports?

What is the order in which a report is processed in Crystal Reports?

What is the multi-pass reporting flow used in Crystal Reports?

When a report is refreshed, Crystal Reports uses multi-pass to generate the report.

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.

Group selection formulas.
Running totals.
Calculation of formulas marked "WhilePrintingRecords." These are formulas that contain references to subtotals or summary information, also known as "PrintTime" formulas. This evaluation time is known as "WhilePrintingRecords."
Cross-Tabs, charts, and maps. Cross-Tabs, charts, and maps that include running totals and/or PrintTime formulas, and charts that are based on Cross-Tabs are generated in Pass 2.
OLAP grids.
Subreports.
Generation of Pages on Demand.

CR, Flow-Chart, Evaluation Time Formula , KBA , BI-RA-CR , How To

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020