{"id":3784,"date":"2016-07-18T03:00:51","date_gmt":"2016-07-17T19:00:51","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3784"},"modified":"2019-10-14T16:18:16","modified_gmt":"2019-10-14T08:18:16","slug":"hide-rows-and-columns","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/product-functions\/hide-rows-and-columns.html","title":{"rendered":"How to hide the rows and columns you don&#8217; t want to display?"},"content":{"rendered":"<p>We will introduce how to hide rows and columns in FineReport <a href=\"http:\/\/www.finereport.com\/en\/\" target=\"_blank\">reporting tool<\/a> in this article.<\/p>\n<p><strong>1. Description<\/strong><br \/>\nSome cells 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> are only for intermediate operations, which are not to be displayed. You can hide the cell value or hide the entire row or column in the report designer.<\/p>\n<p><strong>2. Hide rows and columns by direct setting<\/strong><br \/>\nRight click the row or column in report designer tab to be hidden. Select Row Height or Column Width in the pop-up menu and set them to 0. Or, directly right click Hide.<br \/>\n<img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201671320.png\" alt=\"\" \/><\/p>\n<p><strong>3. Hide rows and columns by setting row height and column width as 0 in the Condition Attribute<\/strong><br \/>\nSometimes, we need to display rows and columns in report designer when certain conditions are met; and hide them in other cases. To realize this, you can set row height and column width in the Condition Attribute.<br \/>\nRight click the cell and select <span style=\"color: purple;\"> Condition Attribute<\/span>. Add Condition Attribute. Click the attribute to be changed at the right top corner to pop up a drop-down button. Select column width (default: 0), and click OK.<\/p>\n<p>If the current value is 0 or is null, and the column width is 0, set the Condition Attribute as follows:<\/p>\n<p><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201671321.png\" alt=\"\" \/><\/p>\n<p><strong>4. Unhide<br \/>\n<\/strong>To display hidden row(s) or column(s), select the rows above and below the hidden row(s) or the columns adjacent to either side of the hidden column(s), and right click to select Unhide.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We will introduce how to hide rows and columns in FineReport reporting tool in this article. 1. Description Some cells in our report designer are only for intermediate operations, which are not to be displayed. You can hide the cell value or hide the entire row or column in the report designer. 2. Hide rows&#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":[],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3784"}],"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=3784"}],"version-history":[{"count":7,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3784\/revisions"}],"predecessor-version":[{"id":8293,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3784\/revisions\/8293"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=3784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=3784"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=3784"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=3784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}