{"id":3628,"date":"2016-06-27T03:00:59","date_gmt":"2016-06-26T19:00:59","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3628"},"modified":"2019-10-24T16:21:06","modified_gmt":"2019-10-24T08:21:06","slug":"row-filling-report-example","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/06\/27\/row-filling-report-example\/","title":{"rendered":"Row Filling Report Example"},"content":{"rendered":"

We will introduce row filling report example of FineReport reporting tool<\/span><\/a> in this article.Filling report is not only for data collection, but also for display original data in database.<\/p>\n

1. Description<\/h3>\n

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:<\/p>\n

\"\"<\/p>\n

2. Example<\/h3>\n

2.1 New report<\/strong><\/p>\n

Create a new workbook and add the data set ds1. SQL statement is: SELECT * FROM [Product]<\/span>.<\/p>\n

2.2 Design sample table<\/strong><\/p>\n

Design sample table and drag the data column to corresponding cell as shown below:<\/p>\n

\"\"<\/p>\n

Note: When making filling report, don\u2019t 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.<\/span><\/p>\n

2.3 Add control<\/strong><\/p>\n

Batch select Cells B3-K3. Right click and select Control Setting as Text.<\/p>\n

2.4 Set report filling attribute<\/strong><\/p>\n

Click menu Report > Report Filling Attribute and set report filling attributes as shown below:<\/span><\/p>\n

\"\"<\/p>\n

2.5 Set toolbar<\/strong><\/p>\n

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<\/span> 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:<\/p>\n

\"\"<\/p>\n

3. Save and preview<\/h3>\n

Save the report and click Filling Preview for insert and edit operations.<\/p>\n

See %FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Form\\LineForm\\LineForm.cpt<\/span> for completed templates.<\/p>\n

Click LineForm.cpt<\/span> to check template effect online.<\/p>\n

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.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

We will introduce row filling report example of FineRep…<\/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\/3628"}],"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=3628"}],"version-history":[{"count":4,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3628\/revisions"}],"predecessor-version":[{"id":8517,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3628\/revisions\/8517"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}