We will introduce Cell Extensibility of FineReport reporting tool in this article.Cell extensibility is classified into:Vertical extensibility and Horizontal extensibility.

1. Overview

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:

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;

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;

2. Example

2.1 Open report

Open the report of %FR_HOME%\WebReport\WEB-INF\reportlets\doc\Primary\CrossReport\Cross.cpt

2.2 Design style

Combine cells B1 – D1, add a header to the Crosstab of the previous section, and set Center and add Background Color, as shown below:

2.3 Default cell extensibility

As shown in the effect graph below, despite the number of data Product extends horizontally, the report header will be automatically centered.

2.4 Set cell non-extensibilility

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

As shown in the effect graph below, the report header will not be stretched as the data extends horizontally.

For completed templates, refer to: %FR_HOME%\WebReport\WEB-INF\reportlets\doc\Primary\CrossReport\Cross_1.cpt

Click Cross_1.cpt to check template effect online.