Crystal Reports XI are slow in my Web Application
Posted on 2006-05-19
I have an Intel Xeon 3.4 Ghz Server with 2Gb Ram. Running Windows Server 2003 SP1, IIS 6.0 and BO Crystal Reports Server XI SP2. I am developing a web application that display reports based in user selections. All reports are built using stored prcedures in SQL Server 2000. The application is built usung MS VisualStudion 2003 .Net (VB). I am using ODBC to connect to the SQL database.
When I develop the report in the Crystal Reports design tool it works fast, in less than 3 seconds, but when I port the report to the web application it takes from 10 to 15 seconds to display for first time, the worst problem is when a try to move to the next page in takes another 10 to 15 seconds to show me the next page, even when I try to print it, takes additional 10 to 15 seconds.
My question is: How can I improve the speed to display reports? Is there any parameter that I have to change in the report or in the application?
Thanks for your help.