Field not displaying in one line

[Cpreston]

Hi

I am accessing a SQL table and the field type is varchar

I have brought it into my report using this formula "Delivery Address: " + {148_vwSalesAnalysisReportQuery.DeliveryAddress}
However it is only showing the first part of the address. If I format the filed and in common click Can Grow and change the maximum number of lines to 3, it then shows the information under each other.
I want it to show in all one line, it looks all in one line in the SQL table.

So fore example I am getting

1 High Street
Leeds
DN5 1LE

But I want it all in one row like

1 High Street, Leeds, DN5 1LE

Any ideas and thanks in advance

 

[Cpreston]

Found solution in another posting


replace(replace({148_SalesAnalysisReportData.DeliveryAddress},chr(13),", "),chr(10),"")