• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6072
  • Last Modified:

Is there a way to capitalize only the first letter of a word in Crystal Reports XI?

Hello Experts

Is there a formula to capitalize only the first letter of a word in Crystal Reports XI  if the word is stored as an uppercase string value in an Oracle database?  Thanks.
0
Janice Smith
Asked:
Janice Smith
1 Solution
 
dhobaleCommented:
Create a formula for propercase:

ProperCase ("your string variable here")
This will capitalize 1st letter.
0
 
PCIRichardCommented:
try the following formula:

left({field_name},1) & lcase(right({field_name},(len({field_name})-1)))
0
 
Janice SmithSystems AnalystAuthor Commented:
Wow, how easy was that!  Thank you very much for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now