Print page Footer On Last Page in Crystal report

Posted on 2009-02-12
Last Modified: 2012-05-06
I have a bill report that take 24 items , but some time it take more so it will be printed on several pages , but the page footer which inclue the bill amount total and discount and other inf printed on each page . How can I make it just on the last page.
Question by:Ahmadal_najjar2003
    LVL 69

    Expert Comment

    by:Éric Moreau
    include that in the Report footer section (and not the page footer)
    LVL 100

    Accepted Solution


    Another way if you want the page footer to appear only on the last
    Right click the page footer in the left margin
    Click the FORMULA BUTTON to the right of SUPPRESS
    Not OnLastRecord

    If you only want that field suppressed in the page footer
    Right click the field
    Click the FORMULA BUTTON to the right of SUPPRESS
    Not OnLastRecord


    Author Comment

    Thats wanderful mlmcc. It works fine .  but about if I want to print PageNo if tatal pages more than one
    what is the syntax.

    Author Comment

    Ok , I found it like this , tClick the FORMULA BUTTON to the right of SUPPRESS
    totalpagecount =1

    Author Closing Comment

    Thank you

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    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…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    779 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

    12 Experts available now in Live!

    Get 1:1 Help Now