Like all other Publisher report types, a map starts with defining a report:
The report SQL is:
SELECT ff.facility_id,
ff.facility_code,
ff.facility_name,
ff.description,
ff.status from
fam_facility ff
The resulting report will look something like:
To link to google maps the Report SQL needs the Facility_ID but this value is not meaningful to users so it should not be displayed:
- Concepts of the Map
A Map is a particular kind of chart. - Basic Map Creation
To create a Map click the
button and then the Edit Selected Chart button:
Click the Save button and the box on the right will change to something like:
