Chart Custom Data Table-FineReport Help Document

Last update：February 17, 2025

Overview

Application Scenario

For the data in the table, you want some data to be displayed with specific units (such as temperature or dollars) based on the categories. Also, you want some data to be displayed in different colors based on the profit or loss. The following figure shows the corresponding effects.

--电脑预览.gif

Implementation Method

You can achieve the effect by adding condition attributes for the data table type under Special Effect > Condition Display.

Example

Data Setting

Select the chart and choose Style> DataTable on the right side. Select Display Data Table and select Number as Data Type. Keep the other attributes unchanged.

image 17.png

Condition Attribute Setting

1. Condition Attribute for Column Chart

Select the chart and choose Special Effect > Condition Display on the right side. Select Column Chart and add a condition attribute. Select Data Table as Attribute, select Number as Data Type, set green and with unit mm for the character, and set Common Condition as Series Index Equal to 1. Click Add to complete the editing of Condition Attribute 1.

image 18.png

Choose Special Effect > Condition Display on the right side. Select Column Chart and add a condition attribute. Select Data Table as Attribute, select Number as Data Type, set red for the character, and set Common Condition as Series Index Equal to 1. Click Add to complete the editing of Condition Attribute 2.

image 19.png

2. Condition Attribute for Line Chart

Choose Special Effect > Condition Display on the right side. Select Line Chart and add a condition attribute. Select Data Table as Attribute, select Number as Data Type, set blue and with the unit mb for the character, and set Common Condition as Series Index Equal to 1. Click Add to complete the editing of Condition Attribute 1.

image 20.png

Choose Special Effect > Condition Display on the right side. Select Line Chart and add a condition attribute. Select Data Table as Attribute, select Number as Data Type, set dark blue and with the unit ℃ for the character, and set Common Condition as Series Index Equal to 2. Click Add to complete the editing of Condition Attribute 2.