Two reports into one (1 Viewer)

[Oldsoftboss]

I suppose the title says it all.

I have a Db that I use for commissioning equipment. On one form I have several tabs, with Fan Data on one tab (and table) Pump Data (and table) on another tab etc

I can print a report based on each tab, but would like a "Project" report, where the reports from each tab can be produced as one report, not 4 or 5 separate reports.
Is this possible?

Dave

 

[macca the hacke]

Would a report based on a union query that brings all tables together work?

 

[Oldsoftboss]

Unfortunately each report has a different header. One has AIR TEST REPORT, another has PUMP TEST REPORT.
I suppose I could create a table to hold these titles, but each report has a different format.
After a bit of searching. One suggestion was to create a blank report and set each of my reports as sub reports.

Dave

 

[boblarson]

I would go the sub report route as it is extremely easy to implement.

 

[JoeCruse]

I would second the blank report/drop needed reports as subreports option.

I had to do something similar for showing a variety of test data reports onto one report, as a neat summary. This worked pretty good.

 

[Oldsoftboss]

Tried it, but the sub-reports dont show the report header where the company logo resides

 

[apr pillai]

Probably the Company Logo is on the Page Header Section of the Sub-Report. Shift it to the Report Header Section.

 

[Oldsoftboss]

Will check and give it a go.

Dave