Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
A beautiful thing is never perfect
 
Proverb
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!!!!

06
June

How Do I Extract the First Name from a Contact Field in Crystal Reports XI?

I was asked during a recent training session "How Do I Separate the First Name from the Surname in a Contact Name Field in Crystal Reports XI?"

Solution:

The delegate needed to create a letter just using the first name part of a field that held the full name.

To separate the first name from the surname within a field, one will have to use two string functions, Left and InStr.

The formula to do this is:

Left({Tablename.Fieldname},InStr({Tablename.Fieldname}," ")-1)



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 *

To prove you are human what is:

26 + 87 =