Use this formula to remove the carriage return and extra spaces
   

{@REMOVE} - Removes the carriage return from the field, then trims the spaces.
    Trim (Replace ({Field}, chr(13), "" ))

{@Join1} - Suppressed in Details
    Shared stringVar Y:= {@REMOVE};
    Shared stringVar X;
    Shared stringVar Z;


{@Join2} - In details section displays the concatenated field
    EvaluateAfter ({@JOIN1});

    shared Stringvar X := {@Join1}; // Previous Record
    Shared stringVar Y:= {@REMOVE}; // Data without Carriage Return
    Shared StringVar Z;

    IF RECORDNUMBER = 1 THEN Z := Y ELSE Z:= X & "," & Y;

    Z

I did received an error about the maximum number of characters in a string being 65,534.


Edited by neinta - 28 Aug 2008 at 3:07pm

You can copy {@Join2} to the footer.  Suppress it in the details.  This will give you the complete list in the footer.


If you are using groups and need to reset for each group make a new formula and place it in the header.

{@Reset}
    shared StringVar Z := "";

and replace the if statement in {@join2} with
    IF Z = ""  THEN Z := Y ELSE Z:= X & "," & Y;

I'm getting a duplicate last line also. Can anyone help?? I'm going to look at it further.

 Awesome! Thanks!