Home on the web ~ Dan Van Fleet

Information on SoftPro ProForm with some general computer tips and techniques, with a bit of me.

Home on the web ~ Dan Van Fleet - Information on SoftPro ProForm with some general computer tips and techniques, with a bit of me.

Crystal Reports, State Letter to State Name

From time to time I need a formula to convert a database stored state letter into a state name. Replace Search.StateLet with your database column.  This formula is setup to work with a SoftPro ProForm Report.

 

Select {Search.StateLet}

   case "AB" : "Alberta"

case "AK" : "Alaska"

case "AL" : "Alabama"

case "AR" : "Arkansas"

case "AS" : "American Samoa"

case "AZ" : "Arizona"

case "BA" : "Bahamas"

case "BC" : "British Columbia"

case "CA" : "California"

case "CO" : "Colorado"

case "CT" : "Connecticut"

case "DC" : "District of Columbia"

case "DE" : "Delaware"

case "FL" : "Florida"

case "GA" : "Georgia"

case "GU" : "Guam"

case "HI" : "Hawaii"

case "IA" : "Iowa"

case "ID" : "Idaho"

case "IL" : "Illinois"

case "IN" : "Indiana"

case "KS" : "Kansas"

case "KY" : "Kentucky"

case "LA" : "Louisiana"

case "MA" : "Massachusetts"

case "MB" : "Manitoba"

case "MD" : "Maryland"

case "ME" : "Maine"

case "MI" : "Michigan"

case "MN" : "Minnesota"

case "MO" : "Missouri"

case "MS" : "Mississippi"

case "MT" : "Montana"

case "NB" : "New Brunswick"

case "NC" : "North Carolina"

case "ND" : "North Dakota"

case "NE" : "Nebraska"

case "NH" : "New Hampshire"

case "NJ" : "New Jersey"

case "NL" : "Newfoundland"

case "NM" : "New Mexico"

case "NS" : "Nova Scotia"

case "NT" : "Northwest Territory"

case "NU" : "Nunavut"

case "NV" : "Nevada"

case "NY" : "New York"

case "OH" : "Ohio"

case "OK" : "Oklahoma"

case "ON" : "Ontario"

case "OR" : "Oregon"

case "PA" : "Pennsylvania"

case "PE" : "Prince Edward Island"

case "PR" : "Puerto Rico"

case "QC" : "Province of Quebec"

case "RI" : "Rhode Island"

case "SC" : "South Carolina"

case "SD" : "South Dakota"

case "SK" : "Saskatchewan"

case "TN" : "Tennessee"

case "TX" : "Texas"

case "UT" : "Utah"

case "VA" : "Virginia"

case "VI" : "Virgin Islands"

case "VT" : "Vermont"

case "WA" : "Washington"

case "WI" : "Wisconsin"

case "WV" : "West Virginia"

case "WY" : "Wyoming"

case "YT" : "Yukon Territory"

case "" : "";

Your email address will not be published. Required fields are marked *

*

css.php