Smart-Adding a Cell Group

Application Scenario

When designing data entry tables, you may fill in data in the same column (composed of multiple fixed cells) such as Opening Balance and Ending Balance in the following figure, rather than expand cells by dragging dataset fields into the table.

In this case, you can bind cells (in which the same field needs to be filled in) together through the Smart Add Cell Group function and then submit data.

Function Description

You can bind multiple cells (namely the cell group) to a single data table field in a built-in SQL database of FineReport. The cell group will be split into multiple built-in SQL databases when you submit data. The following figure shows how to use the Smart Add Cell Group function. You can select multiple consecutive cells by dragging the cursor. Alternatively, you can select non-consecutive cells by clicking them separately.

Note:

When you bind multiple cells through the Smart Add Cell Group function, data in the to-be-bound cells cannot be expanded.

Data Preparation

Create a data query dataset named ds1 and enter the SQL statement SELECT * FROM SubjectBalance. Click the Preview icon, as shown in the following figure.

Table Design

Enter the first eight subject codes and accounting subjects in the dataset into cells and add text widgets for cells in Opening Balance and Ending Balance for data entry, as shown in the following figure.

Data Entry Attribute Setting

Add four fields in the dataset and add cell groups, as shown in the following figure.

Effect Display

Save the report and click Data Entry Preview. Enter the opening balances and ending balances of the first four data records, as shown in the following figure.

After successful submission, you can view that the first four data records in the database table have been changed, as shown in the following figure.

You can perform data entry on mobile terminals, as shown in the following figure.

You can download the example template Smart Add Cell Group.cpt.

The number of bound cells must be consistent in all fields with set cell groups. The following situation is not allowed.

If the number of bound cells is inconsistent, the following prompt will occur.