Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Excellence can be obtained if you care more than others think is wise, risk more than others think is safe, dream more than others think is practical, expect more than others think is possible
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


How Do I Display a Block Address on One Line in Crystal Reports?

The Issue:

The data for an address field within the database is entered as a block:

234 High Street
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


Name *

Email Address *

Comment *

To prove you are human what is:

63 + 16 =