We will introduce Submission Type about data filling of FineReport reporting tool in this article.

1. Intelligent submission

In intelligent submission, the backstage will judges insert, update and delete. If your filling template has two or more demands aforesaid, you can select intelligent submission type.

If you have inserted several pieces of blank data but fail to edit these blank rows, FineReport will identify these record values as NULL. These records will not be stored in database (i.e., blank records not stored).

2. Insert submission

In insert submission, only insert operation is made. Therefore, it is generally applied in blank information collection table. If insert submission is applied for templates showing original data, the original records will be re-inserted to the database, causing data repetition; and if you have defined a primary key in the database table, in insert submission, submission will fail (i.e., index conflict).

Note: Similarly, in insert submission, blank records will not be stored in database.

3. Update submission

Update submission is to update original data. Therefore, original data must be displayed in the template. In addition, check a column in the Report Filling Attribute as primary key, and the data inside cannot be changed; otherwise, update submission will be changed to insert submission.

Note: Primary keys in Report Filling Attribute and database are different. Report primary key is to operate corresponding data in Update Submission and Delete Submission. If Delete Submission or Update Submission is not set, primary key will operate all data.

4. Delete submission

Similar to Update Submission, you need to check a column in the Report Filling Attribute as primary key as the template also needs to display original data.

Note: To improve report storage efficiency, be cautious when using Intelligent Submission. In Intelligent Submission, during data submission, the system will judge whether there is a report primary key. If so, take update submission, if not, take insert submission, thus reducing report storage efficiency. Therefore, when only one submission is used, select corresponding submission type.