crystal-reportscrystal-reports-2011sage-crm

Where in the database can I get the country name that matches addr_countrycode


I am using Sage CRM and creating reports in Crystal Reports 2011

I would like to display the country name that is in Addr table but it only has a code IE for Ireland.

So my question is, where do I get the value Ireland (instead of IE)


Solution

  • You could go here:

    [http://www.worldatlas.com/aatlas/ctycodes.htm#.Ud6_XW39w24][1]

    and get all the country codes. You will have to write some kind of implementation that maps the codes to the names. Now this will work assuming your database uses standard country codes.

    Another thing to look at is how did the country codes get in your database in the first place? Obviously there is some function that maps country names to codes. Simply write the inverse of that function.

    See having an understanding of math does help one in life.