I have a report that grouped on two levels and I need the second grouping to begin on a new page. I have accomplished that but I get a first page that is blank. How may I eliminate that page? My DB is attached.
I have a report that grouped on two levels and I need the second grouping to begin on a new page. I have accomplished that but I get a first page that is blank. How may I eliminate that page? My DB is attached.
By second group, do you mean Room-Session?
Maybe move the page break to the end of the Room-Session Footer. Unfortunately, that will mean a blank page at the end.
Instead of page break control, try setting ForceNewPage property of the footer to AfterSection.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Forgot about the Force New Page option; perfect solution, thanks.