[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2011-09-08
9
Medium Priority
?
397 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 77

Accepted Solution

by:
peter57r earned 668 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 1332 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 1332 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

656 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