Calling a complete report in another report

rbuser

Hello,

I have a report which is pretty complexe: a combination of section style
sub-reports. Most of the sub-reports are placed in the Summary band of the
previous "section" report. This report is called in one application. Now, I
have a second application, with some data "linked" to the data in the first
application. This second application also has a report of its own, but due
to the fact that some data can be related, I would need to display the
report of the first application in the second report of the second
application.

What I was thinking of doing is at the end of the second report, in its
summary band, add a "section" sub-report, and at run-time, assign the report
of the first application(probably by sharing the necessary source files) to
that sub-report, so it would be appended to the second report. Is this in
anyway possible? I wouldn't want to recreate the whole report in the second
one.

Thanks for any help any of you can provide.
Joe.

nicocizik

Hi Joe,

Which edition of ReportBuilder are you using (ie. Standard, Pro,
Enterprise)? The easiest way to accomplish this would be to save the first
report to template with all data access saved in DADE and all code saved in
RAP. Then you could simply dynamically load the report template you saved
into a subreport in your second application. If you do not use DADE or RAP,
you will need to copy the data access you have set up in your first
application to your second so the new report will have data. If you can do
this, you can still save the report down as a template and load it
dynamically in the second app.

One other way you might consider is to generate both reports to Archive file
(.raf) and then merge the two using the Archive Merge Utility. Using
archives will not give you the most up-to-date data as they do not access a
database but rather display a snapshot of a report generated at an earlier
time. If you would like to try this method, you can get the Archive Merge
Utility by emailing support@digital-metaphors.com and I'll send it right
out.

--