Multiple reports in one

[pgh2377]

I currently have 5 reports that I would like roled into one. (For PDF purporse) Printing them to a printer s no problem, however is there any way (in any Access Version) that I can collapse all reports into 1. I.e. the first report would be pages 1-5, the second 6-10, etc...

 

[mckenneyj]

Create a 6th Report
Call each of the other 5 as a subreport of number 6
One stacked below the next etc...

Thanks,
John McKenney
Work Hard... Play Harder

 

[pgh2377]

header issues, each report has different headers

 

[hymn]

have a look at the link in
thread703-952862

Hope this helps
Hymn

 

[dhookom]

What specifically is wrong with the report headers. These should show just fine when used as subreports? If you actually mean "Page Headers" then you can get around this issue by creating a new primary grouping level on a constant expression such as =1. Display the group header and set the =1 Group Header "Repeat Section" property to Yes.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[pgh2377]

dhookom,

Please help, been trying that =1 group header all night and can't get it to work but I've heard about that.

 

[dhookom]

Please help, I can't see your screen to determine what is happening on your PC that isn't working.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[pgh2377]

dhookom,

Would you be able to assist me step by step?

 

[dhookom]

pgh2377,
How can I help when I don't know what you have tried, what you want/expect, what you are getting, and what is wrong with what you are getting?

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[pgh2377]

dhookom,

Thank you for your reply. O.k., to start what I have is about 7-8 reports that through a macro, print separately which is fine. However, through current requests I need to pdf the reports. To do so, I currently need to pdf print each one, then collaspe them into one pdf. I was thinking that if I had the 7-8 reports combined in one report (through subreports), I would only need to pdf one document. My problem is, that each report has their own page headers. When trying to include the reports as subreports, I loose that page header in which I have been researching the =1 option. However, I must be an idiot because I am missing something. How should I begin? Any help is greatly appreciated.

 

[dhookom]

Check out this screen shot

http://www.hookom.net/images/forpgh.jpg.

This is how each subreport could/should be set up. The =1 group header would replace the Page Header.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[pgh2377]

Do I place the subreport(s) in the detail section? If so, I'm still losing the page headers

 

[pgh2377]

Nevermind, I figured it out. Thank you for all of your help!