Crystal Reports 2011 -> String functions to change the case/capitalization

[Former Member]

      There can be a scenario that the string values in the database field are not available in proper case and user wants to change the case in the report output. Hence to present the string values in the correct / expected format in the report output we have 3 built in functions within Crystal Reports which take input values as only “string”->

1)      Propercase

2)      LCase/LowerCase

3)      UCase/UpperCase

Now let us take an example and see how to use it:

For example there is a database field called Name and the values under names are as follows:

Name:

BOB GraysON

RAnDY ThoMAS

RoberT ALAMAR’s

1) ProperCase Function Implementation: This function takes input value as string and capitalizes the first letter of each word in the string and converts all other letters to lower case & if any letter that follows a non-alpha character it capitalizes that letter as well. For example if we pass Name value of the database field we get following result:

ProperCase ("BOB GraysON") -> It will return “Bob Grayson”

ProperCase ("RAnDY ThoMAS") -> It will return “Randy Thomas”

ProperCase ("RoberT ALAMAR’s") -> It will return “Robert Alamar’S”

2) LCase/LowerCase Function Implementation: This function takes input value as string and converts the input string to all lower case. Note LCase and LowerCase are equivalent functions.

For example if we pass Name value of the database field we get following result:

LCase ("BOB GraysON") -> It will return “bob grayson”

LCase ("RAnDY ThoMAS") -> It will return “randy thomas”

LCase ("RoberT ALAMAR’s") -> It will return “robert alamar’s”

3) UCase/UpperCase Function Implementation: This function takes input value as string and converts the input string to all upper case. Note UCase and UpperCase are equivalent functions.

For example if we pass Name value of the database field we get following result:

UCase ("BOB GraysON") -> It will return “BOB GRAYSON”

UCase ("RAnDY ThoMAS") -> It will return “RANDY THOMAS”

UCase ("RoberT ALAMAR’s") -> It will return “ROBERT ALAMAR’S”

• Note: Numbers that are part of the input string are not affected by  any of the above mentioned function.