Print Page | Close Window

Performance Problem

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7393
Printed Date: 03 May 2024 at 7:08am


Topic: Performance Problem
Posted By: waiting
Subject: Performance Problem
Date Posted: 17 Aug 2009 at 1:28am

May i know is that any method to increase crystal report performance for large number of record? Any method to display first page before finish loading other pages?

thanks for help.


Replies:
Posted By: lockwelle
Date Posted: 18 Aug 2009 at 6:27am
remove subreports, they affect performance by causing mulitple hits to the database.  Cut down on the number of records.  If you are bringing in a large number of detail records, but you are only going to display them in summary, summarize them on the DB via a stored proc and send the summary over.
 
No, you can't display the first page until all records are read, as you might have a dynamic grouping which would change the order--I use this feature all the time.
 
How many records are we talking?

Posted By: waiting
Date Posted: 18 Aug 2009 at 7:42pm
Originally posted by lockwelle

remove subreports, they affect performance by causing mulitple hits to the database.  Cut down on the number of records.  If you are bringing in a large number of detail records, but you are only going to display them in summary, summarize them on the DB via a stored proc and send the summary over.
 
No, you can't display the first page until all records are read, as you might have a dynamic grouping which would change the order--I use this feature all the time.
 
How many records are we talking?
 
Hi,lockwelle. Thanks for reply.
I didnt attach any subreports and i want to show the detail of records over 60,000.It takes few minutes to read all the data.


Print Page | Close Window