Crystal Reports XI are slow in my Web Application

Posted on 2006-05-19
Last Modified: 2008-02-07

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.


Question by:ajallath
    LVL 7

    Accepted Solution

    I'm using CR 9.0 and VS 2002 so I'm not sure about issues with CR XI.  However, I found that if I export my reports to PDF and display the pdf in my web app (instead of the CR Web Viewer), it overcomes paging issues (as well as client side printing, saving etc.).  I think the thing that I give up is the ability to drill-down, which isn't an issue for my reports.
    LVL 7

    Expert Comment

    Hi ajallath, check your printer settings on Reporting Server - we got improvements in PDF export by changing printer, even puting 'No printer' at one point...
     Do you have Reporting Server installed separately from Web server?

    Lady Linet

    Author Comment

    Lady, both are installed on the same server, only SQL server is intalled in a different server
    LVL 100

    Expert Comment

    In development are you hitting the same database?
      If not, is the data similar in quantity?  ie if you and a user enter the same request will your report be as many pages?  Will the query return a similar amount of data?


    Author Comment

    It could seem little crazy, but I was working in a migrate version from CR 8.5. I decided to create the same report using only CRXI development tool, and now is working so much faster. Conclusion, It is better create the reports directly in CRXI instead of migrate them from previous versions. Thaks all for your help.

    Author Comment

    mlmcc, please close this question for me. Thanks.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now