Skip to Content

ReportDocument.Load slow when database server not available

I'm using Crystal Reports developer version 13.0.16.1954 (service pack 16, latest version at this moment) for Visual Studio 2015.

ReportDocument.Load takes more than one minute when the database server the report is linked to is not available.

This is all code required to reproduce the issue:

Dim rd As New ReportDocument

rd.Load("c:\temp\test.rpt")

Obviously Crystal Reports tries to locate the database server. Is there any way to prevent CR from doing this?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 07, 2016 at 01:54 PM

    Try this:

    1. Edit the report.

    2. Go to the File menu and make sure that "Save Data with Report" is not turned on.

    2. Go to the File menu and select "Report Options".

    3. Make sure that "Verify on First Refresh" is NOT checked.

    Save the report and try running it through code again.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

    • George . Dell Stinnett-Christy

      You are right Dell, thanks for your help!

      I took the following steps to convert the Crystal Reports 8.5 report (connected to customers database server) to Crystal Reports 13:

      1. Create SQL Server alias to customers database server.
      2. Open report in Visual Studio.
      3. Save report, it will be converted to Crystal Reports 13.
      4. Verify database.
      5. Save report again.

      The report is still connected to the customers database server (which cannot be found in our network obviously), but now loads immediately (ReportDocument.Load), even if I rename or delete the SQL Server alias.