Problem with printing time

[Former Member]

Crystal Reports Runtime: 13.0.4 (32 bit)

Database: IBM Informix 12.10FC2W

Connect: ODBC Informix CSDK 3.70TC4

OS: Windows Server 2008 R2 Standard (64 bit)

The reprots where converted from an the Crystal Reports 6 to Crystal Reports 11.

With the old version the preview needs about 2 seconds.

The new version needs 6 seconds.

I checked all indexes for the used tables.

The sql statement ok.

The complete debug-output is in the attached file DebugOutput.txt.

Here the parts of the debug-output which took the most time:

DebugOutput.txt.zip

[former_member292966 · Accepted solution]

Hi,

I'm not sure if this can be improved.  Is this report being run from Crystal or from an application?  The output shows the lag in logging onto the Informix database.  Can you see if the same lag happens on a new report created in Crystal 11?

Converting a report has the high potential to have some hidden issues.

Thanks,

Brian

[Former Member · Accepted solution]

The report runs from an C# application?

[former_member183750]

As you are using Crystal Reports Runtime: 13.0.4  I moved your post to the SAP Crystal Reports, version for Visual Studio SCN Space.

First thing you want to do is update to Service Pack 9 - you are on SP 4.

Second. There is a difference between a report loading first time and being refreshed or loading a subsequent report. E.g.; on 1st load, the report engine is institutionalize and a bunch of files and assemblies l9oaded, etc.,etc. On second load of a report, or refresh, the performance should be much better. So, compare initial report load to refresh or subsequent loads.

Third. When you say; "Crystal Reports 6 to Crystal Reports 11.", id that Crystal Reports version 11.0, 11.5, or Crystal reports 2011? How is the performance in what ever "11" means? Be careful to compare load as well as db logon and final screen display. E.g.; opening the report in the designer and then logging on and timing the logon to display is not a valid comparison...

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[Former Member]

Hello Ludek,

I will install the sp9.

I know that the 1. load takes longer than the following.

I'd compared with the second print preview.

The conversion was made by Crystal Reports 2011.