Custom Geographic Functions

Appendix D - Crystal Reports Custom Functions
Mastering Crystal Reports 9
by Cate McCoy and Gord Maric
Sybex 2003

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."

Use of content on this site is expressly subject to the restrictions set forth in the Membership Agreement

Conello © 2000-2003     Feedback