Solved

MSAccess Report has orphan group headers

Posted on 2009-07-15
6
453 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

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

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.

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

Suggested Solutions

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
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 use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

856 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