How do I improve Crystal Reports 2008 performance?

Posted on 2008-11-19
Last Modified: 2013-12-17
Any inputs on improving Crystal Reports 2008 performance?

The rpt files used in both the application (VB and c#) are same. Only difference is crystal version is different. (for VB its crystal 2006 and C# its 2008)
Question by:SameerJagdale
    LVL 100

    Expert Comment

    There is no CR2006.  I assume you really have CR XI.

    You are most  likely using much different calling methods and display methods.

    The VB6 is probably using the RDC which no longer exists in CR2008.

    The differences may be in the Crystal viewer or your code.

    Are they running on the same machine?

    Same OS?

    Obviously the C# is running in the .Net framework while the VB is running as a COM application.  That could be the difference.

    LVL 13

    Author Comment



    rpt files are of CR 6.

    Following is the architecture for both the apps
    -  You fetch data from mainframe
    -  parse and store the data in local mdb
    -  bind the report to mdb

    The logic of parsing and storing the data into local mdb differs in both the apps. Resultant mdb is same in both the apps. Also query for fetching the data from the mainframe is same. Also there is a difference in CR versions as stated earlier.

    - VB6 uses RDC which no longer exists in CR2008 !!
    Sameer: is it valid in the above architecture?

    - C# is running in the .Net framework while the VB is running as a COM application.  
    Sameer: Yes (for both the points), but I need some artifacts to support that CR 2008 takes more time than CR6 to display the report if the architecture and other parameters like hardware etc. remain same.
    Any help would be appreciated!
    LVL 100

    Expert Comment

    Did you import the CR6 files into CR2008 and then save as CR2008 files or are you using the same report files for both applications?

    Since it is CR6 you are probably using the OCX rather than the RDC.

    LVL 13

    Author Comment

    They are the same rpt files directly reused in 2008.
    LVL 100

    Accepted Solution

    The problem is when you open it in CR2008, it takes time for CR2008 to convert it from the CR6 format to CR2008 format.

    Have you tried opening the report in CR2008 then saving it.
    Make a copy of the report.  Once changed it cannot go back to CR6 format.

    Use that one in the CR2008 application. CR6 cannot open it.


    LVL 13

    Author Closing Comment

    I presume there could be multiple factors affecting the performance. mlmcc did help me to understand some.. thanks for that.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    It’s quite interesting for me as I worked with Excel using for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
    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.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    729 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

    15 Experts available now in Live!

    Get 1:1 Help Now