{"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:\/\/frg.fineres.com\/en\/2016\/07\/04\/filter\/","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 f&#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],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3651"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=3651"}],"version-history":[{"count":5,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3651\/revisions"}],"predecessor-version":[{"id":8266,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3651\/revisions\/8266"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}