Overview
Version
Report Server Version | Functional Change |
---|---|
11.0 | / |
11.0.6 | Added a condition option Summary Field Value. For details, see sections “3. Available Condition” and "Summary Field Value." |
Application Scenario
When creating charts, you may want to highlight certain special data, for example:
1. Set the maximum and minimum values of a series to different colors.
2. Set the color of columns with the value greater than 0 to red and those smaller than 0 to green.
3. Display the line chart and the column chart in a combination chart with two different colors.
4. Set a flash animation for the last column in a column chart.
In these cases, you have to set condition attributes for charts to meet these special needs. For details about more examples, see section "Index."

Function Description
Procedure
1. Select the chart, choose Special Effect > Condition Display, and click the Add icon to add conditions on the attribute panel.
2. In the condition attribute setting pop-up box, select the attribute to be set.
3. Add conditions. You can use AND or OR to add and combine multiple conditions.

The following figure shows the operation steps.
If you add multiple condition attributes, they will be executed from the first one to the last. In the case of conflicts, the latter condition attribute takes precedence.
Attribute
Attributes supported by condition display vary depending on different chart types, generally determined by the style settings available for the chart. For example, the bubble chart has the attribute of bubble while other charts do not.
Taking the column chart as an example, the following chart shows its basic attributes.

Condition
1. Available Column
When setting condition attributes for charts, available columns will also change with chart types. For example, the following figure shows available columns for column charts.
Among them, Category Index, Category Name, Series Index, and Series Name refer to the categories and series bound to the chart, and Value refers to the corresponding values of the series, as shown in the following figure.
Category Array applies to a multi-category axis and allows you to add conditions for a specific category array. For example, Category Array contains a certain field.

2. Operator
Operators include Equal to, Not Equal to, Greater than, Greater than/Equal to, Less than, Less than/Equal to, Begin With, Not Begin With, End With, Not End With, Contain, Not Contain, In, and Not In.
3. Available Condition
The following figure shows the available conditions. You can select the corresponding type as needed.

Special Notes
Color
When you set the color to transparent in condition attributes, the corresponding graphic fill, chart legends, traction lines, labels will also be displayed as transparent.
For example, when the label character is set to Theme and the label border is set to None by default, if you set Color to Transparent in the condition attribute, the corresponding graphic fill, legend, traction line, label, and label border will all be displayed as transparent, as shown in the following figure.
Opacity
1. For charts with general legends, the setting of opacity in condition attributes takes effect for the colors of graphic fill, legends, and labels, as shown in the following figure.

2. For charts with legends displaying data ranges, the setting of opacity only takes effect for the colors of graphic fill, but does not take effect for the legends, as shown in the following figure.
3. If you use Image Fill in charts, the setting of opacity will not take effect, as shown in the following figure.
Unsupported Comparison Between the Value and the Data Column
Value in the available columns is of the int type while Data Column in the dataset is of the array type. You cannot compare them since they specify the containment relationship.
Therefore, you cannot use operators such as Equal to, Less than, and Greater than. You can only use Contain, Not Contain, In, and Not In, as shown in the following figure.
Requirements for the Chart Category in Condition Display
Whether the chart has a single category axis or a multi-category axis, the setting of thecondition display for Category Name only takes effect to the finest category. For a multi-category axis, you can use the setting of Category Array. For details, see the section "Available Column."
Requirements for Condition Display After Setting the Display for Categories and Series
If you set Display when binding the data to charts, you have to use the display value instead of the actual value when setting the condition display, as shown in the following figure.
Requirements for Conditional Attribute Settings in Gantt Charts
When a Gantt chart has multiple projects, to specify a certain subproject, you can add the condition Project Equal to Task A/Function Development, as shown in the following figure.
Summary Field Value
In FineReport 11.0.6 and later versions, the condition option Summary Field Value is added to the chart condition display.
Summary Field Value is only supported in pie charts, column charts, bar charts, line charts, area charts, radar charts, and related charts in combination charts with the chart data source set to Dataset Data.

Significance of using Summary Field Value in conditions: You can compare the values of graphics with the summary values of other fields for the same graphics based on a one-to-one mapping relationship between values.
For example, the following figure shows the dataset and condition attributes in Series Value Comparison and Highlighting in a Chart.
The following figure shows the preview effect. The series values of Quality Score of each product are compared with the corresponding minimum standard scores. For products whose quality scores are lower than the corresponding minimum standard scores, the corresponding columns are highlighted in red.
Index
Help Document | Application Scenario | Effect |
---|---|---|
Gradient Column Chart | Set the Color attribute of the category to gradient colors to achieve a gradient effect for a single column. | ![]() |
Setting Flash Animations for Charts | Obtain the maximum and minimum values of the series in line charts by formulas, change the colors, and add flash animations. | ![]() |
Chart Custom Mark Point Style | You can set the Mark Point attribute in line charts, point maps, etc. to highlight special points and use Image Fill to make the graphics more vivid. | ![]() |
Chart Custom Category Color | When column charts have multiple categories and only one series, the series is displayed in only one color. In this case, you can change the colors of categories by condition attributes. | ![]() |
Chart Custom Series Filling | You can fill the graphics of some charts with images, enriching the display forms of charts. | ![]() |
Chart Custom Single Series Label | Set labels for a single or multiple series and categories separately. | ![]() |
Chart Custom Data Table | For column charts, line charts, and area charts with a single category axis, if you tick Display Data Table under Style > Data Table, the Data Table configuration will be added to condition attributes. | ![]() |
Series Value Comparison and Highlighting in a Chart | For combination charts or charts with multiple series, you can compare values among different series and highlight the values that meet certain conditions by the condition display. | ![]() |
Composition Waterfall Chart | Set the color to transparent or set the opacity to hide the series below in stacked charts, thereby realizing a floating effect. | ![]() |