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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Groups in Separate Pages

Status
Not open for further replies.

neozeke

Programmer
Oct 6, 2008
31
0
0
US
Hi,

How can I breakdown the groups in separate pages? I saw a "New Page After" option on the Details - Section Expert but I have no idea on what formula should I put in there.

Thanks.
 
You were on the right track. You don't need to put a formula there, to the left of the box you click to put in a formula there is a check box. Just click that box for the Group Header for New Page Before (or New Page After the Group Footer).

If you really want to put in a formula just put TRUE or 1=1 or something along those lines.
 
No need for a formula, except if you select group header->new page before you might want to add in a formula:

not onfirstrecord

Or, if instead you select the group footer->new page after, you probably want to add in a formula:

not onlastrecord

...so that you don't end up with an empty page at the end.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top