Set CommandTimeout unlimited

The CommandTimeout property defines how many seconds to wait before cancelling an Execute method call and generating an error. The default is thirty seconds. If you set CommandTimeout equal to zero seconds, the program will wait indefinitely or until the Execute is completed.

Crystal Reports 9 is slow when moved to production server

Reason : It seems like it is pointing to development database server eventhough proper database is set at runtime. When i did experiments it showed good performance when i changed the default database of the crystal report to production server.

Some of the .net reference (3.0 and 3.5) is greyed out in visual studio 2008 (ASP.NET)

Reason: The asp.net web application target is set to previous version of .net framework. Change the target framework taking the properties of project and setting it to 3.5 or 3.0.