We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Crystal Reports 8.5 VCL - Long Load Time

AdrianSRU
AdrianSRU asked
on
Medium Priority
976 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
Comment
Watch Question

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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
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
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.