Suppress Page Number on Last Page/Report Footer 1

[boldulyses]

I'm trying to suppress Page Numbers at the beginning and end of my report, specifically pages 1-4 and then the last page of the report, which I don't know what it will be at each running of the report. Here's what I have so far.

PageNumber Mod 2 = 0 // On Right Side for Title Page/Report Header
PageNumber Mod 2 = 1 //On Left Side for Intro Page/Report Header pg 2

I don't know what to do in order to suppress the subsequent pages 3 and 4 (also part of the Report Header), nor do I seem to be able to figure out how to suppress it for the Report Footer, which is the Last Page.

 

[poujor]

Hi,

I understand, you want pagenumbers on all pages except pages 1 through 4 and last page.

To handle this create the following formula and use it as page number

if (PageNumber in [1,2,3,4]) or (PageNumber = TotalPageCount) then
""
else
cstr(PageNumber,0,"")

 

[boldulyses]

The formula result must be a boolean"

This is what I receive when I attempt this. Should I be putting this somewhere else? Will I need to make this change to both of my "Page Number" entries on the left and right side of the page?

This is Crystal XI, too. And I am Crystal-dumb...

 

[lbass]

This is not a suppression formula. Go to the field explorer->formula->new and create the formula there and then drag it onto your report where you want the page number to display.

-LB

 

[boldulyses]

Brilliant! Works like a champ. I did make some modifications for a couple of reasons. I need to have the page numbers on opposite sides as this will become a bound document. So, here's what I ended up doing.

I created a Field '@Pagination' using the formula you provided me, but with a twist.

if (PageNumber = TotalPageCount) then ""
else cstr(PageNumber,0,"")

I then placed two of these fields into my report, one on the left and one on the right. To keep them on their own sides I created a suppression formula for each.

PageNumber Mod 2 = 0 // On Right Side
PageNumber Mod 2 = 1 //On Left Side

I'm still completing the page 3 and 4 so I'll modify these as necessary. Thanks so much for the help!