Solved

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

Posted on 2011-09-08
9
387 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
  • 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
 
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

930 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now