Flow Chart with Big Data

When the data volume is very large, reaching 10,000 records, the chart loading will be lowered with less appealing display effect. The following figure takes a flow chart as an example.

FineReport provides the big data optimization function for better chart display effects and faster chart display when the data volume is very large. The following figure shows the effect.

Data Preparation

Create a general report and create a file dataset File1, as shown in the following figure.

The File1 file records the origin and destination information. You can download the file: File1.xlsx.

Chart Insertion

Merge required cells and insert a flow chart in cell A1, as shown in the following figure.

Data Binding

Select Data on the chart property panel, select the dataset File1 as the data source, select Lat/Long as the geographic information, set the latitude and longitude of the start point and end point, set the area name, and select Field Name in Series Name, as shown in the following figure.

Style Setting-Series

Follow the steps in the following figure to set the color scheme and curve of the series and enable Big Data Mode. In the example, the line width is set to 0.5px (the thinnest value), and the opacity is set to 10%. You can adjust these settings as needed.

Effect Display

Save the report and click Pagination Preview. The following figure shows the preview figure.

Note:

The preview effect is supported on mobile terminals. Since the display effect is not ideal, you are not advised to preview the effect on mobile terminals.

The completed template can be found in: %FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Chart\Flow Chart With Big Data.cpt

For details, you can download the template: Flow Chart with Big Data.cpt.