Transferred Parameters as Map Boundaries-FineReport Help Document

Last update：February 08, 2025

Overview

Sometimes you want to display the corresponding data only for the selected map based on the parameters selected from the drop-down list. For example, if you select Fujian Province, the map of Fujian Province will be highlighted, as shown in the following figure.

Note:

This solution does not support Scene Map in FVS.

Example

Data Preparation

Create a workbook, and add dataset ds1 by entering the SQL statement SELECT * FROM Map, which records sales data for various provinces and cities in China, as shown in the following figure.

image 48.png

Chart Insertion

Take the cell chart as an example. Merge required cells, insert Area Map, and select Standard > Null as GIS Layer, as shown in the following figure.

Note:

Map Border need to be set after completing the parameter setting in section 2.4.

image 49.png

Chart Data Binding

Bind the data to the chart. The following figure shows the detailed setting.

image 50.png

Parameter Setting

1. You want to select the corresponding province through the drop-down list and dynamically display the corresponding province's map. Choose Template > Template Parameter and create parameter $province, as shown in the following figure.

image 51.png

2. Add the parameter to the parameter panel. Select Drop-down as the type of the province parameter control, as shown in the following figure.

image 52.png

3. Select the map and choose Cell Element > Type on the right property panel. Select province that was just added under the template parameters for Map Border, as shown in the following figure.

image 53.png

4. The value corresponding to the parameter is the file path in the geographic directory where the map file is located %FR_HOME%\webapps\webroot\WEB-INF\assets\map\geographic.

For example, province= "geographic/world/China/Jiangsu Province" corresponds to world/China/Jiangsu Province.json in the map directory.

Create dataset ds2. The SQL statement is SELECT distinct pid,'geographic/world/China/'||pid as newpid FROM Map where pid is not null, as shown in the following figure.

image 54.png

5. Set Data Dictionary for the province drop-down box widget, where Actual Value is newpid (corresponding to the province map within the map), and Display Value is pid (province name), as shown in the following figure.

image 55.png