{"id":3495,"date":"2016-06-02T03:00:34","date_gmt":"2016-06-01T19:00:34","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3495"},"modified":"2018-09-11T19:18:00","modified_gmt":"2018-09-11T11:18:00","slug":"finereport-cell-extensibility","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/06\/02\/finereport-cell-extensibility\/","title":{"rendered":"FineReport Cell Extensibility"},"content":{"rendered":"

We will introduce Cell Extensibility of FineReport reporting tool<\/span><\/a> in this article.Cell extensibility is classified into:Vertical extensibility and Horizontal extensibility.<\/p>\n

1. Overview<\/h3>\n

When data extend, they may extend a large area, which is unknown to cells on the left or top of the extended cells. For the sake of overall aesthetics of a report, it is desirable that the content of those cells will be displayed in the middle or on the left or right following the extension of data section. In this case, cell extension can be used to control the cell display effect. Cell extensibility is classified into:<\/p>\n

Vertical extensibility: When data are vertically extended from top to bottom, the vertical extensibility of cells on the left of extended cells can be set;<\/p>\n

Horizontal extensibility: When data are horizontally extended from left to right, the horizontal extensibility of cells on the top of extended cells can be set;<\/p>\n

2. Example<\/h3>\n

2.1 Open report<\/strong><\/p>\n

Open the report of %FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Primary\\CrossReport\\Cross.cpt<\/span><\/p>\n

2.2 Design style<\/strong><\/p>\n

Combine cells B1 \u2013 D1, add a header to the Crosstab of the previous section, and set Center and add Background Color, as shown below:<\/p>\n

\"\"<\/p>\n

2.3 Default cell extensibility<\/strong><\/p>\n

As shown in the effect graph below, despite the number of data Product extends horizontally, the report header will be automatically centered.<\/p>\n

\"\"<\/p>\n

2.4 Set cell non-extensibilility<\/strong><\/p>\n

Select the cell of B1, right click to select Extend Attribute, and set Extensibility as Horizontal Non-Extensible in the right Cell Attribute panel:<\/p>\n

\"\"<\/p>\n

As shown in the effect graph below, the report header will not be stretched as the data extends horizontally.<\/p>\n

\"\"<\/p>\n

For completed templates, refer to: %FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Primary\\CrossReport\\Cross_1.cpt<\/span><\/p>\n

Click Cross_1.cpt<\/span><\/a> to check template effect online.<\/p>\n","protected":false},"excerpt":{"rendered":"

We will introduce Cell Extensibility of FineReport repo…<\/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\/3495"}],"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=3495"}],"version-history":[{"count":1,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3495\/revisions"}],"predecessor-version":[{"id":3496,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3495\/revisions\/3496"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}