on 01-07-2013 12:27 PM
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???
OLEDB will be faster than ODBC.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
For those reports that run slowly, you may consider to redesign them so that the data link can be minimized.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.