Hello group,
I have a report that I haven't run in a while but when I was using it, the report ran pretty quickly. I tried to run the report today and it's very slow. Crystal stops responding for about 5 minutes before the report completes. I'm listing the Runtime stats of the report.

**************
~aaF64.rpt.rpt
**************

Report Definition
-----------------

Number of Database Fields:   18    
Number of Summary Fields:   1    
Number of Constant Formulas:   1    
Number of On-Demand Formulas:   11    Only 4 in use
Number of Global Variables:   1    
UFLs in use:   None    
Number of Subreport Objects:   5    
Page N of M Used:   Yes    
File Format Schema:   11.0.0    


Saved Data
----------

Number of Data Sources:   1    
Unicode Saved Data:   Yes    
Total Number of Records:   48652    
Selected Number of Records:   48652    
Recurring Database Record Length:   739 bytes   
Recurring Formula Record Length:   0 bytes   
Constant Formula Record Length:   21 bytes   
Size of Saved Records:   34 MB   
Size of Saved Memo Fields:   0 bytes   


Processing
----------

Grouping Done on Database Server:   No    
Sorting Done on Database Server:   Yes    
Record Selection Done on Database Server:   Yes    
Require Two Passes:   No    
Require the Total Page Count:   Yes    
Number of Nodes in Group Tree:   104    
Number of Summary Values:   1    
Size of Saved Group Tree:   1 KB   
Built the Group Tree in Progress:   No    


Latest Report Changes
---------------------



Performance Timing
------------------

Open Document:   0 ms   
Run the Database Query:   235843 ms   
Read Database Records:   5 ms   
Format First Page:   269454 ms   
Number of pages formatted:   2    
Average time to format a page:   134727 ms   
Number of page starts generated:   2    
Average time to generate a page start:   2270 ms   

******************
MED/SOM Prescriber
******************

Report Definition
-----------------

Number of Database Fields:   6    
Number of Summary Fields:   1    
Number of On-Demand Formulas:   1    
UFLs in use:   None    
Page N of M Used:   No    
File Format Schema:   11.0.0    


Performance Timing
------------------

Run the Database Query:   7 ms   For all instances
Read Database Records:   2 ms   For all instances
Format First Page:   114 ms   For all instances
Number of pages formatted:   76    For all instances
Average time to format a page:   1 ms   For all instances
Number of page starts generated:   15    
Average time to generate a page start:   0 ms   For all instances
Number of subreport instances formatted:   90    
Time to format all subreport instances:   3035 ms   

*************
MED/SOM Nurse
*************

Report Definition
-----------------

Number of Database Fields:   6    
Number of Summary Fields:   1    
Number of On-Demand Formulas:   1    
UFLs in use:   None    
Page N of M Used:   No    
File Format Schema:   11.0.0    


Performance Timing
------------------

Run the Database Query:   5 ms   For all instances
Read Database Records:   0 ms   For all instances
Format First Page:   87 ms   For all instances
Number of pages formatted:   76    For all instances
Average time to format a page:   1 ms   For all instances
Number of page starts generated:   15    
Average time to generate a page start:   0 ms   For all instances
Number of subreport instances formatted:   90    
Time to format all subreport instances:   1674 ms   

*****************
CPST Face to Face
*****************

Report Definition
-----------------

Number of Database Fields:   5    
Number of On-Demand Formulas:   1    
UFLs in use:   None    
Page N of M Used:   No    
File Format Schema:   11.0.0    


Performance Timing
------------------

Run the Database Query:   7 ms   For all instances
Read Database Records:   9 ms   For all instances
Format First Page:   97 ms   For all instances
Number of pages formatted:   76    For all instances
Average time to format a page:   1 ms   For all instances
Number of page starts generated:   15    
Average time to generate a page start:   0 ms   For all instances
Number of subreport instances formatted:   90    
Time to format all subreport instances:   3064 ms   

**********************
Release of Information
**********************

Report Definition
-----------------

Number of Database Fields:   4    
Number of Summary Fields:   1    
Number of On-Demand Formulas:   1    
UFLs in use:   None    
Page N of M Used:   No    
File Format Schema:   11.0.0    


Performance Timing
------------------

Run the Database Query:   6 ms   For all instances
Read Database Records:   6 ms   For all instances
Format First Page:   123 ms   For all instances
Number of pages formatted:   76    For all instances
Average time to format a page:   1 ms   For all instances
Number of page starts generated:   15    
Average time to generate a page start:   0 ms   For all instances
Number of subreport instances formatted:   90    
Time to format all subreport instances:   2391 ms   

*

*

Report Definition
-----------------

Number of Database Fields:   17    
Number of Print Time Formulas:   11    
Number of On-Demand Formulas:   7    Only 5 in use
Number of Global Variables:   8    
UFLs in use:   None    
Page N of M Used:   Yes    
File Format Schema:   11.0.0    


Performance Timing
------------------

Number of subreport instances formatted:   90    
Time to format all subreport instances:   0 ms