Solved

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

Posted on 2009-05-14
3
4,860 Views
Last Modified: 2012-05-07
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
Comment
Question by:jsmith08
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 5

Accepted Solution

by:
dhobale earned 500 total points
ID: 24388963
Create a formula for propercase:

ProperCase ("your string variable here")
This will capitalize 1st letter.
0
 
LVL 7

Expert Comment

by:PCIRichard
ID: 24388983
try the following formula:

left({field_name},1) & lcase(right({field_name},(len({field_name})-1)))
0
 

Author Closing Comment

by:jsmith08
ID: 31581650
Wow, how easy was that!  Thank you very much for your help.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question