How do I suppress a page footer with a Section Expert formula?

I would like to suppress a page footer so that it only displays on the last page of my report.  I saw another post with a recommendation to use the following Section Expert formula:

if pagenumber = totalpagecount then
    false
else
    true

When I try using this formula in the Section Expert, I receive the following message, "A statement is expected here" and the word "false" becomes highlighted in blue.  I'm obviously doing something wrong.  I would appreciate some assistance.
LA_TitanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
The formula looks correct.  Where did you add it?

Try it this way

Not OnLastRecord

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LA_TitanAuthor Commented:
I added the formula under Report \ Section Expert.  I selected Page Footer c.  I then selected the formula button (X-2) next to the Suppress (No Drill-Down) check box.  Finally, I copied and pasted the formula straight from the Experts Exchange website.

Is 'Not OnLastRecord' the whole formula?  I receive the following message, "A statement is expected here" and the word "Not" becomes highlighted in blue, when I tried to use it.
0
LA_TitanAuthor Commented:
I apoligize mlmcc.  You are absolutely correct.  If I use 'formula = Not OnLastRecord'  it works.  The page footer only displays on the last page.

Now I have a new problem.  There is a large blank space where the page footer used to be on page 1.  I will do a new search and create a new question if needed.

Thank you for all of your help.
0
LA_TitanAuthor Commented:
Thank you.  I really appreicate your help.
0
mlmccCommented:
That is a problem with Crystal, it reserves space for the footer before it generates the footer.

One way to get around it is to use a subureport for the footer.  Shrink the footer in size.

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.