Address Field

[cindy011680]

Hi everyone,

The is my first time on this site. I am having a problem with my address field coming out in all uppercase characters. Does anyone know of a formula that I can use to just have the first character of each line
uppercase only?


Thank you

 

[bdreed35]

Is the database stored in the database in all uppercase or is it just being brought into Crystal that way? What version of Crystal, and what database are you getting your data from?

~Brian

 

[govmule]

There is a UFL that can be downloaded from Ken Hamady's web site

http://www.kenhamady.com

that allows the 'leadingcaps' function in formula's. It's very easy to use and only requires copying one dll to your workstation for it to work.

See ya,

Jack

 

[dgillz]

I am not sure LeadingCaps() will do what she wants. She wants to have the first letters be capitalized but the remaining letters in the word be lowercase. ProperCase() is the function you want, I believe.

Having said that, I cannot find the Crystal Decisions UFL page any more - they moved it on me! Does anyone have a URL for this?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[bdreed35]

The ProperCase function is included in version 9.

ProperCase({table.field})

This formula will set the first letter of every word in the field to upper case.

If your are using a different version you will either need to download one of the UFL's that basshead and dgillz are referring to from CD's site or you will need to write your own formula.

If you go the UFL route, you will need to install the UFL on every machine that would run the report. The nice thing about using the UFL is that once it is installed, you can use it in any report, the same as a built in function.

If you build your own formula, something like this:

Left(UCase({table.field},1) + Right({table.field},Len({table.field}-1)

you would need to manually copy the formula to any reports that would need to use it. The advantage here would be that if you only need it for one report, it would be part of the report, and you would not need to install anything on any workstations.

~Brian

 

[cindy011680]

Hello everyone,

Thank you all who responded to my thread these methods are very helpful to me.

 

[synapsevampire]

As a more permanent solution, suggest to your dba that he/she run a clean up program against the database, storing everything in all uppercase is a throwback to the 80's (at least), and there are numerous list clean up services and software available to correct it.

-k

 

[cindy011680]

synapsevampire (Programmer),

We have a good DBA that would clean up the program but, due to the management staff being 80+.Its hard to change the system.

Cindy011680