Mastering Crystal Reports 9

When geographic data is stored in a database, it is often stored in abbreviated format. Use these functions to expand the abbreviation to its full-text equivalent. Modify the functions to handle data beyond the United States and Canada.

cdExpandRegionAbbreviation Given a region abbreviation and a country, returns the full text of the region; supplied function handles Canada and United States only.

cdExpandRegionAbbreviationCanada Given a Canadian abbreviation like "AB," returns the full text of a phrase like "Alberta."

cdExpandRegionAbbreviationUSA Given a United States state abbreviation like "NY," returns the full text of a phrase like "New York."