Chart Custom Data Table-FineReport Help Document

Last update： 2022-01-11

I. Overview

1. Application scenarios

For the data in the data table, some data are expected to be classified with fixed units, such as temperature, US dollar, etc., and some data are expected to be set with different colors according to profit and loss. The following is the corresponding results:

2. Idea to acheive

Under Chart > Special Effetcs > Condition Display, add conditional formatting of Data Table.

II. Examples

1. Prepare template

Open designer built in template %fr_Home%/webapps/webroot/WEB-INF/reportlets/doc-EN/Chart/combination/Column-Line_Chart.cpt

Column-Line_Chart.cpt

2. Set data

Select the chart, click Style > Data Tableon the right, check Display Data Table, select Data Format: Number, and do not modify specific properties:

2.2.png

3. Set condition properties

1) Column chart condition properties

Select the chart, click Special Effects > Condition Display on the right, select the Column chart, add Conditional Formatting, set the attributes as Data Table content, set the Data Format as Number, the character is green with unit mm, and the condition is series index = 1. Click Add to complete the conditional formatting1 editing.

On the right side, click Special effects > Condition display, select the Column chart, add Conditional Formatting, set the attribute as Data Table content, set the Data Format as number, the character is red with unit mm, and the condition is series index = 2. Click Add to complete the Conditional Formatting2 editing.

2) Line condition properties

On the right side, click Special Effects > Condition Display, select line chart and add Conditional Formatting. The attribute is set as Data Table content, Data Format is set as number, the character is blue with unit MB, and the condition is series index = 1. Click Add to complete the Conditional Formatting1 editing.

On the right side, click Special effects > Condition display, select Line chart and add conditional formatting. The attribute is set as Data Table content, Data Format is set as number, and the character is dark blue with unit ℃. The condition is series index = 2. ClickAdd to complete Conditional Formatting2 editing.