One of our customers is experiencing this same issue as mentioned in the link below:
[CRAXDRT.Application.OpenReport - VERY slow|http://www.codeguru.com/forum/archive/index.php/t-338155.html]
We are using the Crystal XI RDC components to execute the report, so I would assume that we would have the Crystal 9 hotfix for this. However, the problem still exists. And, this is not happening to all of the reports, just some.
An example. I compared two of our simplest reports. Each executes one SQL stored procedure. The stored procedure just selects data from one table, it does nothing more. However, the problem isn't with SQL. The 'slowness' occurs before the RDC even accesses the database. The problem definitely occurs on the .OpenReport() method.
These two reports each have two subreports. Neither subreport accesses a database. However, both reports' link to the subreports from the main report. Result: one report takes about 40 seconds to run, the other takes 10 seconds.
I tried a few things with the 'slow' report:
1. I verified database - same issue
2. I removed the subreport links, saved the report, then added the subreport links back in, saved the report. Same issue.
3. I re-created the report from a template we use for our reports that has the two subreports in it.
Ran the report - now it is fast.
Why? I need to know why this fixes the problem. And, what is a faster way to fix this. We have 527 reports!