Subreports using the same table

[tektripper]

I havew a report that uses multiple groups. With in each group I have a subreport. Each subreport uses the same report (with different subreport groups suppressed depending on which subreport it is). When the report runs it collects the records for the main report, then collects the records for the first subreport, then the next and so forth.... this takes forever. This is frustrating since all of the data for all of the subreports could be gathered in one pass of the data, but instead it keeps re reading the table for each subreport.

Is it possible to get CR6 to run a subreport once and then use all the records for all of the other subreports? rather than have it repeat the process for each instance of a subreport.

 

[kenhamady]

I don't believe you can.

I think in later versions, if the subreport is unlinked, it will reuse the subreport. But as soon as you try to link or vary the subreport, it is going to go after the data.

I assume you can't get the subreport records cleanly into the main reports results?

It might be a bit faster if your link only brings back the records needed for each group, but you have probably already tried that. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/