SAP Knowledge Base Article - Public

1269163 - Change page number information

Symptom

  • User wants to change the page number information which is displayed by the PageNumber or Page N of M special fields.

Reproducing the Issue

This issue has been tested and successfully implemented in the following environment:

  1. Operating System: Windows XP,Windows 2003
  2. Crystal Reports:10,XI Release 1,XI Release 2,CR 2008

Cause

  • In Crystal Reports, every page that gets displayed in the Preview tab can be marked with the page number by using the PageNumber or Page N of M special fields.
  • User is generally unable to modify this display as per requirement

Resolution

  • As an example I will consider the requirement that the user needs to display the page number information from the second page rather than the first page.
  • Say, the requirement is to dispaly the page number 2 as 1,3 as 2 and so on.
  • We need to create a formula for this as follows

       @Page Number:

        if PageNumber > 1 then "Page " & mid(cstr(PageNumber-1),1,instr(cstr(PageNumber-1),".")-1) &" of "& mid(cstr(PageNofM),instr(cstr(PageNofM),"f")+2) else "";

  • Then user can place this formula in the page footer section or any other section (as per requirement) where the page numbers are required to be displayed.

Keywords

  • Page N of M,PageNumber,Crystal Reports XI R1,CR 2008,special fields
, KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2

Attachments

Page Number.JPG