Crystal Reports Viewer slow to load report to screen

[former_member76071]

We have just upgraded our desktop application from Crystal Reports XI Release 2 to SAP Crystal Reports, version for Microsoft Visual Studio (Support Pack 11). Our developers' machines have Visual Studio 2010/2012/2013 installed and also the Install Executable for SAP Crystal Reports, version for Microsoft Visual Studio (Version 13.0.11.1467). On our developers machines, after compiling our code, they can run a report in our software to screen and the report loads within seconds.

However, after our desktop application is installed (install is created using InstallShield) onto a non-developer machine, when a report in our software is ran to screen, the reports loads slowly but finally appear within a minute or two (print to printer or to file is fast). Is there something we are missing in our installation?

FYI - Our installation has the required Microsoft Visual C++ 2005 SP1 Redistributables (two of them), all of the Visual C++ 8.0 (x86) merge modules (ten of them all with Version 8.0.50727.762), and the SAP Crystal Reports runtime engine for .NET Framework 4 merge module (Version 13.0).

[former_member188030 · Accepted solution]

Does this only happeen when the report loads the first time?

Hows the performance on the subsequent loads?

try implementing steps from below KBA.

http://search.sap.com/notes?id=0001439745&boj=/sap/bc/bsp/spn/scn_bosap/notes.do?access=69765F6D6F64...

- Bhushan

Senior Engineer

SAP Active Global Support

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Getting started and moving ahead with Crystal Reports .NET applications.

[former_member76071 · Accepted solution]

This happens the every time a report loads - initial and subsequent loads.

And, when user attempts to scroll from page to page, the user gets the "Please wait while the report is processing" and sees that it is 'buffering'. It appears to be attempting to load 2 pages and the form appears to freeze but the next page eventually comes up.

Greg

[former_member183750 · Accepted solution]

Hi Greg

It would be useful to put some tracing into the app, see where the slow down is occurring; page load, db conn, report processing, viewer.

Failing that, the following logs and tests may tell you something (this is all predicated on the assumption that you are running the app in exactly the same way on both systems. E.g.; on dev the app is not run from within the VS IDE.):

1) Test the app without loading a report - see how long it takes to just load an empty viewer.

2) Test the app loading a report that has no db connection - just a text box (Hello World).

3) Process Monitor may tell you where the hangs are occurring as it has time stamps at each file loaded, registry read, etc., etc.

4) CRPE logger may also give you an idea of where the time is being consumed. See KBA 1470978 - How to enable/disable crpe logging for the Crystal Reports .NET SDK re. how to.

5) CRLOGGER can be used if you suspect a database issue. See KBA 1653533 - How to debug database issues using crlogger logs on Windows and Linux

Now, this may all boil down to the database or some other environmental variable (e.g.; all works on one computer not another - not much except the environment changed(?)). Unfortunately  you don't mention the database used. Assuming this is MS SQL:

For OLE DB connection make sure to use:

MS SQL 2005 - OLE DB Provider

MS SQL 2008 - SQL Native 10

MS SQL 2012 - SQL Native 11

MS SQL 2013 - SQL Native 11

For ODBC connection make sure to use:

MS SQL 2005 - SQL Native

MS SQL 2008 - SQL Native 10

MS SQL 2012 - SQL Native 11

MS SQL 2013 - SQL Native 11

(936186)

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter