{"id":3605,"date":"2016-06-24T03:01:21","date_gmt":"2016-06-23T19:01:21","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3605"},"modified":"2019-10-24T14:48:10","modified_gmt":"2019-10-24T06:48:10","slug":"filling-report-design","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/06\/24\/filling-report-design\/","title":{"rendered":"Filling report design"},"content":{"rendered":"

In this article,you will grasp the design methods of typical row filling report, free filling report, multi-source filling report and multi-sheet filling report.All reports are made by FineReport reporting tool<\/span><\/a>.<\/p>\n

1. Description<\/h3>\n

Filling report is different from common report where the later is to display data and the former is to enter data. Here comes the question: is it necessary to design report template for filling report just like common report?<\/p>\n

The answer is Yes, as in data entry of filling report, report design is required to define how and where to enter data.<\/p>\n

2. Example<\/h3>\n

In industries like finance, service and medical treatment, there are data entry interfaces with free styles and various editing styles to collect and store information in database (as shown below). This kind of report is called free-format filling report.<\/p>\n

\"\"<\/p>\n

Next, we will learn how to make a free filling report and its specific usage of filling process taking the \u201cEmployee Information Registration Table\u201d as an example (as shown above).<\/p>\n

2.1 Report design<\/strong><\/p>\n

Add data set<\/strong><\/p>\n

In the Data Set Panel, click Add button to add a Database Query<\/span> The SQL statement is: SELECT * FROM employee.<\/p>\n

Note: As shown from the effect graph, the report body is not bound to a field, Here, we create a new data set to set data dictionary for control and to bind data to be selected to the control while Aadding a Control<\/span><\/a>.<\/span><\/p>\n

Body design<\/strong><\/p>\n

Create a new template and design the report to the style below in the Report Body:<\/p>\n

\"\"<\/p>\n

Note: To display data, you only need to Bind Data Column<\/span> For detailed usage of data-bound filling report, refer to Row Filling Report<\/span>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

In this article,you will grasp the design methods of ty…<\/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\/3605"}],"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=3605"}],"version-history":[{"count":6,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3605\/revisions"}],"predecessor-version":[{"id":8492,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3605\/revisions\/8492"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3605"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3605"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3605"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}