Print Page | Close Window

Report load is slow after changing database server Printed From: Crystal Reports Book Category: Crystal Reports for Visual Studio 2005 and Newer Forum Name: Data Connectivity Forum Discription: How to connect to data sources and export reports URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3695 Printed Date: 19 May 2024 at 12:58am Topic: Report load is slow after changing database server Posted By: todd Subject: Report load is slow after changing database server Date Posted: 14 Jul 2008 at 7:55am Here is the problem: Crystal Reports saves the design time database connection info in the rpt.  When our application tries to run a report against a production database, the rpt takes a long time (60 sec.) to load.  After it has loaded we can change the database logon (in our code) and the report runs successfully. It seems like Crystal is trying to connect to the development DB server (but it cannot see it from the production environment).  If we edit the rpt and save the production database connection info in it, the report loads in less than a second.   We are an ISV and our application is used at over 2000 sights so it is not practical to edit each rpt (we have over 850) at each location. Is there some way to tell Crystal not to try connecting to the DB during the report.load?

Print Page | Close Window