Line Chart with Big Data

A large amount of data (reaching 10,000 records) will lower the chart loading and affect the display effect. The following figure takes a line chart as an example.

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

Data Preparation

Create a general report, and create a built-in dataset named ds1, as shown in the following figure.

Chart Insertion

Merge required cells, and insert a line chart, as shown in the following figure.

Data Binding

Click Data in the Cell Element, and select the dataset ds1 for Data Source, Number for Category and Field Name for Series Name. 

Style Setting

1. Series Setting

Follow the steps shown in the following figure to set Color Scheme and Line in Series, and enable Big Data Mode. Custom Combination is used as an example here, which can be adjusted by yourself.

2. Axis Setting

Set X Axis, set Type to Value Axis, and set CustomMaximum Value and Custom Main Unit, as shown in the following figure.

Effect Display

1. PC

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

Note:

When Type in Axis is set to Category Axis, the category order will be changed. When Type in Axis is set to Time Axis or Value Axis, the frontend display effect will not be affected.

2. Mobile Terminal

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

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

You can download the example template.  Line Chart with Big Data.cpt