Sage 100

 View Only

  • 1.  crystal reports suppress page footer on last page

    Posted 05-20-2020 16:13
    Sales Order Invoice with a sub report pulling data from AR_CustomerContact.  We want to print the sub report data on a separate page after the invoice, but exclude the page header and footer from the last page.  After research, I did place the PageNumber=TotalPageCount in the Page Header - Section Export - Suppress, but that just removes the page header from all pages.

    ------------------------------
    Robert Ruff
    ServiceWorld Business Solutions
    ------------------------------


  • 2.  RE: crystal reports suppress page footer on last page

    Posted 05-20-2020 16:23
    The page header has the invoice header detail. You could change it be in the Group Header and then it won't appear on every page (unless you have the Group repeat group headers on all pages). Same with the invoice totals printing in the page footer. Change it to group footer.

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------



  • 3.  RE: crystal reports suppress page footer on last page

    Posted 05-21-2020 17:50
    This worked when we perform a quick print, but not when we print a range of invoices. If they print a range of invoices, only 1 sub-report prints.

    ------------------------------
    Robert Ruff
    ServiceWorld Business Solutions
    ------------------------------

    Original Message


  • 4.  RE: crystal reports suppress page footer on last page

    Posted 05-21-2020 18:05
    Make sure you're using the invoice header and footer (Group 2), not the group 1 header - that is different.

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


  • 5.  RE: crystal reports suppress page footer on last page

    Posted 05-21-2020 18:08
    Quick thoughts: new page before your sub report section (group footer?), with suppression formulas based on the page number = total number of pages... remembering to reset page numbers after each invoice (group settings).

    Changing the sections around to move page headers to group headers is really tricky.  Watch the section suppression formulas carefully!

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 6.  RE: crystal reports suppress page footer on last page

    Posted 05-20-2020 16:38
    If they are quick printing only, this can be done with the suppression statement OnLastRecord.

    ------------------------------
    Susan Pawlowic
    consultant
    RKL eSolutions, LLC
    ------------------------------



  • 7.  RE: crystal reports suppress page footer on last page

    Posted 05-21-2020 18:22
    Edited by David Speck II 05-21-2020 18:22
    See attached files for samples.

    What i did was left the report groups as they are, then added a new section to group level 3 (HeaderSeqNo), this could also work with group level 2 (InvoiceNo) but you might need to determine which is best for your case.

    Then set up the Paging tab as follows.

    Main/Top Level for Group. Uncheck "Print at Bottom of Page" on the Common tab for this level of the group.

    Section A for Group.

    Section B for Group.

    Then use your original suppression formula ("PageNumber = TotalPageCount") in all sections that should be suppressed on last page of the group. In my sample, i did this in the top level section for Page Header and Page Footer.


    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------

    Attachment(s)

    pdf
    SO_Invoice1.pdf   36 KB 1 version
    rpt
    SO_Invoice1.rpt   24 KB 1 version


  • 8.  RE: crystal reports suppress page footer on last page

    Posted 05-27-2020 12:17
    David - this is exactly what I needed.  Thank you for your help!

    ------------------------------
    Robert Ruff
    ServiceWorld Business Solutions
    ------------------------------

    Original Message


  • 9.  RE: crystal reports suppress page footer on last page

    Posted 07-08-2020 20:26
    Moved thread from Urgent to Sage 100 Community.

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------

    Original Message


Related Content