Page Comparison

Create a Report

To add a report, click New above the Reports table. A New Report window will appear where you can fill in the following details:

• Report Name: The name of your report. This is what will be visible in viewer drop-down when a user generates a report. 

• Template: Select a pre-configured report template to use. For more information on uploading and using these, see Report Templates.

• Report Layer: Select the layer you wish to base the report on i.e. what the user will select and generate a report from. 

On saving, a new report page will be created. New elements can now be added to build the report.

Add Maps

Report elements define the content you wish to include in a Report. Elements such as maps, tables and text can be added to a new report simply by clicking Add element .To add a map to a report, select Map from the drop-down. This will open the map configuration panel on the right-hand side of the page. In this panel, the following map details to be configured:

• Webmap:

  what

  What webmap to add to the report. Once a webmap has been selected, a preview of the map will appear in the bottom preview box.

• Extent: Extent can be fixed or dynamic based on the selected feature

• Print template: The print template that will be used to create the map image.

• Title Field: You can optionally select a field from the report layer to be dynamically set the title of the map, eg an Address Field.

• Use a Fixed Scale: You can optionally choose whether you would like to have your maps printed at a fixed scale.

• Layers: The right-hand side of the map will display the layers currently turned on in the webmap. Expand the layers to turn on and off layers to include in the Map added to the report.

Click save to add the map to the report. A preview will then appear in the left-hand panel. This preview will include the Map name and Map thumbnail. Elements can be reordered by dragging and dropping to a new position in the list.

Example Map Element below.

Image Removed Note: If you have a print layout service configured with LocalMaps, then the scales of the output maps will be automatically rounded to the nearest whole reasonable value, eg, 1:423 would become 1:500.

Image Added

Add Tables

To add a table to a report, click on the Add element drop-down and select Table. This will open a table configuration panel on the right-hand side of the page. Tables added to a LocalMaps report can be either a Table Join or a Spatial Join based on a layer or database query.

This section allows the following table details to be configured.

• Table Heading: this This is the heading that will appear above the table.
• Table Heading Style: the The style for the table heading.
• Table Type: the  The table type can be vertical or horizontal. Vertical table type will have header fields across the top. The horizontal table type will have header fields down the left side.
• Show borders on table: Borders  Borders can be included or not included in the table.
• Table Header Style: the  The style for the table heading cells.
• Table Cell Style: the  The style for the table value cells.
• Table Source: this  This defines what layer or database the data for the table will come from.
• Layer / Database queries: the  The layer or database query to use. Administrators can either set up a new layer query or use a pre-configured query if one has already been made. See below for details on each option.

Layer

Queries

To create a new layer query for a table, click New Query. 

Image Removed

A Layer Query window will appear. The following query details can then be configured:

• Query name: Name  Name of the layer query.
• Layer query type: This can be either a query based on common attributes (table queryTable Join) or spatial location (Spatial join). See below for details on each query option.
• Layer: the  The layer you want to display information from in the table.
• No results text: This is the text you would like to display when there are no results returned from the query. The text will appear below the table heading.

Table Join

If Table Join was selected as the layer query type, you can then set what fields will be displayed in the report. To include a field in the table, check the tick-box next to the applicable field. Number formats can be configured for number fields. If the number is currency this can also be enabled. To rearrange the order of how the fields are displayed in the report, simply click and drag the field row to a new position. 

Click Continue to move to the next step. Next, you can define the where clause Where Clause upon which the join is based on. The Left left drop-down defines what field in the query layer matches the report layer. The right drop-down, defines the field in the report layer that matches the selected layer. The lower text box identifies the Where clause Clause based on the fields chosen. Once complete, click Finish to save your new query layer.

.

Spatial Join

If a spatial join Spatial Join was selected as the layer query type, you will again be presented with fields to choose and then . After this, the following spatial query details will be presented upon clicking Continue. In this section, you can define the following details:

• Spatial relationship: the  The spatial relationship to the Report layer. Administrators can choose from Contains, envelope intersects, intersects, overlaps, touches or is within.
• Get intersected Area? Add a field to your table with a summary of the intersected area for a given feature eg e.g. Amount of Soil Type A in Parcel.
• Area Unit: Square Metres or Hectares.
• Use buffer on report layer feature? You can choose to use a buffer with the spatial query created for the table.
• Buffer Distance: Distance set for buffer.
• Buffer Units: Kilometre, Foot, Metre, Mile, Nautical Mile.

Once complete, click Finish to save the layer query. Upon click, a preview will appear in the left-hand panel. This preview will include the table name and a default table icon.

Image Added

Database Queries

To add a table to a report based on a database query, click on the “Add element” dropdown Add element drop-down and select “Table” Table. This will again open a table configuration panel on the right-hand side of the page. Fill this out with the table styling details. Under Table Source select Database. Next, click New Query.

Image Removed

The below “Data query” A Data query window will appear . This wizard will step you through setting up a data query.

Image Removed

The following query and the following query details can be configured:

• Query name – Name of the layer queryDatasource: The Database that contains the table you want to query.
• Query type – : This can be either a Table/View or a stored procedure.
• Table\View\Stored Procedure – the : The table, view or stored procedure in the database that you want to use in your table.
• Print template: The print template that will be used to create the map image.
• Include Group by clause– : Tick if would like to include a Group by clause ege.g. if the database table already has an aggregation field, you may wish to use this count in your feature query clause. 
• Tick if you would like to include an Include Order by clause. This : This will define the queries are ordered in the table.

Image Added

Click Continue to then define your Data query.

Image Removed

Here, you can set the following:

• Query name

• : The title that will appear in the Table.

• Select

• : This box will be populated as you create your query from the table fields.

• Fields

• : The fields you wish to display in the table.

Reorder how the fields are presented in the popup You can change the alias of fields by editing the appropriate text box. Fields can be reordered by clicking the dotted icon and dragging the field to a new position.

Set the relationship parameters:

Image Removed

Review Image Added

Next, define the Where clause by selecting a common field from the drop-downs. Continue to review your clause and save the new Feature query. This will then be added to the main table.
Note, if you wish to change your configuration set up at any stage in the wizard, simply click on the dot symbol above each step to go back (as per the above image).

Delete Report Queries

To delete any report queries that have been configured for existing reports, head to the Report Queries tab under Reporting. To delete a report query, click the corresponding Delete button on that row.

Image Added

Add Text

To add a section of text to a report, click on the “Add element” dropdown Add element and select “text” text. This will open a following text configuration panel on the right-hand side of the page. Once complete, click "Save" to add the text element to the report. The text box should appear in the Text element.Choose the Font style, enter your text and then hit Save. The text element will then be added to the main table.

Image Added

Delete a report

To delete a templatereport, simply click the corresponding “Delete” button of the template you wish to delete Delete button on the report row. Deletes will be confirmed by a green data update message box in the lower right corner. This will remove the template report from the list and it will no longer be an option to select from the “Report Templates” drop-down menu when adding a report.. 

Assign to a map

One or several reports can be assigned to a webmap map in LocalMaps. In the “Maps Maps & Apps” Apps page, under the “Reports” Reports tab, configured reports can be chosen a from the drop-down. A report will be available in the drop-down only if the report layer is present in the webmap map chosen.

Image RemovedImage Added

If the webmap map does not contain a report layer, the following message will be shown.

Image RemovedImage Added