Sage 100

 View Only

  • 1.  Blank Line After a Comment

    Posted 05-08-2020 13:06

    Is there a way to add a blank line below the line after writing the in either the comment field or the item code /C ?

    Using Ctrl Enter in the comment field adds a space but if you don't type anything more, it won't create a space when you print it.  The end user currently adds another blank /C.  They hope they can automatically put a blank row below a comment without having to add the blank /C.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------


  • 2.  RE: Blank Line After a Comment

    Posted 05-08-2020 13:10
    Edited by Kevin Moyes 05-08-2020 13:11
    In the form, change the field to a formula like this (making sure to set the "Can Grow" checkbox for the report object).
    {SO_InvoiceWrk.CommentText} + chr(13) + chr(10) + chr(13)+ chr(10)

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



  • 3.  RE: Blank Line After a Comment

    Posted 05-08-2020 13:34
    Thank you for the good idea @Kevin Moyes  I was thinking the user could control whether a space could be entered during data entry, but modifying the form to always print a space is a great alternative. ​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------

    Original Message


  • 4.  RE: Blank Line After a Comment

    Posted 05-09-2020 01:48
    It seems Crystal Reports automatically strips trailing white-space characters from database fields, this includes spaces, CHR(255), carriage returns, and line feeds.
    As Kevin said, you can hardcode it into a formula or you can alternatively use a checkbox UDF added to the lines that allow the user to toggle whether or not extra lines are added, you would just change the formula in crystal to look at the UDF. If you don't want to implement a UDF, you could instruct the users to tack on a "special control character" to the end of the comment, could be something like an asterisk, tilde, etc, then in crystal, use the Right function to check the last character of the comment text field and if equal to the special control character, tack on as many carriage return & line feed combinations as the client wants, whether that is one, two, or more.

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

    Original Message


  • 5.  RE: Blank Line After a Comment

    Posted 05-09-2020 03:47
    Thanks @David Speck II ​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------

    Original Message


Related Content