In report designer, there are three split column ways: No split column, split column in row and split column in column.

Click menu Template > Report Split Column to pop up Report Split Column interface, as shown below:

There are three split column ways in our Finereport BI: No split column, split column in row and split column in column

No split column

Input =range(100) formula in the cell to display numbers from 1 to 100.

In the case of no split column, data will appear in vertical arrangement, as shown below (only show the first 28 numbers):

Split column in row

In split column in row, if split column data goes beyond fixed row, it will be displayed in another column. For example, we set 5-row split column, as shown below:

Note: Split column data only has one cell and should be written as A1:A1 form.

Split column effect (only show the first 45 numbers):

Note: If the split column is set to X columns, each column will display {(Total rows)/X} round up to an integer.

For detailed examples about split column in row, refer to Split Column in Row.

Split column in column

In split column in column, if data goes beyond fixed column, it will be displayed in another column. The setting is similar to split column in row, which will not be repeated again. For detailed examples about split column in column, refer to Split Column in Column.