Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5894
  • 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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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