Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Report now running very slow Post Reply Post New Topic
Author Message
Andrewarbogast
Newbie
Newbie
Avatar

Joined: 21 Aug 2017
Location: United States
Online Status: Offline
Posts: 39
Quote Andrewarbogast Replybullet Topic: Report now running very slow
    Posted: 24 Apr 2018 at 5:41am
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   
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 24 Apr 2018 at 9:14am
try it without page n of m
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.