Map Automatic Refresh

Version

Application Scenario

FineReport supports the monitor refresh function. The frontend data can be updated in real time according to the dynamic changes of the backend data.  Taking the point map as an example, the effect is shown in the following figure.

Note:

When the chart data does not change, the frontend chart will not have a refresh animation effect, except for the tree structure chart, rectangular tree chart, multi-layer pie chart, Gantt chart, and framework chart.

Function Entry

Choose Special Effect > Interaction on the chart property panel, and you can enable Background Detection in Monitor Refresh, which is disabled by default, as shown in the following figure.

Chart Insertion

Merge required cells, click the Insert Chart icon on the upper toolbar, select Point Map, and click OK, as shown in the following figure.

Data Preparation

Create a general report and add the dataset named ds1. The SQL statement is as follows:

SELECT pid as PID,Sales_volume as Sales,${int(RAND()*100000)}+ Sales_volume as 'New Sales' FROM Map where pid is not null and pid not in('Tianjin City') order by random() limit 5

Chart Data Setting

Select the chart, and select Data on the right property panel to bind the data of the point map, as shown in the following figure.

Chart Style Setting

Select the chart, choose Style > Series on the right side, select Custom Gradient Color as Color Scheme, and select Dot as Point Style, as shown in the following figure:

Chart Special Effect Setting

Select the chart, choose Special Effect > Interaction > Monitor Refresh, set Time Interval to 5s, select Auto Tooltip, and set Content and Duration in the pop-up box, as shown in the following figure.

Effect Display

PC

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

Mobile Terminal

The template 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 Auto Map Refresh.cpt.