Leading Caps Formula

[harrietohs]

I am looking for the formula to use with Crystal to turn the first letter of a persons name into upper case (leading caps). Can anyone help.

Thanks,

Harriet Farmer
Ottawa Humane Society

 

[lupins46]

Which version of CR?

V9 onwards gives you:

Propercase({mytable.myfield})

 

[vidru]

In the later versions of Crystal, there is a ProperCase function. Pre-CR9, there is a LeadingCaps UFL (User Function Library) that you can download for this:

http://support.businessobjects.com/communityCS/FilesAndUpdates/uflcaps.exe.asp

-dave