Using subreport at lookup

[rnixdorf]

Is there a way to have a subreport generate only once in a report and each subsequent use within that report just reuse the subreport data? I have a sales invoice file report that matches returns with sales. For every line in the report the subreport has to run through 120k records of invoice looking for matching returns. The field used to match the records is not a keyed or index field (and can not be). The database (MAS90) is accessed through ODBC and takes hours to run. If somehow the subreport could be run on the first record and then held static for all the other records it would speed up the process. I am using Crystal Reports version 8.5 connecting to a MAS90 database - all the processing is done on the workstation.

Robert

 

[synapsevampire]

If the main report is updated, then the subreport will be.

Given your scenario, you might consider creating an MS Access database and LINKING to the main table of the MAS 90 via ODBC, then use a static IMPORTED table for the subreport data, or you'll probably discover that you don't even need a subreport, rather create a subquery within MS Access as part of the data source. Less hit on the MAS 90 system, and better performance.

Anything that takes hours to get through is a prime candidate for other approaches.

-k

 

[BOjdh2n]

I would recomend that you use the Access Database as well. As stated above, you should be able to create a series of Queries that will give you the same data that the Sub Report generates. Then you can place the results in the Group Footer or Page Footer sections.Your only other choice would be to upgrade to Business Objects XI Crystal Reports Server and schedule the report to generate after hours.