Report takes 2 hours??

[bv0719]

I created a rather involved report that utilizes 4 subreports. 2 of the reports use an SQL query and the other 2 use the select expert. The report takes about 2 hours to complete. This seems excessively long. What are some troubleshooting steps that can be taken to possibly speed up the report time?

If further info is needed please let me know.

Thanks,
Bill V

 

[dgillz]

Table structures, linking, specifics on why you are using subreports (which should be avoided if at all possible), subreport linking and where the subreports are placed in the main report, type of connectivity used, sample raw data and desired results.

That should be a start.

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

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[bv0719]

Thanks for the reponse. I'm trimming the audit table that two of the subreports query from to a weeks worth of data instead of a month. The audit table grows very large in a short period of time and this excess data may be slowing the report generation. I'll see if this helps in speeding up the report.

The use of subreports was necessary due to the reports design requirement.

Thanks,
BV

 

[lbass]

thread149-1276307 might be helpful.

-LB