Uppercase to Correctcase

[victora]

Hi everybody,
I have an SQL Database on the backend and I'm using CR8.5. The names in my database are all uppercase. I need to print names in the rightcase. (i.e. JOHN SMITH to John Smith)

How can I do that?

Thanks in advance.

 

[NJLDoc]

Have not tried this in Crystal yet though it works in vb vbProperCase(string). Can create as UFL if not.

 

[synapsevampire]

From the Crystal site:

In CR 8.5 and earlier, to format the string or text field similar to the ProperCase function, use the LeadingCaps User Function Library (UFL). The LeadingCaps UFL can be obtained by searching for the file name, Uflcaps.exe, on our support site at:

http://support.crystaldecisions.com/

This file contains the U2lcaps.dll (for 32-bit applications) and the Uflcaps.dll (for 16-bit applications). Refer to the Readme.txt file for the correct installation of the Dynamic Link Library (DLL).

The LeadingCaps function capitalizes the first character of a string after a space, tab or hyphen.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[victora]

synapsevampire
thanks a lot! it works like a charm...

va