Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

New Page after Group footer Problem 1

Status
Not open for further replies.

jaybar48

Technical User
Feb 16, 2002
61
US
I have a report where the "New Page After" option is checked for the primary group footer. Each page has a page header.

This correctly insures that the next group will start on a new page. But it also means that the page following the last group also has a "new page" which just has a page header. Is there any way of suppressing the "new page" after the last group? I tried to create a conditional
New Page after by including the formula PageNumber<TotalPageCount, but this had no effect There must be a way to suppress the final new page after. Thanks in advance.


Jay
 
In the formula area for &quot;New Page After,&quot; use:

Not Onlastrecord

-LB
 
Ibass

Tried your suggestion and it has no effect. Any other ideas?


Thanks,


Jay
 
Try deselecting the suppress box and place not(onlastrecord) in the formula. Remove any other formulas in there, and make sure that you don't have any new page afters/befores on other sections.

-k
 
As SV indicated, this should work. It works here when I test it. Perhaps you added the formula in the wrong section?

-LB

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top