The Issue:
The data for an address field within the database is entered as a block:
234 High Street Catford London SE34 7GH
, which when displayed in Crystal Reports, increased the details section, making the report bigger than it needed to be.
The Solution:
To save space on the report, the field needed to be displayed on one line, by replacing the line returns with a space.
To do this we used the REPLACE function:
REPLACE(REPLACE({Tablename.Fieldname}, CHR(13)," "), CHR(10),",")
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us | 
