Merging 3 Reports

[mintz87]

i am trying to merge 3 reports together. i have tried the following:
- all 3 reports as sub reports in one master report. problem here is that i lose my headers in one of the reports. another problem is that one of the fields will not allow me to do a group expression =1 in a sub report to show headers in a sub report. i get the error: MULTI-level group by clause is not allowed in a subquery.

- taking the 1 report that i cannot do a group expression and make that into a main report then add the other 2 reports as subreports in the Header, or Details, or Page Footer and of course the headers from the main report shows up on all pages.

In Crystal or Cognos reporting they have a function to add page groups sections for your subreports so it treats each section as a new report/new page all in one. Does access have this functionality?

I have access 2007



Thanks
Mintz

[NTC]

I think your first method was on track;

use a nonbound report...just put some overall label into the report's header.
totally shrink/make not visible the detail....

and then put your 3 subforms into the footer.

I note you stated: " i lose my headers in one of the reports"...all the reports should behave the same. if you do lose the header of just one - then reinspect that one and see where the headers are in it as compared to the other two..probably they are in pageheader section and can be moved to report header section...

hope this helps.