{"id":3648,"date":"2016-07-04T03:00:40","date_gmt":"2016-07-03T19:00:40","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3648"},"modified":"2019-10-24T16:23:52","modified_gmt":"2019-10-24T08:23:52","slug":"advanced","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/07\/04\/advanced\/","title":{"rendered":"How to Set Advanced Attribute?"},"content":{"rendered":"<p>We will introduce how to set advanced attributes of a cell of FineReport <a href=\"http:\/\/www.finereport.com\/en\/\" target=\"_blank\"><span style=\"color:blue;\">business intelligence tool<\/span><\/a> in this article.<\/p>\n<h3>1. Advanced<\/h3>\n<p>To set advanced attributes of a cell in <a title=\"FineReport BI and reporting tool report designer\" href=\"http:\/\/www.finereport.com\/en\/features\/report-designer\" target=\"_blank\">report designer<\/a>, click the Advanced button at the right top of data column cell, or double click cell and select Advanced, as shown below:<\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201663006.png\" alt=\"\" \/><\/p>\n<p><strong>1.1 Sort<\/strong><\/p>\n<p>You can sort data columns in ascending order, descending order or no order. For details, refer to <span style=\"color: blue;\">Advanced Sort<\/span>.<\/p>\n<p><strong>1.2 Result set screening<\/strong><\/p>\n<p>You can set display of result sets, like display the previous N, and last N sets. For details, refer to <span style=\"color: blue;\">Result Set Screening<\/span>.<\/p>\n<p><strong>1.3 Custom display<\/strong><\/p>\n<p>You can custom display value. For example, input FR formula and change the cell display value. The data saved in data column are FineReport software, as shown below. To display FR to its full name FineReport, click <span style=\"color: purple;\">Data Column &gt; Advanced<\/span> and replace FR with FineReport in Custom Display through function.<\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201663007.png\" alt=\"\" \/><\/p>\n<p>Save the template and click page break preview. You can see that this data column is displayed as FineReport Software at web side.<\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201663008.png\" alt=\"\" \/><\/p>\n<p><span style=\"color: red;\">Note: Custom Display only changes the display value. The actual value in database remain unchanged.<\/span><\/p>\n<p><strong>1.4 Extensibility<\/strong><\/p>\n<p>Data extensibility can be divided in to horizontal extensibility and vertical extensibility. For details, refer to Cell Extension;<\/p>\n<p><strong>1.5 Supplement blank data<\/strong><\/p>\n<p>To supplement blank data, you can set data multiples. For example, if data multiples is set as 10, data less than 10 pieces will be supplemented to 10 pieces.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We will introduce how to set advanced attributes of a c&#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\/3648"}],"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=3648"}],"version-history":[{"count":8,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3648\/revisions"}],"predecessor-version":[{"id":8530,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3648\/revisions\/8530"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}