Learn how to a build a cloud-first strategyRegister Now


Suppress group header when forcing extra page in report

Posted on 2011-10-28
Medium Priority
Last Modified: 2013-11-28
Working on a long report which prints duplex to save paper.  However the client wants each group to begin on an odd page, so we can insert dividers into the report.  

I've added code which prints a pagebreak in the group footer if the footer is on an odd numbered page.  That part works great.  But the even numbered page that prints when this occurs contains the group header, which is set to repeat.

How do I suppress the group header from printing when this extra pagebreak is being printed?
I've tried setting the group header visible property to False, and changing the RepeatSection property but neither of these is working, at least not in print preview mode.
Question by:Dale Fye
LVL 77

Expert Comment

ID: 37045242
Haven't tried this but I would guess you would switch 'repeat section' on and off as required.

In the group header print event procedure.

Me.Section.RepeatSection = True

and in the group footer set it to false.
LVL 74

Accepted Solution

Jeffrey Coachman earned 2000 total points
ID: 37045608
LVL 31

Expert Comment

ID: 37072125
If issue persists, attach a simple report reproducing the issue with suitable test data.
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

LVL 49

Author Comment

by:Dale Fye
ID: 37072313

Have not forgotten you, just got retasked and have not had a chance to play with the recommendations.  Will hopefully get back to this tomorrow.
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37072420
LVL 49

Author Closing Comment

by:Dale Fye
ID: 37155037

This was precisely what I was looking form.  Thanks.


Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

810 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