Solved

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

Posted on 2011-09-08
9
388 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

813 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

17 Experts available now in Live!

Get 1:1 Help Now