Custom Drill Map

Version

Application Scenario

Compared to a regular map, the drill map can drill down into data interactively. You can click the level to drill down into data at different levels (country, province, city, and district).

As a kind of drill maps, Custom Map allows you to flexibly set different map types (the area map or point map) for different drilling levels to meet the needs in different scenarios.

The following figure shows the effect.

Function Description

Different from Drilling Area Map and Drilling Point Map, Custom Map allows you to set Display Type in Drill Level of the custom drill map to Area Map or Point Map,as shown in the following figure.

The example would be simple and meaningless if it just displays different effects of Custom Map after you set different display types.

Therefore, combined with Map Configuration, this document explains the effect of drilling down into data at the provincial level from the data at the administrative region level, then to the city level.

Map Configuration

In the designer, choose Server > Map Configuration, log in to the decision-making platform, and wait until you are redirected to the map configuration page.

Geographic Information Copying and Modification

Note:

In FineReport earlier than version 11.0.6, you need to manually trace the edges to customize the map boundary. For details, see Custom Drill Map (version 10.0). 

FineReport  11.0.6 and later versions have the built-in map boundary China(region) . The map boundary exists as a separate directory file with no subordinate directories, and cannot be used for drilling.

Therefore, you need to add subdirectory files for the built-in map boundary to show each area separately. Take East China as an example, and the operation steps are as follows:

1. Hover the cursor over the directory China, click the Copy icon, change the file name to East China in the pop-up setting box, and select China(region) as the parent directory.

Note: 

The parent directory cannot be moved after selection. If you select the wrong parent directory, you can copy the subdirectory file again to another directory.

2. After adding subdirectory files, click the Delete icon in the toolbar of the map display page to delete the provinces outside of East China, click Finish, and click Save in the upper right corner. 

Note: 

Deletion operation cannot be undone. After deletion, you must click Save in the upper right corner, and then click another directory, otherwise the previous operation will be invalid.

You can set for the rest of the area in the same way.

Similarly, you can select the province directory file and copy it to the corresponding area in the directory China. Only the information of provinces inside of East China area has been copied in this example, as shown in the following figure. 

JSON File Storage Path

After the geographic information configuration, the JSON file is automatically saved to %FR_HOME%\webroot\WEB-INF\assets\map\geographic\world, as shown in the following figure. 

Click to download the configured geographic information: China Administrative Regions.zip, unzip it and put the whole folder directly to the above path. Then, open the Geographic Configuration page of the decision-making system, click Synchronize Geographic Files in the upper right corner, and then you can use the information directly in the designer.

Report Design

Data Preparation

Choose File > New General Report in the upper left corner of the designer, and create two datasets. 

1. Create a database query ds1 with the SQL query statement SELECT * FROM Map, as shown in the following figure.

2. Create a built-in dataset Area Sales, and set it as shown in the following figure.

Chart Insertion

Merge required cells, click the Insert Chart icon on the upper toolbar, choose Drill Map > Area Map, and click OK, as shown in the following figure.

GIS Layer Setting

Click Type on the right properties panel, select Custom Map as the type of the drill map, select China as Map Boundary, and set GIS Layer as Black in Standard, as shown in the following figure.

Data Binding

1. Choose Data > Drill Level, set Zoom Level to Auto for all levels, and select Area Map as Display Type for No.1Level, Area Map as Display Type for No.2Level, and Point Map as Display for No.3Level, as shown in the following figure. 

2. Choose Data > Data, select Separate Designation Per Level, and bind the data to each level, as shown in the following figure.

Note:

1. As the display type of No.3Level is set to Point Map, you can select two different methods for geographic information.

2. Fuzzy matching is used for Area Name. For more details, see the documentation details Map Fuzzy Matching. 

Effect Display

PC

Save the template and click Pagination Preview. The section "Application Scenario" shows the effect.

Mobile Terminal

The report can be previewed on both the DataAnalyst app and the HTML5 terminal. The following figure shows the effect.

For details, you can download the template Custom Drill Map.cpt