Sage 100

 View Only

  • 1.  Crystal Reports - New Page After Group Selection

    Posted 05-15-2023 23:22

    Sage 100 2022.3 - Customer has multi-bin basic.  On the physical count worksheet, I need a new page to start after each bin location.  I know this has to be easy, I have selected all paging options on the group header and footer and I am not getting to the desired result.  I am getting each item to print on it's own page vs. all items for 1 bin on a page.  Attached is the crystal report and the physical count worksheet options I am choosing.  In the crystal report I have text fields with numbers so I knew the correct group sections. 3, 7 and 9 are the sections that are printing.  Any suggestions would be appreciated.



    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Attachment(s)

    rpt
    IM234_MBI_PhysicalCountWrkst.rpt   17 KB 1 version


  • 2.  RE: Crystal Reports - New Page After Group Selection

    Posted 05-16-2023 08:21

    I didn't test this because I don't have MB basic installed.  Here's something to try:  Go to section expert for Group Header 3c or 3d (depending on if you have expanded item codes).  Go to the Paging tab.  Click the X-2 to the right of the "New Page After" field and insert the following formula:  {@BinLocation}<>previous({@BinLocation})



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 3.  RE: Crystal Reports - New Page After Group Selection

    Posted 05-16-2023 15:45

    Thanks @Doug Higgs



    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Original Message


Related Content