Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Courage is the ability to do something that, for whatever reason, we instinctively fear
 
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!!!!

09
June

How Do I Convert Text to Sentence Case in Crystal Reports?

During a recent Crystal Reports training session, one of the delegates wanted to display a text field that contained data in various cases to sentence case.

Solution:

Crystal Reports comes with a number of Case conversion functions.

To convert text to sentence case:

PROPERCASE ({Tablename.Fieldname})


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:

36 + 69 =