Multi-Page Report with sub Reports 1

[sterlecki]

I have a report that has 5-6 subreports. The report is based on a single record (WellID) and the various subreports are from different informational areas, Land, Drilling, Formations, coordinates etc. some subreports are one to one and others are one to many.

I have been asked by the users to create a multipage report (3 pages to be exact) and have certain information organized by page (ie page 1 Geology, page 2 Land info, page 3 Drilling/Engineering info).

Each page must contain info in the Page Header such as well name, location info etc.

Each page could have one or more subreports displaying the information for that item.

[highlight]Design question:

1. Should I create a separate report for each page desired and run the reports sequentially in code. Bad part here is instead of having each page numbered 1 of 3, 2 of 3, 3 of 3, they would most likely come out 1 of 1, 1 of 1, 1 of 1.

2. Would it be possible and perhaps better to use each of these separate reports and insert these as sub-reports into a "Master" report? Will I be able to force a page after each as required?
[/highlight]

Any suggestions or comments?

 

[dhookom]

I would use the subreports. You can insert a page break control where needed on the main report.

Duane
Hook'D on Access
MS Access MVP

 

[sterlecki]

Hi dhookom,

Thanks for the encouragement.

Solution:

I did create 3 separate reports each containing their related sub-reports and then inserted these 3 items as sub-reports into a "master" report. I'm still working on some pagination issues but I was surprised that it worked better and easier than I had anticipated.