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

How to improve performance in Crystal Reports


Hi,

I am working on a report which performs pretty poorly. It's a report created with Crystal Reports for Visual Studio 2008. I need to generate a report for every person in my database. The report works just fine, the only problem is the time it takes to generate. The report is pretty complex, it consists of one mainreport and there are 6 subreports on this report. So I think my best chance on improving the performance is to get rid of these (if possible) subreports.

My question is how to handle this? I need to format my report in the same way, but (if possible) without the use of the subreports. Do you have any ideas how to achieve this? So how can I reduce the number of subreports and keep the same formatting in my report?

Hope you can help me out on this one.

Thankx,

Martijn

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Nov 27, 2014 at 04:38 PM

    Hi Martijn

    It's difficult to say if removing subreport will help, or how to structure the report without subreports as I don't know what the report is supposed to do. Nevertheless, here are a few resources for your consideration:

    1) As you are using Crystal Reports Basic for Visual Studio 2008 (v. 10.5.x), make sure you are updated with Service Pack 1:

    Crystal Reports for VS 2005 and VS 2008 Updates & Runtime Downloads

    2) You don't mention the database you are using or how you are connecting to it. CR 10.5 being from 2008, will not support MS SQL 2010, or 2012. Similarly, all other new databases will more than likely also not be supported. E.g.; Oracle 11g, etc., etc.

    3) Have a look at the doc Crystal Reports for Visual Studio .NET Scaling Crystal Reports for Visual Studio .NET

    Also see:

    http://jamieodonoghue.net/2012/09/crystal-reports-performance-overview/

    KBA: 1636361 - How do I design my Crystal Reports to improve performance?

    Finally, seeing how the report behaves in a later versio of CR may be worth a try. You can download CR 2008 (this is the last version of CR to support VS 2008) from here:

    SAP - Crystal Reports 30-Day Evaluation

    And a tip, in case you are using MS SQL:

    For OLE DB use:

    MS SQL 2005 - OLE DB Provider

    MS SQL 2008 - SQL Native 10

    MS SQL 2012 - SQL Native 11

    MS SQL 2013 - SQL Native 11

    For ODBC use:

    MS SQL 2005 - SQL Native

    MS SQL 2008 - SQL Native 10

    MS SQL 2012 - SQL Native 11

    MS SQL 2013 - SQL Native 11

    - Ludek

    Senior Support Engineer AGS Product Support, Global Support Center Canada

    Follow us on Twitter

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I finished remodelling my dataset and I have redesigned my report and I have managed to achieve a major improvement in performance. I think reducing the number of subreports and limiting the data in the datasets for the subreports is the main improvement.

      One thing I still need to figure out is how to show progress to the end user. In my C# code I have a line of code; reportviewer.refreshReport()

      I need to call this function in order for the report to refresh and show. But depending on the size of the report this can take several minutes. At the moment I am showing a animated GIF to 'fake' progress. What I would like is to show the actual progress, how many pages of total pages are already loaded?

      Is there a way to show actual progress? Like for instance; "Loading page 24 / 45".

      Any suggestions are greatly appreciated!

      Thanks!

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.