A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Page headers and multipage sub reports



 
 
Thread Tools Display Modes
  #1  
Old October 31st, 2007, 03:31 PM posted to microsoft.public.access.reports
Dan Neely[_2_]
external usenet poster
 
Posts: 6
Default Page headers and multipage sub reports

My report consists of 2 sub reports one below the second. The first
is a short (1/4 page) summary, the latter contains a more detailed
breakdown of the data and can span several pages. The problem I have
is that when it flows onto a second page it will not display headers.
For the first page I can work around the subreport not showing a
header by copying the labels into the report header section, but that
doesn't help for when it spans onto the second page. I can't use the
parent reports headers either, because they'd appear at the top of the
first page, above the summary subreport. Is there a way around this,
or will I have to split this into two separately printed reports?

  #2  
Old October 31st, 2007, 04:11 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Page headers and multipage sub reports

Create a new primary/top level sorting and grouping level (in your subreport)
on a constant expression like:
=1
Display the group header for this level. Set the "Repeat Section" property
of the =1 Group Header to "Yes". Use this section in place of a page header
--
Duane Hookom
Microsoft Access MVP


"Dan Neely" wrote:

My report consists of 2 sub reports one below the second. The first
is a short (1/4 page) summary, the latter contains a more detailed
breakdown of the data and can span several pages. The problem I have
is that when it flows onto a second page it will not display headers.
For the first page I can work around the subreport not showing a
header by copying the labels into the report header section, but that
doesn't help for when it spans onto the second page. I can't use the
parent reports headers either, because they'd appear at the top of the
first page, above the summary subreport. Is there a way around this,
or will I have to split this into two separately printed reports?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.