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

Force a Page Break

Status
Not open for further replies.

sopomeres

MIS
Jan 16, 2003
61
US
Is there a way to force a page break after a specified number of records in the detail section? So, if I am listing names and let's say after every tenth record a page break is inserted. Can a formula be created to have this happen?

Thanks!
 
(PAGE HEADER)

Name : {@RecordCountReset}

Formula: Shared numberVar RecordCount := 0;

---------------------

(DETAIL)

Name : {@RecordCountAdd}

Formula: Shared numberVar RecordCount := RecordCount + 1;

---------------------

Name : {@RecordCount10}

Formula: {@RecordCountAdd} = 10

---------------------

(Format Formulas - SECTION EXPERT - DETAIL)

New Page After: Not OnLastRecord AND {@RecordCount10} = True

---------------------

Let me know how it works....
 
You could also use the following formula in the section format->details->new page after->formula area:

remainder(recordnumber, 10) = 0

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top