Chart Data Source Compatibility Plugin

Version

Application Scenario

As the data retrieval logic for chart data sources has been reconstructed in FineReport 11.0, when you open old templates created with version 10.0 using the 11.0 designer, the chart effects may change. In this case, you can use Chart Data Source Compatibility Plugin to switch the chart data retrieval logic to that of the old version.

Plugin Installation

If the designer is upgraded from an old version to 11.0, the plugin is installed by default. If FineReport 11.0 is directly downloaded and installed, you need to download and install the plugin by yourself.

You can click to download the plugin: Chart Data Source Compatibility.

For details about how to install the plugin in the designer, see Designer Plugin Management.

For details about how to install the plugin on the server, see Server Plugin Management.

Function Description

1. After you install the plugin, a configuration item Chart Data Source Compatibility is added in the drop-down list of Template. Whether you open an old template or create a new template, Logic to Extract Data from Data Source is set to New Version by default to switch the template with changed effects to Old Version.

2. The switch for Logic to Extract Data from Data Source takes effect on all chart objects under the current template.

Multi-category Chart Data Filter

For example, there is a column chart with multi-category axes, and the effect is shown in the following figure.

You can filter the first two data of the category and merge the remaining items as Others. The following figure shows the effect.

Extracting Cell Data

For details about the requirements for using cell data sources in the 11.0 designer, see Cells as Chart Data Sources.

The parent-child relationship of cells has a significant impact on the chart effects, and the chart will be displayed according to the parent-child relationship of cells.

For example, there is a group of data, which is shown in the following figure.

Binding the dataset data to the column chart, and the method and effect of binding data are shown in the following figure.

When you bind the cell data, for January, February, and March in the table are inserted as plain text, they do not have an expansion direction or a parent-child relationship by default.

The old logic to extract data of version 10.0 supports directly to reference continuous cell data, but the new logic to extract data of version 11.0 will cause abnormal chart display due to the lack of parent-child relationship between categories and values, as shown in the following figure.

So in version 11.0, two solutions are available.

1. Manually modify the parent-child relationship of the cells, set the upper parent cell of the B2, C2, and D2 cells where the values are located to B1, C1, and D1 respectively, and set the left parent cell to cell A2.

2. When binding data, add multiple series values, as shown in the following figure.