Append or Embed one Report into Another

[marthacasting]

I would like to simply append or embed one report to/into another. They don't need to be bound or have any connections.
I had thought maybe I could use the "Insert Below" function (in the Arrange view) but they are greyed out.
Any ideas?

Thank you!!

 

[CJ_London]

not quite sure what you are asking, but sounds like you need to be using a subreport

 

[marthacasting]

Thank you for your prompt response. Actually, I don't think I do want to use a subreport.

I would like the top half of the report page to have a brief, at-a-glance format for the employees in tabular view. (Name, Phone, Email, etc.)

Below that, I would like to have a "justified" report that has more information on each employee. (So that each employee has almost his own block of info).

I did see on an Access video where you can "drag & drop" one report into another, but you need to have the "Insert" capabilities in the Arrange section available (and mine are greyed out).

 

[CJ_London]

still not clear what you are referring to - the insert buttons will be greyed out if no layouts have been defined - and will only become enabled if a layout is selected. Has no effect on adding a subreport to a report.

Perhaps your top half should be a subreport instead

 

[HiTechCoach]

I agree with CJ the you probably can use a sub report control.


A sub report control is a container that will display another report on the main/parent report. The don't have to be linked. It is common that they are linked (master/child properties set) so the sub report is filtered to the data related to the parent report. But it is not required.

FWIW: I regular do a "dashboard" report. It is a report that has no record source. It only is a place to hold a bunch of sub reports so they print together.

 

[The_Doc_Man]

The problem is that a report is a singular type of object that exists ONLY while it is open. You could IN THEORY embed an object into a report, but finding the link source for a report is the trick since it has to be open to exist. Which means that opening the containing report would have to automatically open the contained report. I see more than a couple of pitfalls there, but there might be another approach. This will be a bit strange but it has a chance of doing what you want.

Create the two reports separately and export them to two Word .RTF files. Then using a Word Application Object, create a single (empty) file and import your individual files in it in the proper order. Save & Close the Word file that now contains the reports. Close the App object. Now do whatever you wanted to do with the file you just created.

 

[marthacasting]

Thank you all!

So this is what I tried and am hoping will work!
I created Report A and Report B
Then I went to Report Design to create a new report: in design view, I simply dragged Report A and Report B from the navigation pane into the new report. Voila (??!!) One report that holds the 2 individual reports I wanted to show!

Am I asking for trouble with that?!?!

THANK YOU!

 

[HiTechCoach]

I do that all the time.

 

[marthacasting]

Phew! Thank you!