Map Report
We use Apex 4.0.
Currently we have maps working, illustrating customer activity by country.
The challenge is to be able to click on a country and be taken to a new map, showing that country, with activity by Airport.
So far I can get a European map to work by country and a USA map to work by State, but I cant get anything working by Airport.
I've figured out that the countries are NOT by ISO standard (Germany is 'GM' instead of 'DE' for example) didn't expect Oracle to re-invent country codes, but they appear to have done so.
Is there something similar happening with airport code, do we need to install an addendum (extra lookup nfo for airports?) or have I missed an obvious way to make this function?
Currently we have maps working, illustrating customer activity by country.
The challenge is to be able to click on a country and be taken to a new map, showing that country, with activity by Airport.
So far I can get a European map to work by country and a USA map to work by State, but I cant get anything working by Airport.
I've figured out that the countries are NOT by ISO standard (Germany is 'GM' instead of 'DE' for example) didn't expect Oracle to re-invent country codes, but they appear to have done so.
Is there something similar happening with airport code, do we need to install an addendum (extra lookup nfo for airports?) or have I missed an obvious way to make this function?
0