Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2008-11-17
Medium Priority
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
  • 3
  • 2
LVL 101

Accepted Solution

mlmcc earned 1000 total points
ID: 22979863
The formula looks correct.  Where did you add it?

Try it this way

Not OnLastRecord


Author Comment

ID: 22980517
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

ID: 22980966
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

ID: 31517609
Thank you.  I really appreicate your help.
LVL 101

Expert Comment

ID: 22981132
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.


Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

578 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