Solved

MSAccess Report has orphan group headers

Posted on 2009-07-15
6
449 Views
Last Modified: 2012-05-07
I have an Access report that I need to page break after each section and I also want the group header to display on each page the section spans.  The problem is after each section, the group header is repeated at the top on the new section right above the new section name.
0
Comment
Question by:otamian
  • 3
  • 3
6 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 24863249
First lets clear up the terminology, as it is not clear what you are calling a "Group" and what you are calling a "section".

A report can display the "Group" name, not the Section name, so when you say:
<the group header is repeated at the top on the new section right above the new section name.>
I am a bit confused.

Also confusing is when you say:
<I need to page break after each section>
"Each Section"? Well a basic Grouped Report can have at leaset 7 sections.
(Report Header, Page Header, Group header, Detail, Group Footer, Page Footer and  Report Footer.)
Your statement seems to indicate that you want a page break after "each" of the seven sections.

Finally, it is not clear how many sections or grouping levels you have in your report.

In any event , you can set the "Repeat Section" property of the Section to Yes, to have it repeat on each page.

But the whole "Page break after each section" issue is still confusing.
Can you post a sample of this report with this issue clearly visible.
Then post a sample of what you need it to look like.

Here is a sample of a Report that repeats the Group Header on every page.

JeffCoachman
Access-EEQ-24572612-Repeat-Secti.mdb
0
 

Author Comment

by:otamian
ID: 24863412
Thanks Jeff... sorry to be so confusing.  As a confused person, I am likely to do that.  But I did figure it out how to get rid of my problem.  And  to clarify what I was trying to ask:

The previewed report has different sections, but in design view these are only one group header based on a sorted field.  I was adding a page break at the group footer level which I later found unnecessary because I instead set its property for Force New Page - After Section.  Access actually referred to the group as a section, which is propably why I started calling it that.  

Regardless, it now works.  It created orphan section names on the previewed report when I had the Force New Page on the header.  Setting it on the footer it worked perfectly.

Am I making any sense?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24864019
So, Problem solved?
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:otamian
ID: 25088262
Yes, thank you boaq2000

See you next time perhaps...
otamian
0
 

Author Closing Comment

by:otamian
ID: 31603803
Thanks for getting to me so quickly...
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 25090219
;-)
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
This collection of functions covers all the normal rounding methods of just about any numeric value.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question