Crystalkeen logo; we offer Crystal reports viewers and schedulers
Crystalkeen header image 3
Crystalkeen header image 5

Crystal Reports Tools: Improve Performance While Saving Time and Money




CR Schedulers
CR Viewers
DataBase Tools
Mail UFLs


About us

Contact Us

on Steroids

Crystal Reports: Page N of M–improved performance

On our Crystal Reports, it is often useful to display Page N of M. This has been a useful special field for several versions, now.

Unfortunately, using it can really slow down the development process.

Crystal does "Page on Demand," which means it can show you the first page of your report while continuing to process data for subsequent pages. But if you are using "Page N of M" or "Page Count," the entire report has to be processed before you can view the first page.

One solution is to omit the Page count or Page N of M until the final stage of report development. But page numbers and counts are useful on all reports. And if you need to make later changes to the report, you don’t want to delete and recreate the field. Adding and removing fields can lead to errors.

A better idea is to use a formula:

//PageNofM //or

"Page " + totext(PageNumber,0,"","")

Use the first line for production reports (and comment out the second line), and use the second line while you are designing or (redesigning) the report.

It's usually better to put the page number in the footer, rather than in the header. Why? Because that's not "headline" information. It's really tertiary, so it's best to have it at the bottom.


This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.


Except where an author's name is given at the start of the article, all of these articles were written by Mo Naughton or Bruce Ferguson and edited by Mark Lamendola. Mo is a Crystal Reports consultant, trainer, and developer for Chelsea Technologies, Inc. Bruce Ferguson is a Crystal Reports consultant, trainer, and developer for CrystalKiwi, Inc. Mark Lamendola is a writer and editor with over 15 years experience in professional and trade publications.


  • Questions? Please write to We do want your business.
  • Do you have your own tips for Crystal Reports administrators and designers? Write to and we'll post your tips with a link to your Website (or with some other attribution if you choose).
  • Crystal Reports is a subsidiary of Business Objects, which is owned by SAP.