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  

Group Header doubling on first page



 
 
Thread Tools Display Modes
  #1  
Old March 31st, 2010, 06:59 AM posted to microsoft.public.access.reports
lcsmoothey
external usenet poster
 
Posts: 1
Default Group Header doubling on first page

I am building a report with 3 layers of nesting and want the header of my
subreports to show at the top of each page they go over. I have tried using
the recommended "=1" Group Header set to Repeat solution but keep getting the
Group Header appearing twice on my first page and then once on the subsequent
pages.
I've spent several hours searching various forums for anyone else who is
having this issue and no one seems to be, so I can only conclude it is
something I am doing wrong.

I have tried setting up a brand new database with absolutely no content,
doing a new report, setting up the repeating group header as =1 and just
putting a textbox into it that says ="testing" - no other content to the
report at all. On going to print preview it is still showing this header
twice even though there is only the one page. All other properties of the
group header are as default (so no Force New Page/Column etc) - the only
thing I change is set the Repeat Section to Yes.

I have tried this on several pc's at work in both Access 2003 and 2007, and
also at home in Access 2007, and it makes no difference.

Has anyone got any suggestions?

  #2  
Old April 1st, 2010, 05:29 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Group Header doubling on first page

lcsmoothey wrote:

I am building a report with 3 layers of nesting and want the header of my
subreports to show at the top of each page they go over. I have tried using
the recommended "=1" Group Header set to Repeat solution but keep getting the
Group Header appearing twice on my first page and then once on the subsequent
pages.
I've spent several hours searching various forums for anyone else who is
having this issue and no one seems to be, so I can only conclude it is
something I am doing wrong.

I have tried setting up a brand new database with absolutely no content,
doing a new report, setting up the repeating group header as =1 and just
putting a textbox into it that says ="testing" - no other content to the
report at all. On going to print preview it is still showing this header
twice even though there is only the one page. All other properties of the
group header are as default (so no Force New Page/Column etc) - the only
thing I change is set the Repeat Section to Yes.

I have tried this on several pc's at work in both Access 2003 and 2007, and
also at home in Access 2007, and it makes no difference.


I have never heard of such behavior and I suspect that the
reason no one had replied is because they haven't either.

Maybe(?) you have something else going on that's triggereing
the second copy of the group header. Or maybe you just have
the same stuff in another header (Report Header?).

--
Marsh
MVP [MS Access]
 




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 10:18 AM.


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