Sep 28, 2005 #1 AlreadyLost MIS Joined Sep 16, 2005 Messages 191 Location 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.
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.
Sep 28, 2005 #2 lbass Technical User Joined Feb 9, 2002 Messages 32,818 Location US Go to the section expert->details->new page after->x+2 and enter: remainder(recordnumber,4) = 0 -LB Upvote 0 Downvote
Sep 28, 2005 Thread starter #3 AlreadyLost MIS Joined Sep 16, 2005 Messages 191 Location US It works! Thanks... Upvote 0 Downvote
Sep 28, 2005 #4 synapsevampire Programmer Joined Mar 23, 2002 Messages 20,180 Location US 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 Upvote 0 Downvote
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
Sep 28, 2005 Thread starter #5 AlreadyLost MIS Joined Sep 16, 2005 Messages 191 Location US Okay. Thanks. Upvote 0 Downvote