A fillable PDF form can also be used as a report template. The system fills the fillable pdf template via form fields. You can use Adobe Acrobat or similar software to create a fillable pdf form.
•Replace pdf form fields: The form fields must be named using the following syntax:
•ColumnName. Ex. CoName. The form field name CoName will be replaced with the value of the datatable CoName
•TableName.ColumnName. Ex: PartII.TIN. The value of the form field will be replaced by the value of the table named PartII of the column TIN
•TableName.ColumName.Method.FilterCondition. Ex: PartII.Amount.Value.ItemNo=3. the value of the form field will be replaced by the value of the table PartII, column Amount, filtered with ItemNo=3.
•MailMerge is also supported.
Following are pdf report templates filled up by the system so that you can use them as a guide when creating your own report template.
1.Form 1601Cv2018. A fillable pdf form used by the sytem to generate 1601C. Click here to download the file. Open the file using pdf acrobat or similar software and check the names of the form fields.
2.Form 2316. A fillable pdf form 2316 used by the system to generate 2316 for all employees in just one click. Click here to download the file. Open the file using pdf acrobat or similar software and check the names of the form fields. This templates contains special form fields MailMergeParentTableName, MailMergeChildTableNames and MailMergePrimaryKey to be used in generating mailmerge.
The following are special form fields that can be used in generating mail-merge.
MailMergeParentTableName refers to the parent table name of the datasource. You define the name under the Default Value of this form field
MailMergeChildTableNames (optional only) refers to the child table name of the datasource where the filter will also be applied. You define the name under the Default Value of this form field
MailMergePrimaryKey refers to the primary key to be used to filter records when generating mailmerge. The filter will be applied to both parent and child tables. You define the primary key column under the Default Value of this form field