Concatenating Crystal Reports dynamically at Runtime
Posted on 2007-11-19
I created a Crystal reports viewer, embedding in an Access Form using:
CRAXDRT.application to load and open the report.
CRAXDRT.report + ADODB to change reports dataset anyway I need to.
CRystalActiveXViewer to display the report.
I have a number of reports (the user can specify any combination of reports to run at any given time), that I would like to display at a single time in the CrystalActiveXViewer for viewing. Currently, the CrystalActiveXviewer can only display one report at a time. So, I am looking for advice for the best way to merge separately rendered reports in to a single document.
I've tried creating one parent report with all of my reports linked together (like a giant left join) to the parent's report, but the Report runtime seem to increase exponentially (as each sub-report generates is one sub-query to the db-server for each parent record processed) to the point where The CrystalActiveXControl appears to be un-responsive for a small period of time.
What options do I have to combine reports into one document at runtime?