This time we will introduce you about how to set cell filter information of FineReport business intelligence in this article.

1. Filter

To set cell filter information in our report designer, select the cell and select the Filter button in the Attribute box at right top of report body; or double click the cell and select Filter, as shown below:

1.1 Parent cell condition

In default, set parent cell as the filter condition, which is applicable to parent and child cells from a same data column.

Setting parent cell as the filter condition means that when the cell conditions are met, the parent cell conditions should be met at first.

Child cell will inherit filter conditions of parent cell. If the parent cell has set the filter, it is no longer necessary to set same conditions for the child cell.

1.2 Common conditions

Common conditions mean to define filter conditions for the data columns of the data set. Only when a data column meets conditions, the data can be selected.

For example, as shown above, set Shipping Fee Column > RMB 100. In this case, only display order data with shipping fee over RMB 100.

1.3 Formula conditions

If you don’t want to add filter conditions for the data column, or if you want to set filter conditions after operating the data column, you can use formula conditions.

As shown below: