Condition Display in Charts

  • Last update:February 18, 2025
  • Overview

    Version

    Report Server VersionFunctional Change
    11.0/
    11.0.6Added 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."

    iconNote:
    Gauge does not support the condition display.

    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.

    iconNote:
    If you configure an attribute without setting the condition, the attribute will apply to all series or categories in the chart.

    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.

    iconNote:
    Data Table will only be displayed in Attribute in the condition attribute setting pop-up box when you tick Display Data Table under Style > Data Table of the column chart, line chart, or area chart with a single category axis.

    3.png

    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.

    7.png

    iconNote:
    When Operator is set to Equal to or Not Equal to, the condition must use the formula =ARRAY("Major Category","...","Finest Category").

    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.

    iconNote:
    Only FineReport 11.0.6 and later versions support Summary Field Value. For details about it, see section "Summary Field Value."

    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.

    iconNote:
    For box plots, the setting of opacity in condition attributes only takes effect for graphic fill.

    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.

    iconNote:
    In charts that do not support Summary Field Value or with the chart data source set to Cell Data, if you select Summary Field Value, you will find no fields in the drop-down list.

    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 DocumentApplication ScenarioEffect
    Gradient Column ChartSet the Color attribute of the category to gradient colors to achieve a gradient effect for a single column.22.png
    Setting Flash Animations for ChartsObtain the maximum and minimum values of the series in line charts by formulas, change the colors, and add flash animations.
    Chart Custom Mark Point StyleYou 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.24.gif
    Chart Custom Category ColorWhen 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 FillingYou can fill the graphics of some charts with images, enriching the display forms of charts.  
    Chart Custom Single Series LabelSet labels for a single or multiple series and categories separately.27.png
    Chart Custom Data TableFor 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.28.gif
    Series Value Comparison and Highlighting in a ChartFor 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.29.png
    Composition Waterfall ChartSet the color to transparent or set the opacity to hide the series below in stacked charts, thereby realizing a floating effect.


    Attachment List


    Theme: Chart
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy