Point Map

Version

Application Scenario

You are advised to use the point chart to locate the exact location by latitude and longitude when you want to check out the data of a specific location, which is more complicated to realize by using a map.

Three point map styles are available in FineReport, namely Location Map, Point Map, and Bubble Map. The display effects are as follows.

Location Map

Point Map

Bubble Chart

Chart Feature

Advantage: Combined with maps, the chart shows the geographic distribution of data clearly with accurate locations.

Disadvantage: Since multiple data is difficult to be distinguished in the point chart, the chart is not suitable for centralized display of multiple data.

The following example shows the basic setting of the point map.

Data Preparation

The Excel data provided here recording the latitude, longitude, and tourism heat of the 10 tourist attractions is only used as example data without real significance.

1. Click to download the data Point Map Data.xlsx and place the Excel file to %FR_HOME%webapps/webroot/WEB-INF/reportlets.

2. Create a general report, create a file dataset Scenic Spot Location, and select Excel from the drop-down list of File Type, as shown in the following figure.

The following figure shows the dataset data.

Note: 

The sample template uses the built-in dataset for the convenience of your viewing. 

Chart Insertion

1. Choose Template > Page Setting to adjust the paper size to display the map on one page.

2. Merge required cells, select the merged cell, click the icon, and choose Map > Point Map, as shown in the following figure.

Map Design

Select the chart, click the Cell Element icon on the right property panel, and set the attributes (Type, Data, Style, and Special Effect) for the chart.

1. Map Setting

Select Type, select China as Map Point, and set GIS Layer to Dark Blue.

Note: 

When the point map is used alone, GIS Layer is set to None by default, and the map does not show the boundary. You need to combine area maps with the point map and set GIS Layer of the area maps to None to display the fixed boundary.

Data Binding

Two methods to match geographic information are available when you bind data to the point map:

Area Name: You can match data in the dataset to area names on the map to show location points.

Lat/Long: You can display area names based on fields in the dataset by displaying position points by latitude and longitude. 

When using Area Name, you should note that an Area Name setting box will pop up after you click the setting icon on the right of Area Name. Area names in the dataset will be automatically fuzzily matched with the built-in area names in the map by default. You can customize the matching relationship if they are not matched. For example, if you select China as Map Point, you can match each province to the area name. For the data shown in this example, you should match each individual scenic spot to its province, as shown in the following figure.

This example uses the latitude and longitude positioning instead of area name matching. The following figure shows the setting in detail.

Label Setting

Choose Style > Label, tick Use Label, select Area Name as Text, and set Character to Theme. That is, the style and color of the text will be displayed in accordance with the theme.

Series Setting

Note: 

You cannot modify the color of the combination chart and the point map in FVS.

1. Choose Style > Series, and retain the default color setting.

2. Choose Mark Point > Point Style, and select Location Point, Dot, Bubble, or Custom Image.

Location Point Dot: You can set Height to 22 px (default value).

Dot: You can set Type and Radius for the dot.

Bubble: You can set Min Diameter, Max Diameter, Shadow, and Negative Bubble. The larger the data in the series is, the larger the bubble in the map will be.

Since the location map, scatter map and bubble map have been shown in section "Application Scenario", select Custom Image here. 

Upload the image, and customize Width and Height as needed.

Note: 

When you set Point Style to Custom Image, Flash Animation is not supported.

Effect Display

PC

Save the report and click Pagination Preview. The following figure shows the preview 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 Point Map.cpt

Customizing the Point Type by Adding Condition Attributes

Choose Special Effect > Condition Display, and add Condition Attribute1 to set Point Type according to the point type set under Style > Series > Mark Point. In other words, you can only modify point type set in Series by adding condition attributes.

For example, if you select Location Point Dot as Point Type under Style > Series, you can only modify the height of the location point by adding condition attributes, as shown in the following figure.

If you select Custom Image as Point Type under Style > Series, you can only change the custom image by adding condition attributes, as shown in the following figure. 

Note:

When you set Point Type to Custom Image, you can not change the color of mark point by adding the Color condition attribute. You can change the color of mark point by adding the Color condition attribute if you set Point Style to Location Point, Dot, or Bubble.