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

Posted on 2008-11-17
Last Modified: 2012-05-05
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

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.
Question by:LA_Titan
    LVL 100

    Accepted Solution

    The formula looks correct.  Where did you add it?

    Try it this way

    Not OnLastRecord


    Author Comment

    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.

    Author Comment

    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.

    Author Closing Comment

    Thank you.  I really appreicate your help.
    LVL 100

    Expert Comment

    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.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now