Solved

Access 2010 - print the group header at the start of the group only

Posted on 2011-09-08
9
390 Views
Last Modified: 2012-05-12
I have an access 2010 report using a group header.  I want the group header to print at the start of the group only, and not on every page of the group, but I can't figure out how to do this?  Many thanks in advance!
0
Comment
Question by:ssailer
[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
  • 4
  • 3
  • 2
9 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 36503758
In design view double click the group header bar and in the properties set the Repeat Section property to No.
0
 

Author Comment

by:ssailer
ID: 36503823
That "kind of" worked, but now the group header is printing on its own page and not "staying" with the start of the detail content.  
0
 
LVL 77

Expert Comment

by:peter57r
ID: 36503857
Then you have set a Force New Page setting somewhere- probably in the same group header.
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.

 
LVL 77

Accepted Solution

by:
peter57r earned 167 total points
ID: 36503874
Or you could have a  Keep Together setting that's being applied inappropriately.
Look at your grouping settings in report design view.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36504044
In addition, ...make sure that the control that displays the group name is actually in the "Group Header".

Depending on how the report was designed, this may have been placed in the page header...
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 333 total points
ID: 36504146
For example if the "Layout" selected in the Report wizard was "Block" then the group Name will be in the Detail section, and it is set to display once per page and not repeat for each record.

The other Layouts (Access 2007) "Stepped" and "Outline", have the group name in the Group Header, this seems to be what you need...

Sample attached that you can examine...


Keep us posted
Database38.mdb
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 333 total points
ID: 36504152
sample, second try...
;-)
Database38.mdb
0
 

Author Comment

by:ssailer
ID: 36505090
I think I found the problem.  In the detail area, Keep Together was set to Yes.  I will split points awarded amongst the group.  Sorry for me being a bobble-head :)  
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36506297
no problem, glad you got it sorted...
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

735 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