{"id":3651,"date":"2016-07-04T03:00:22","date_gmt":"2016-07-03T19:00:22","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3651"},"modified":"2019-10-14T16:18:12","modified_gmt":"2019-10-14T08:18:12","slug":"filter","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/product-functions\/filter.html","title":{"rendered":"Set Filter Attribute."},"content":{"rendered":"<p>This time we will introduce you about how to set cell filter information of FineReport <a href=\"http:\/\/www.finereport.com\/en\/\" target=\"_blank\"><span style=\"color:blue;\">business intelligence<\/span><\/a> in this article.<\/p>\n<h3>1. Filter<\/h3>\n<p>To set cell filter information in our <a title=\"FineReport BI and reporting tool report designer\" href=\"http:\/\/www.finereport.com\/en\/features\/report-designer\" target=\"_blank\">report designer<\/a>, 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:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201663009.png\" alt=\"\" width=\"741\" height=\"444\" \/><\/p>\n<p><strong>1.1 Parent cell condition<\/strong><\/p>\n<p>In default, set parent cell as the filter condition, which is applicable to parent and child cells from a same data column.<\/p>\n<p>Setting parent cell as the filter condition means that when the cell conditions are met, the parent cell conditions should be met at first.<\/p>\n<p>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.<\/p>\n<p><strong>1.2 Common conditions<\/strong><\/p>\n<p>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.<\/p>\n<p>For example, as shown above, set Shipping Fee Column &gt; RMB 100. In this case, only display order data with shipping fee over RMB 100.<\/p>\n<p><strong>1.3 Formula conditions<\/strong><\/p>\n<p>If you don\u2019t 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.<\/p>\n<p>As shown below:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201663010.png\" alt=\"\" width=\"748\" height=\"442\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[117],"yst_prominent_words":[2413,557,5585],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3651"}],"collection":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/comments?post=3651"}],"version-history":[{"count":4,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3651\/revisions"}],"predecessor-version":[{"id":8266,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3651\/revisions\/8266"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=3651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=3651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=3651"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=3651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}