Print Page | Close Window

Initial Report Slow with .NET

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1422
Printed Date: 28 Apr 2024 at 7:54am


Topic: Initial Report Slow with .NET
Posted By: fidocrystal
Subject: Initial Report Slow with .NET
Date Posted: 01 Oct 2007 at 1:41pm
We are using VSNET2003, windows forms with Crystal 11 and deploying the VB.NET application on the desktops. The application take 7 or 8 minutes to Load the initial report. The initial call to CrystalReports.Engine.ReporDocument.Load("c:\program files\reports\abc.rtp") is taking 7 or 8 minutes. 
 
After the initial call the Load method takes only 10-15 secs.
 
Why it is taking 7 or 8 minutes for the first call? Can we reduce it to 1 or 2 minutes?
 
If we use a .rpt file that does not have database connection the initial call to load report is quick, but the first call to load report with database connection is taking lot of time.
 
 


Replies:
Posted By: BrianBischof
Date Posted: 01 Oct 2007 at 1:53pm
Hmmm... haven't seen that before. The typical complaint is that reports take too long when they are using DataSets (this has been fixed in VS 2005). Is the report huge? Does it have subreports that need to link as well? Are there a lot of tables that it links to? Can you speed it up by using a stored procedure instead of direct table links?

Just some ideas to check out...


-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>


Print Page | Close Window