I have a subreport which is on the second drill down level of my report. I have noticed that each time I drill down to that level the sub report records are retrieved from the database, which in my particular case is a lengthy process (well, around 2 minutes or so).
Is there any way for Crystal to save all the data read by a subreport so that on subsequent drill downs it does not refresh the sub report?
I don't mind if it has to refresh when the report is opened, but it's important for usability that it speed up significantly in general usage.
Is this sub-report called multiple times with the exact same parameters? Can you move the sub-report to a section that only runs once, like the report footer?
You could disable the on demand feature of the sub-report and enable the Save Data with Report feature on the main report. It'd make the first refresh a lot longer but then they could pass it around with the saved data.