Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How do I create multiple lines in a text field?

I am creating a report that features a cross tab. For the columns I am using a field with a few members that each have somewhat lengthy names. This makes my columns way bigger than they need to be and the forces the report onto a second page. Is there a way to format the text in the field so that the column will become two lines that way I can fit the entire name of the field in the column without over stretching the column width?

Thanks

Tags:
Former Member replied

Yes  Use a formula to break the text field into is components or Test the length of the string.  then add a  " Carriage return"     where you want to force the second line.    

   The formula will look something like    {field name} +  CHR(13) + {fieldname}  

The chr(13)    will force the Carriage return   ( like an old manual Typewriter for those us us old enough to have actually used one ) 

Ted

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question