Skip to Content
N B

CRAXDRT.Application.OpenReport - VERY slow

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!

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 27, 2009 at 05:53 PM

    Check to see if you have the option "Re-import subreport when opening" check on.

    right click on the subreport select format subreport then go to the Subreport tab..

    If it is checked on uncheck the option.

    Add a comment
    10|10000 characters needed characters exceeded

    • Not all reports are having this issue. There may be more than these 2 reports, however, we are focusing on them as a starting point.

      This is a Windows application. We use an MSSQL database. Our main application (written in eDeveloper/Magic) executes our VB6 .exe (no forms involved...just running the executable which will use the Crystal RDC to run the report).

      We were opening the report using the following code:

      Set crReport = crApplication.OpenReport(App.Path & "\Report1.rpt")

      I changed it to Set crReport = crApplication.OpenReport(App.Path & "\Report1.rpt", 1) assuming here that the ",1" designates it as a TEMP copy. Compiled the vb6 .exe...same results.

      Yes, we opened each of our reports and saved them under Crystal 2008.

      Have you applied the latest CR XI R2 patches? Is this to update references in the vb6 app? If so, I don't believe so...how can I check?

      There were issues with Oracle Stored Procedures which the patches should resolve. If not what DB are you connecting to? We use MSSQL Server, not Oracle to connect to the database, but where the vb6 program is hanging (at OpenReport) it hasn't even gotten around to accessing the database, so I don't believe that is the issue.

  • author's profile photo Former Member
    Former Member
    Posted on Feb 09, 2009 at 07:04 PM

    Hello, Nancy;

    As mentioned, Cyrstal Reports 2008 no longer ships with RDC (CRAXDRT.DLL). You have now saved these reports to Crystal Reports 2008 (12.0) but what references are in your Visual Studios application to actually run them?

    One of the things that slows a report when loading is to look for the printer the report was created on when it is running through the application. Try changing the report to "No Printer" if it displays a printer in the designer.

    Elaine

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Nancy,

      No sorry but that would be a great set of API's but it may be a set built into crw32.exe and therefore no equivolent set of API's. I'll suggest this to the SDK team as an enhancement request.

      They could go to our download site and download a trial version. It would require they un-install CR and then re-install your app, just incase the Cr un-install removes updated files.

      You may also want to upgrade to CR XI R2, it's free and supported platform and your XI keycode will work with it.

      Thanks again

      Don

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.