Data Column Attributes

Version

Functions

Select the cell if it is a Data Column. The attribute settings of the data column attributes will occur on the right side. You can also double-click the cell, and the attribute setting box will pop up.

The basic attribute settings of a data column include: Select Data Column, Parent Cell Setting, Data Setting, and Expansion Direction.

Select Data Column

Select Data Column specifies binding the fields in the dataset to cells and selecting data columns through a drop-down list.

Parent Cell Setting

Parent Cell Setting specifies the parent and child cell setting, which can be set in both Cell Attributes > Expand and Data Column > Basic. The operation methods are the same.

Data Setting

Data Setting specifies the modification of data display modes.

 Expansion Direction

 Expansion Direction specifies Expansible in Advanced. There are three kinds of expansion directions: V, H, and No Expansion.

Select the cell, choose Filter Condition > Edit in Cell Element on the right side or double-click the cell and choose Filter to set the filter conditions for the cell.

The Conditions of Parent Cell

Use parent cell as filter condition (Parent and child cell are from same dataset) is ticked by default.

Setting the parent cell as a filter condition specifies that the parent cell must be used as a condition first in addition to satisfying the current cell condition and the child cell will inherit the parent cell's filter condition. That is to say, if the parent cell has been set a filter, the child cell does not need to be set the filter with the same condition again.

Common Condition

1. Common Condition specifies defining filter conditions for the data column of the dataset where a cell locates. Only when a certain data column meets the conditions, will the data in the current cell be selected.

The filter conditions consist of Available Columns, Operator, and conditions. You can set as needed. Available Columns are all data columns of the dataset where the data column of the current cell is located. Operator specifies some textual operators. Conditions support multiple forms. ..

2. When you create a report, if you need to keep certain data columns in the dataset without column names (empty field names), these data columns can be displayed in the report normally. However, if the filter condition is invalid after you have set conditions for the field whose name is empty and that needs to be filtered, you can set Column Index as the condition for Available Columns.

3. Conditions also include formulas (common), cells (common), parameters (common), and data columns (data columns in all available datasets of the current template), in addition to the data type such as strings, integers, and dates. Selecting data columns specifies that the condition values that need to be met are all values in the data columns. When there are multiple condition values, they will be filtered by multiple values.

Formula Condition

If you do not need to add filter conditions for a data column, or if you need to perform operations on the data column before setting the filter conditions, you can use Formula.

Click Define and the formula editing interface appears.

Select the cell, choose Advanced in the Cell Element panel on the right side of the report body (or double-click the cell and choose Advanced) to perform advanced settings for the cell.

Sort

Set the sorting order for data columns. There are three orders: Ascending Order, Descending Order, and Unsort.

Result Set Filter

Set the display of a result set, such as Top N, Last N, Odd, Even, and Specify.

If Result Set Filter and Sort are used at the same time, the data will be first sorted and then filtered.

Custom Displays

Customize to display the value of a cell. For example, enter FineReport formulas to modify the display value of the cell. The default value is $$$, which represents the value of the cell itself.

1. The data stored in the database is FR FanRuan. Drag the data column to cell A1.

2. Double-click cell A1, choose Advanced, and insert the formula replace($$$, "FR", "FineReport") in Custom Displays to replace FR with FineReport.

3. Save the template and click Pagination Preview. The data is displayed as FineReport FanRuan.

Note:

The cell value referenced is the displayed custom value, not the original actual value. For example, the actual value of cell A1 is FR FanRuan, while the displayed custom value is FineReport FanRuan. The value referenced by cell B1 from cell A1 is FineReport FanRuan.

Expansible

Expansible is divided into Expansible(H) and Expansible(V).

Fill Blank Data

Supplement blank data. You can set Line Numbers. For example, set Line Numbers to 10. Then the data that is less than 10 records will be automatically supplemented to 10 with blank records. ..

Format

Set formats for numbers and dates in a cell. For details, see Data Display Format.