Charts in Crystal Reports stop appearing after memory usage increases
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.