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

Printing the Report

Status
Not open for further replies.

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
 
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 kai@informeddatadecisions.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top