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

Start page numbering on page 2 2

Status
Not open for further replies.

jcl5

IS-IT--Management
Dec 6, 2002
89
GB
Hi guys

I'm using Crystal 10 and Oracle 8i.

I am using PageNofM but I want to start the page numbering on Page 2. Any ideas how I might do this.

Thanks

jcl5
 
Use the following formula:

totext(pagenumber - 1, 0,"")+" of " + totext(totalpagecount - 1,0,"")

Then right click on the formula->format field->common->suppress->x+2 and enter:

pagenumber = 1

This will start the page numbering at "1" on the second page and will also count the page total excluding the first page.

-LB
 
Thanks! - this works great but I can now see that I didn't specify what I wanted correctly.
What I need is to start numbering on page 1 but show it as page 2, i.e. page 1 appears as page 2, page 2 appears as page 3 etc.

Thanks

jcl5
 
May I suggest an alternative to using the formula mentioned above?

1. Right-click on PageNofM & go to Format Field...
2. Click the Common tab & open the Formula builder next to Supress.
3. Type: pagenumber=1
4. Save changes.


On the 2nd issue you mention, starting the counting @ page 2...
I'm sure there's another way to do this, but what about going to the Section Expert for the Report Header and checking the box for New Page After. If you want to leave the top page blank for a cover page, this might work.
 
Alter lbass's formula to:

totext(pagenumber + 1, 0,"")+" of " + totext(totalpagecount + 1,0,"")

And then remove the conditional suppression.

~Brian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top