Oct 5, 2002 #1 nateshk Programmer Jan 16, 2001 49 HK Hi , Iam using Crystal Reports as a reporting tool in my application. I want only 10 records appearing on a page ie; after 10 records the 11th record should be printed on a new page. Hope some of u can help me out. Thanx in advance. Natesh
Hi , Iam using Crystal Reports as a reporting tool in my application. I want only 10 records appearing on a page ie; after 10 records the 11th record should be printed on a new page. Hope some of u can help me out. Thanx in advance. Natesh
Oct 5, 2002 #2 synapsevampire Programmer Mar 23, 2002 20,180 US Add a formula to the NEW PAGE BEFORE akin to: recordcount/10 = int(recordcount/10) Kinda tired, but that seems right. This assumes natural row order. Otherwise you might create a fwe formulas witrh variables to keep track of each 10 and reset it: Place somthing like this in the report header: whileprintingrecords; global numbervar MyNumber:=0; And something like this in the detail section: whileprintingrecords; numbervar MyNumber; global MyNumber:=MyNumber+1 And something like this in the New Page Before formula for the detail section: whileprintingrecords; global numbervar MyNumber; booleanvar PageKick; If MyNumber=10 PageKick := True; MyNumber:=0; PageKick Looks right... -k http://www.informeddatadecisions.comkai@informeddatadecisions.com Upvote 0 Downvote
Add a formula to the NEW PAGE BEFORE akin to: recordcount/10 = int(recordcount/10) Kinda tired, but that seems right. This assumes natural row order. Otherwise you might create a fwe formulas witrh variables to keep track of each 10 and reset it: Place somthing like this in the report header: whileprintingrecords; global numbervar MyNumber:=0; And something like this in the detail section: whileprintingrecords; numbervar MyNumber; global MyNumber:=MyNumber+1 And something like this in the New Page Before formula for the detail section: whileprintingrecords; global numbervar MyNumber; booleanvar PageKick; If MyNumber=10 PageKick := True; MyNumber:=0; PageKick Looks right... -k http://www.informeddatadecisions.comkai@informeddatadecisions.com