Datasets as Chart Data Sources

Version

Application Scenario

When the chart data is sourced directly from a dataset, select Dataset Data as Data Source, select the corresponding dataset, and bind the data to the chart.

When binding data, you can select Field Value or Field Name as Series Name to define the chart. The difference is that they are based on different data table structures, as shown in the following figure.

Note:

Each field specifies a column in a database table, Field Name specifies the column name, Field Value specifies the records in the column, and Series Name specifies the chart legend in FineReport.

The charts obtained from the above two tables using different methods are consistent, as shown in the following figure.

Data Preparation

Create a general report with two built-in datasets added on the dataset management panel. The table structure and data are the same as that shown in the figure in section "Application Scenario."

Chart Insertion

Merge required cells to form two areas and insert a column chart into each. Modify the titles of the two charts to Field Values as Series and Field Names as Series respectively under Style > Title, as shown in the following figure.

Data Binding

Field Values as Series

Select the Field Values as Series dataset and select Region as Category (namely regions on the X axis). Select Field Value as Series Name, and select Product as Series (namely values of Product, Peanut and Milk, as legends). Select Sales as Value, and select Sum as Summary for the value (namely, product sales on the Y axis), as shown in the following figure.

Note:

Category or Series can be set to None. When Category is set to None, the series name is displayed on the X axis. When Series is set to None, each value is displayed as the series name.

Field Names as Series

Select the Field Names as Series dataset and select Region as Category (namely regions on the X axis). Select Field Name as Series, and select Peanut and Milk as Field Name (namely, field values Peanut and Milk on the Y axis). Field Name can only be set to the default series name, but Series can be manually modified. Select Sum as Summary, as shown in the following figure.

Effect Display

PC

Save the template and click Pagination Preview. The following figure shows the preview effect on the PC.

Mobile Terminal

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

Chart Data Display Order

When data is displayed in the chart, the order of categories is subject to the order of fields in the dataset.

For example, in the dataset, as the field value Asia comes before Europe, Asia displayed as category one is followed by Europe   displayed as category two.

The order in which series are displayed is subject to whether Series Name is set to Field Value or Field Name.

1. Field Values as Series

When you set Series Name to Field Value, the display order of series is subject to the order of fields in the dataset, as shown in the following figure.

2. Field Names as Series

When you set Series Name to Field Name, the display order of series is subject to the order of field names during data binding, as shown in the following figure.

You can download the template Datasets as Chart Data Sources.cpt.