Sage 100

 View Only
  • 1.  Suppressing 0 quantity shipped lines on SO invoices (Crystal Reports)

    Posted 08-22-2023 14:54

    Client looking to suppress 0 quantity shipped lines on invoices. Turns out it isn't so simple as adding suppression logic of QuantityShipped = 0 or Record Selections QuantityShipped <> 0. First creates an issue with the footer if last item on the invoice is 0 quantity shipped and the second doesn't work.

    Has anyone come up with a solution to this problem and can share?



    ------------------------------
    Myron Stevenson
    Consultant
    Clearis Consulting, Inc
    Duluth, MN
    218-525-6720
    ------------------------------


  • 2.  RE: Suppressing 0 quantity shipped lines on SO invoices (Crystal Reports)

    Posted 08-22-2023 18:08

    Idea:

    Suppress everything in the section, based on your logic... then Suppress Blank Section (checkbox), instead of suppressing the section.  CR has to process all the objects in the section, before the section is suppressed, hopefully solving your extra complications with full suppression. 

    (That is how I don't waste space with sub-reports used exclusively to pass shared variables to the main report...).



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