Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Charts in Crystal Reports stop appearing after memory usage increases

Hi,

We have a crystal report developed in Visual Studio 2010 Crystal version 13.0.8 (although customer is running 13.0.1 runtime). It has approximately 200 fields/labels, 5 levels of groupings, 5 charts for each grouping, 5 sub reports each with the same number of field/labels/groupings/charts as mentioned above.

There is certainly a lot of content, but the reason we want to do this is that sometimes a customer may want to vary what they see. For example, they may want to see a pie chart on the report, and other times they may want to see a horizontal bar chart. So we build in a lot of features and at run time let the users choose what they want to see and suppress the rest (including fields/labels, certain sub reports etc).

Recently we modified the fields to support html content, and we also added about 9 charts (including a cross tab between grouping fields) and we've started seeing the memory usage for the worker process in IIS start climbing rather quickly.

At a certain point, the charts on the report stop appearing (ie they are blank). If you continue to run the report, eventually you can get a "load report failed" or an "out of memory exception". In any of these cases, if you perform a recycle in IIS on the Application Pool that holds on your website, the worker process disappears, memory is released, and a new worker process starts and the charts start appearing again.

I have a few questions:

1. Is this by design? (ie do Crystal Report charts only produce if there is enough memory for them to do so?)

2. Is this a bug and planned to be fixed?

3. Is suppressing a section only changing the visibility of the section? For example, if there is a cross tab chart in a section, even though the section is suppressed, will the crystal report still be doing the work to produce the cross tab?

4. Is there anything else I could try to minimize the memory consumption for large report files (eg rpt file is 2MB in size)?

Thanks for your assistance.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question