cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal report open slowly

Former Member
0 Kudos

Hi ,

Friends we have use more crystal layout. all layout working fine but some layout take so much time to open how do will i solve this issue. it is happen both server and client system also . in the client system i delete the all temp file also.  how do i solve if you have solution tell briefly???

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

OLEDB will be faster than ODBC.

KennedyT21
Active Contributor
0 Kudos

Hi Ramesh Kannan....

Make sure you are using the updated database client also.

Manually set location to the Data source again, if it's Oracle set location for each table, if used, and do the same for all of the subreports also. A delay could me CR is trying to find the old one also.

What DB are you using and which connector, OLE DB, ODBC, Native, etc.?

And check on No printer in the Page Set up to see if that helps, could be CR is trying to find the printer the reports were designed against.

As for updating your View, it's always recommended to do as much data processing Server Side, after all DB Server are designed to do this, Basically CR is designed to simply display the data...

The Processing you can do Server Side the less your local PC and CR have to do.

Go into Options and Database and check off the Auto Link also, this can cause delays when opening the reports also, CR will attempt to link all tables and fields. Although I don't believe this is the case for a view.

Regards

Kennedy

Former Member
0 Kudos

Sql native client 10.0 (ODBC)

Former Member
0 Kudos

Hi,

For those reports that run slowly, you may consider to redesign them so that the data link can be minimized.

Thanks,

Gordon

Former Member
0 Kudos

Some reports only open slowly

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please check below thread:

http://scn.sap.com/thread/3229364

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Dear Ramesh,

Please check the db tables and their links, if lots of tables are used or so much of data has to be derived from sql, you could face this issue.

Regards,

Anandh.