Address Field

[cindy011680]

Hello Everyone,

I have been working on a crystal Report for 2-3 months, trying to get address to format the right way. The address is showing the text in all upper case letter but, I need mixed case.Can someone help me!!


CG

 

[synapsevampire]

The problem is that the data is stored in uppercase in your database.

Stating specifics will help, such as version of Crystal and database, but in the interim, try:

http://support.crystaldecisions.com/library/kbase/articles/c2011637.asp

This addresses using CR 9, or if you have a previous version, there's a UFL you can use.

-k

 

[cindy011680]

The only thing is our IT department cannot download information or URLS. If you have any other method please let me know.


Thanks
CG

 

[MJRBIM]

Your addresses are probably stored all in UPPER CASE because that is the format that is required by the USPS.

The complete list of standards required by the USPS are found starting on Page 11 in this PDF file -

http://pe.usps.gov/cpim/ftp/pubs/Pub28/Pub28.pdf

If you are creating mailing-labels, envelopes, or letters you should be using the UPPER CASE values.

Also..."our IT department cannot download information or URLS" --- how the hell do you get anything done???

 

[synapsevampire]

<chuckling>

Good points, all, MJRBIM.

However with personalized mailings most houses still prefer the look of mixed case, deeming it more personal with a better likelihood of getting opened.

You can create a loop to iterate through the characters and use mixed case for everything after the first character, but you're best served to fire your IT Manager, failing that, get someone to send it to an email account for you.

Check my profile for an email if you'd like me to do so.

-k

 

[cindy011680]

MJRBIM and Synapsevampire,

Thank for the funny, yet helpful advice. I am going to try to create a loop, and then see what happens.

 

[synapsevampire]

Loop your IT Manager with a garote, and...

It dawned on me that you might be able to leverage your database's propercase function in a SQL Expression if it has one.

For better results, try posting technical information in the future, such as Crystal and database version .

-k