Purchase Order format - Wrap line text

Last post 11-12-2008 6:07 AM by Steven Chapman. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 11-12-2008 2:51 AM

    Purchase Order format - Wrap line text

    I am trying to format the output of the Purchase Order.  We often have Order lines that need more than one line, howver I can find no setting in the Report Formatter that allows me set this option.

    Any ideas on how to display multiple lines for a single purchase order item line?

  • 11-12-2008 5:55 AM In reply to

    Re: Purchase Order format - Wrap line text

    You can use the RW_ParseString() report writer function as a user defined function (system series) in a set of calculated fields.  You will need to make one calculated field for each line of x characters (up to max of 80).  This function will not split a word, but rather breaks on the spaces.

    The parameters are:

    in string IN_string;    { String Field to Parse }
    in integer IN_characters;  { Number of Characters per Line }
    in integer IN_line;    { Line Number to Return } 

    So an example would be for 3 lines of 50 characters

    Calc field 1: RW_ParseString('Description'   50   1)

    Calc field 2: RW_ParseString('Description'   50   2)

    Calc field 2: RW_ParseString('Description'   50   3)

    This does mean that you have to set aside the space for 3 lines on the report, and a gap will be left if the description does not need the number of lines.

    David Musgrave [MSFT]
    Escalation Engineer - Microsoft Dynamics GP
    Microsoft Dynamics Support - Asia Pacific

    Microsoft Dynamics (formerly Microsoft Business Solutions)
    http://www.microsoft.com/Dynamics

    mailto:David.Musgrave@online.microsoft.com
    http://blogs.msdn.com/DevelopingForDynamicsGP

    Any views contained within are my personal views and not necessarily Microsoft policy.
    This posting is provided "AS IS" with no warranties, and confers no rights. 


     

    Tags:
  • 11-12-2008 6:07 AM In reply to

    Re: Re: Purchase Order format - Wrap line text

    Thanks, it works a treat.

Page 1 of 1 (3 items)