Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Don't accept unacceptable behaviour
 
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!!!!

08
June

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
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

MAKE A COMMENT

Name *

Email Address *

Comment *