Overview
The free data entry report allows data to be entered on multiple rows in a free report. The free data entry report allows you to customize the report layout, featuring flexible styles and various styles.
Example
Example Effect
Create an employee information registration table and use various data entry widgets to enter data.
Data Preparation
Create a dataset named ds1, and enter the SQL query statement SELECT * FROM Employe_copy in the database query dialog box to retrieve all data from the table Employe_copy.
Report Design
Design the report style based on the following figure.
Adding Data Entry Widgets
Add and configure data entry widgets to the cells used for entering data as described in the following table.
Cell | Widget Type | Operation |
C4 | Text Widget | / |
H4 | Text Widget | Insert the formula today( ) in cell H4. The default value is the date of the current day. |
C6 | Text Widget | / |
F6 | Radio Button Group Widget | Customize the data dictionary and add two radio buttons: Male and Female. |
C7 | Date Widget | Set Format to Date (in YYYY-MM-DD format) for the date widget. |
F7 | Date Widget | Set Format to Date (in YYYY-MM-DD format) for the date widget. |
C8 | Drop-down Box Widget | In Data Dictionary, set Dataset to ds1 and Actual Value/Display Value to the data column Job Position. |
F8 | Text Widget | / |
C9 | Drop-down Box Widget | In Data Dictionary, set Dataset to ds1 and Actual Value/Display Value to the data column Region. |
F9 | Drop-down Box Widget | In Data Dictionary, set Dataset to ds1 and Actual Value/Display Value to the data column City. |
C10 | Text Widget | / |
G10 | Text Widget | Set Filling Rule to Post Code. |
C11 | Text Widget | Set Filling Rule to Mobile Number. |
G11 | Text Widget | Set Filling Rule to Telephone Number. |
B13 | Text Area Widget | / |
H6 | File Widget | Set File Type to jpg, png, gif and Size Limit to 1024 KB. |
Setting Data Entry Attributes
To set data entry attributes, you need to bind the cells (to which the data is to be entered) to the corresponding data columns in the database table.
1. Choose Template > Data Entry Attribute from the menu bar to open the Data Entry Attribute dialog box.
2. In the Data Entry Attribute dialog box, select Submit, click +, and select Build-in SQL to add a built-in SQL data submission method. Set Submission Type Selection to Smart Submission, Database to FRDemo, and Table to Employe_copy. Use the Smart Add Field and Smart Add Cell functions to bind the cells to the data columns in the database table. Select Employee ID as the primary key. Select No Modification, No Update and click OK to complete the data entry attribute setting.
Note:1. If you select No Modification, No Update, data not modified on the page will not be submitted during data entry. For details, see No Modification, No Update.
2: To modify or delete data, you must select one or more primary keys. The primary key here is equivalent to where in SQL, which is different from the primary key in the database.
Effect Display
PC
1. Click the Save button to save the report. Click the Preview button and select Data Entry Preview to view the report.
2. Data Entry Preview Effect
Mobile Terminal
Completed Template
You can download the template: Free Report Data Entry.cpt.
Previous：Row-based Data Entry
