Skip to Content
author's profile photo Former Member
Former Member

Crystal report 2008 slow

Hello,

We just immigrated from visual studio 2003 (crystal report 10) to visual studio 2008 (crystal report 2008). In the development computer viewing/printing reports is fast even though it is not as fast as it used to be in crystal report 10. But in production computers viewing and printing is very slow. I think it is slow because crystal report looks the production database information by default first. Does anybody know why it is slow? Any work around? Any help will be appriciated.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Sep 22, 2008 at 11:04 PM

    What makes you think it is the database that is causing the issue? If you truly want to rule out the database you should make a copy of the report and open it in the Crystal Reports designer. Use Set Datasource Location under the Database menu to set the report source to the production server. Use this report in your application instead of the one causing you issues. If this report runs quickly then you may be onto something.

    The other thing that may cause problems are your printer settings. Try opening the report in the Crystal Reports designer and

    - Go to File > Page Setup

    - Make sure No Printer (optimize for screen display) is selected

    - Click Ok

    - Save the report

    - Retry the report in your application

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Ludek Uher

      I think I got what makes the reports slow. Most of our reports have SQL Expression Fields and the Crystal report Engine tries to connect to the development database in order to resolve SQL Expression fields. I removed (DELETED) the SQL Expression fields from the reports and it is working good now.

      I would like to thank everybody who have tried to help me solve the problem

      regards

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2008 at 06:34 PM

    Hi Shweta,

    We use windows operating systems, mostly XP and Vista.

    We don't use merge modules.

    The database is SQLserver 2005 express

    while designing the reports, we used OLE DB ADO connection for SQL server 2005

    Here is the code we used to set database after loading the report

    reportDocument1.Load(RptPath);

    crDatabase = reportDocument1.Database;

    crTables = crDatabase.Tables;

    crConnectionInfo.ServerName = @"dName";

    crConnectionInfo.UserID = "userId";

    crConnectionInfo.Password = "lpassword";

    thank you

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2008 at 06:22 PM

    Hi,

    Which operating system are you using?

    Are you using merge modules?

    Database you are using?

    Connectivity method for the database?

    Regards,

    Shweta

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.