Is there any way to set the Column width of a report to auto so the contains is not on two line spaces, something similar to autofit selection in Excel!
I'm afraid not ...
Have you tried setting the White Space to No Wrap( properties pane on the left hand side)