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?
LVL 1
rabroersmaAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Yes you could do that.

You can use conditional suppression to hide the subreports you dont want. You would have to pass a list or a parameter to the main report.

mlmcc
0
 
mlmccCommented:
At run time, I don't think you really have any options.

The only way to combine reports is to use subreports.

mlmcc
0
 
rabroersmaAuthor Commented:
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?
0
 
rabroersmaAuthor Commented:
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!
0
All Courses

From novice to tech pro — start learning today.