Page Headers not displayed in subreport

[StrikeEagleII]

I have four reports that are similar, but unrelated. My form currently has four command buttons--one to display each report which a user can then print. I'd like to make a single button that can be used to print all four reports. It appears that the best way to do this is to create an unbound "master" report and then insert each of the four reports as subreports. When I do this, none of the page headers/footers for any of the subreports are displayed. The report headers are, but not the page headers/footers. Any suggestions? I have each subreport in the detail section of the main report and have the main report's page and report headers/footers hidden.
Thanks,
Jason

 

[genomon]

I overcame this by adding a dummy field to the recordsource and populating it with the number 1 for all records. I added a GROUP header (add sorting/grouping on the dummy field in the subreport) and moved the objects from the page header to the group header. Dunno why, but it worked.
Good luck!



I wondered why the baseball was getting bigger.
Then it hit me.

 

[dhookom]

genomon suggested the usual solution however you don't need to add a column to your report's record source. Just set the primary sorting and grouping level to a constant like:
=1

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]

 

[genomon]

Thanks again Duane!
Sometimes the obvious is invisible....
Hope Strike Eagle gets the reports to work.

I wondered why the baseball was getting bigger.
Then it hit me.

 

[StrikeEagleII]

Thanks for the posts. Been busy, but finally got it implemented. It works great for the page headers (I even figured out I needed to change "repeat section" to "yes" so the the group header would appear on each page.) Is there by chance a work around to get the page footers to appear?
Thanks,
Jason

 

[dhookom]

I have never heard of a method to implement page footers or the equivalent in a subreport.

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]

 

[StrikeEagleII]

Thanks Duane!