Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Speed up predefined report Post Reply Post New Topic
Author Message
hermiod
Newbie
Newbie
Avatar

Joined: 15 Oct 2008
Location: United Kingdom
Online Status: Offline
Posts: 7
Quote hermiod Replybullet Topic: Speed up predefined report
    Posted: 13 Feb 2009 at 2:53am
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.
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 16 Feb 2009 at 2:46am
Hi
 
Can you try to eliminate the subreport by creating views on Database Level.
 
As subreports are basically like joins which join the main report data to subreport data so if possible you can try to combine Main Report and Sub Report Data in a View .......
 
Also you can try doing the below.....
 
*Go to File Report Options
Check  Use Indexes or Server for Speed
Check Perform Grouping on Server
 
Cheers
Rahul
 
 
IP IP Logged
hermiod
Newbie
Newbie
Avatar

Joined: 15 Oct 2008
Location: United Kingdom
Online Status: Offline
Posts: 7
Quote hermiod Replybullet Posted: 16 Feb 2009 at 10:50am

Thanks for your reply Rahul

 
I have checked the two options you suggested but this hasn't made any difference to the speed of the report.
 
 I assume using database views will only speed up the retrieval of data from the database?
 This report is scheduled to run overnight and so doesn't touch the database when the user clicks on it in Infoview. It just has to render the contents of the report using data that is already there, this is why I don't understand why it is so slow!
 
 I have read that in previous versions of Crystal, that there was an option to save summaries with the report. As the majority of the report running time has to do with 'Compressing Summaries', I think this would make a massive difference. Only problem is, I can't find this option in XI.
 
Has it been removed or is it just supposed to happen automatically now?
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.