{"id":3609,"date":"2016-06-25T03:01:50","date_gmt":"2016-06-24T19:01:50","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3609"},"modified":"2019-10-24T14:48:09","modified_gmt":"2019-10-24T06:48:09","slug":"set-report-filling-attribute","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/06\/25\/set-report-filling-attribute\/","title":{"rendered":"Set Report Filling Attribute"},"content":{"rendered":"

We will introduce how to set report filling attribute of FineReport reporting software<\/span><\/a> in this article.<\/p>\n

1. Description<\/h3>\n

To set report filling attributes, you need to bind the report body cell to the data table field to guarantee one-to-one correspondence of cell data and database field for data entry at the time of data submission.<\/p>\n

2. Set Report Filling Attribute<\/h3>\n

Click Template > Report Filling Attribute. Click \"\"button and select built-in SQL. Set Submit Type as default Intelligent Submission, and Database as FineReport built-in FRDemo Database. Enter the data to the Employee Table of the database, as shown below:<\/p>\n

\"\"<\/p>\n

2.1 Bind field<\/strong><\/p>\n

Intelligently add field<\/strong><\/p>\n

Click Intelligently Add Field to pop up the dialog that lists all fields in the data table. Check the field requiring data change. By default, check all fields. In this case, use Default Setting and click OK to add all fields in the database to the panel for cell binding, as shown below:<\/p>\n

\"\"<\/p>\n

Intelligently add cell<\/strong><\/p>\n

After adding of database field, the next step is to add cell. Click Intelligently Add Cell to pop up Add Cell dialog, which is displayed in the report body. Directly click the cells in the report body and you can bind cells for specific fields. In case of add error, select the value text box after specific field in the dialog box, then click correct cell, as shown below:<\/p>\n

\"\"<\/p>\n

Primary key setting<\/strong><\/p>\n

After data table fields and cells are added and correspond to each after, check the primary key. As Employee ID field is the primary key in the Employee Table, also check Employee ID as the primary key in the Report Filling Attribute, as shown below:<\/p>\n

\"\"<\/p>\n

For detailed settings of report filling attribute, refer to Report Filling Attribute<\/span>.<\/p>\n","protected":false},"excerpt":{"rendered":"

We will introduce how to set report filling attribute o…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[117],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3609"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=3609"}],"version-history":[{"count":4,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3609\/revisions"}],"predecessor-version":[{"id":8491,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3609\/revisions\/8491"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}