rabroersma
asked on
Concatenating Crystal Reports dynamically at Runtime
Back-ground:
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.
Problem:
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?
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.
Problem:
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?
ASKER
Rats! :o)
Is it at all possible to remove any linking the parent and sub-reports and at run-time pass a record source to directly to the individual sub-reports and at the same time disable the sub-reports that I would not like displayed?
Is it at all possible to remove any linking the parent and sub-reports and at run-time pass a record source to directly to the individual sub-reports and at the same time disable the sub-reports that I would not like displayed?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Your idea to use conditional suppression really worked well. Turning off all of the sub-reports that do not apply according to the set of records that I passed to the parent greatly increased the performance of the report.
Thanks for the direction!
Thanks for the direction!
The only way to combine reports is to use subreports.
mlmcc