Improving performance with a Crystal Report containing a subreport?

Question

Does anybody know how to improve the performance of a Crystal Report that has a subreport? The subreport uses ADO.NET objects...and takes FOREVER to generate.

Answer 1

Is the subreport being called for every record of your report, ie does it live in the details section? If so, there's not much you can do other than reduce what the report displays or calculates. Subreports in details sections are a blight on performance. However, if it's elsewhere then optimizations would necessarily depend on the design of the subreport itself. For example, running totals or the use of distinct counts can hit performance depending on design or report size.