MSAccess Report has orphan group headers

Posted on 2009-07-15
Medium Priority
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.
Question by:otamian
  • 3
  • 3
LVL 74

Accepted Solution

Jeffrey Coachman earned 2000 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.


Author Comment

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?
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24864019
So, Problem solved?
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.


Author Comment

ID: 25088262
Yes, thank you boaq2000

See you next time perhaps...

Author Closing Comment

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

Expert Comment

by:Jeffrey Coachman
ID: 25090219

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
This collection of functions covers all the normal rounding methods of just about any numeric value.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Suggested Courses

627 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