Solved

Crystal Reports 8.5 VCL - Long Load Time

Posted on 2006-10-26
3
935 Views
Last Modified: 2010-08-05
I have an application in Borland C++ Builder 5 and I use the Crystal Reports VCL component to open reports.  I am having a problem with long load times.  Here is my code:

TCrpe *reportCrpe = new TCrpe( Application );
reportCrpe->ReportName = reportFilename;
reportCrpe->Connect->Retrieve( );
reportCrpe->ParamFields->Retrieve( );
reportCrpe->SectionHeight->Retrieve( );
//Here I set various report and parameter properties.
reportCrpe->Execute( );

My problem is with the first Retrieve.  It usually takes 10-20 seconds to complete (some of my customers report load times as long as 1 minute).  The long load time seems to be caused by the presence of subreports in the report.  I have a very simple 29KB report with one extremely simple subreport.  It takes at least 10 seconds to load.  When I remove the subreport it takes less than a second to load.  I also have a very complex 1.1MB report with many complex subreports and it takes just as long as the 29KB report with the subreport so it doesn't seem to depend on the size of the report, just the presence of subreports.

I would like to know whether this is just the normal operation of the component or if there is some sort of solution to this problem.  Unfortunately, I am not able to upgrade to the latest versions of the VCL component because they require at least C++ Builder 6 and I cannot upgrade from C++ Builder 5.

Thank you in advance for your reponses.


--Adrian
0
Comment
Question by:AdrianSRU
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 12

Accepted Solution

by:
AdrianSRU earned 0 total points
ID: 17811448
I have figured out why the report is taking so long to load.  My subreports are set to 'Re-import when opening'.  Apparently when that flag is set in the report the VCL also attempts to re-import it.  When I unchecked that option the report loaded very fast.  What I would like to know now is if there is a way to specify in code that the subreports should not be re-imported.


--Adrian
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 17811882
That is very true.  Since you are opening the report the subreports will get reimported.  Useful if the subreports change but otherwise not really.

mlmcc
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Crystal Reports Format Field with Dashes 6 69
Crystal Reports Subreport details 16 94
New and Previous Value in Crystal Report 8 79
Crystal Reports last day of month 2 76
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question