We will introduce row filling report example of FineReport reporting tool in this article.Filling report is not only for data collection, but also for display original data in database.

1. Description

FineReport filling report is not only for data collection, but also for display original data in database. Based on this, you can add, delete and change data. A most common report type is the row filling report as shown below:

2. Example

2.1 New report

Create a new workbook and add the data set ds1. SQL statement is: SELECT * FROM [Product].

2.2 Design sample table

Design sample table and drag the data column to corresponding cell as shown below:

Note: When making filling report, don’t worry that the content may go beyond the page break line, as filling report is in single page display and page break is a distinctive attribute of common report.

2.3 Add control

Batch select Cells B3-K3. Right click and select Control Setting as Text.

2.4 Set report filling attribute

Click menu Report > Report Filling Attribute and set report filling attributes as shown below:

2.5 Set toolbar

There is no Delete button in default Filling page. If required, you can manually add Delete to the toolbar. Click Template > Template web Attribute > Filling Page Set and select Separate Template Setting. Double click the Delete Record button in bottom tool box to add it to the top toolbar, as shown below:

3. Save and preview

Save the report and click Filling Preview for insert and edit operations.

See %FR_HOME%\WebReport\WEB-INF\reportlets\doc\Form\LineForm\LineForm.cpt for completed templates.

Click LineForm.cpt to check template effect online.

Note: To guarantee data completeness and preciseness, for any data submission in filing with online template, please change the data back after successful submission and then submit the data again. Thanks for your cooperation.