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!

Print 4 record number per page

Status
Not open for further replies.
Sep 16, 2005
191
US
Can I write a formula within section expert to just print 4 records per page.. If so, how, where?

My report already display the data with recordnumber.
 
Go to the section expert->details->new page after->x+2 and enter:

remainder(recordnumber,4) = 0

-LB
 
If you end up sorting the rows locally, the recordnumber may not work, so you can also create formulas to accomplish this:

page header formula:

whileprintingrecords;
numbervar pg:= 0;

Details formula;
whileprintingrecords;
numbervar pg:= pg+1;

Then do as LB suggests only reference the variable:

whileprintingrecords;
numbervar pg;
remainder(pg,4) = 0

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top