crystal report supress report footer

hi
I am using crystal report 10. How can I ask a report footer to be display only when it is at the last page.

thank you
rickchan108Asked:
Who is Participating?
 
habibbConnect With a Mentor Commented:
place following formula in suppress formula of page footer.

if pagenumber = totalpagecount then
    false
else
    true

0
 
habibbCommented:
report footer bydefault displays at the last page of whole report.
How ever if you want to display it conditionaly then you need to place a code in suppress formula window in section experts.

0
 
rickchan108Author Commented:
sorry, it is typo. I mean page footer to be display at last page.

thanks
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
rickchan108Author Commented:
thanks habibb
0
 
habibbCommented:
Glad its help you.
0
 
mlmccCommented:
You could also use

OnLastRecord

mlmcc
0
 
expertsexchangetraceyCommented:
I'm using the formula "pagenumber = totalpagecount" to suppress my page header.  This works, but if the last page of my report fills the entire page (w/o the header), the TotalPageCount is 1 too many.  It is like Crystal counts the pages before suppressing the page header.  In other words, my report is 3 pages but Crystal is confused and thinks it is 4 becuase it is supressing the page header on the last page AFTER it calculates TotalPageCount.  

How can I suppress the page header on the last page AND have a correct TotalPageCount?
0
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.

All Courses

From novice to tech pro — start learning today.