SubReport Performance (Speed)

[sck62768]

I am working with a linked subreport. The main report takes approximately 3 minutes to run alone. The subreport takes approximately 5 minutes to run alone. Yet, when I link the two (using indexed fields in the tables); the result is that the report comes back initially in about 20 minutes; but then I need to "page through" by hitting the last page button; which adds 4 hours to the report.

There isn't any extravagant formatting; etc which would slow down the report. I've had our DB manager look at what it's doing on the (Oracle) server; and he said that all he can tell is that it's running very short processes for the four hours.

Anyone heard of this; or can offer help?

 

[synapsevampire]

Because the subreport is joined by some field, it takes the number of main report joined field rows times the subreport execution speed, plus some overhead.

Avoid Subreports at all costs.

Try creating a View or SP to handle this. Or you might use straight query, but this is Crystal and database version dependent.

-k

 

[dgillz]

I agree with SV - avoid subreports.

Why are you using a subreport? Most likely we can do this in crystal without a subreport, or as SV suggested, via a view.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com