Solved

MSAccess Report has orphan group headers

Posted on 2009-07-15
6
459 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 

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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
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 …

696 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