How do I add a line break to Text in a Pivot table

[PT109]

I have a filed in the database which is a comment field with a max of 250 characters. I would like to display it in a pivot table, but I do not see any way to wrap the text. I have tried to break it into substrings and concatinate a CR/LF or a \n but this does not seem to work. Any help would be appreciated.

Thanks in advance
Paul

 

[tallbarb]

As far as I know, there's no easy way to do this. However, you can force text to wrap in a Pivot report by clicking into the text you want to wrap and then double-clicking the line at the bottom of the text or dragging the line down if it's not a lable but "facts" - this should make any text in that line wrap and any other line in the same Pivot report with the same content. Unfortunately, I don't know of any way other easy way. I tried a startup document script:
ActiveDocument.Sections["Pivot"].SideLabels.TextWrap=true
That had no effect on long side labels, either. Still had to do it manually.