Hi all

I have a report which is scheduled to run overnight as it is quite bulky and contains 650,000+ rows, this can rise to up to 1.2m by the end of the year.
When the user accesses it via Infoview it can still take upto 1 and a half minutes to display, even though it is not going anywhere near the database.

Below is the performance information:

************************
Attendance - All New.rpt
************************

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

Number of Database Fields:   21    
Number of Summary Fields:   46    
Number of On-Demand Formulas:   27    Only 24 in use
UFLs in use:   None    
Number of Chart Objects:   1    
Page N of M Used:   No    
File Format Schema:   11.0.0    


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

Number of Data Sources:   1    
Unicode Saved Data:   Yes    
Total Number of Records:   692774    
Selected Number of Records:   692774    
Recurring Database Record Length:   1 KB   
Recurring Formula Record Length:   845 bytes   
Constant Formula Record Length:   0 bytes   
Size of Saved Records:   1293 MB   
Size of Saved Memo Fields:   0 bytes   


Processing
----------

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


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

Print Time Formulas:   Changed    


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

Open Document:   0 ms   
Format First Page:   18212 ms   
Number of pages formatted:   1    
Average time to format a page:   18212 ms   
Number of Charts formatted:   1    
Time to format all charts:   0 ms   


I have found from some extensive Googling that there was an option in previous versions of Crystal Reports to Save Summaries with the report.
Is this option still available in XI as it seems the majority of the rendering time is due to 'Compressing Summaries'

Could anyone provide any information as to how to make this report faster?

I have already explored the possibility of using an on-demand subreport to duplicate the bottom few groups of the report, but as this leaves me doing some summing in SQL for the top half, and Crystal summing for the bottom half, the numbers don't always match up.

Any and all help would be gratefully received.

Thanks for your reply Rahul