{"id":3423,"date":"2016-05-22T03:00:02","date_gmt":"2016-05-21T19:00:02","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3423"},"modified":"2018-09-11T19:31:14","modified_gmt":"2018-09-11T11:31:14","slug":"finereport-built-in-data-set","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/05\/22\/finereport-built-in-data-set\/","title":{"rendered":"FineReport Built-in data set"},"content":{"rendered":"<p>We will introduce Built-in data set of FineReport <a title=\"reporting software\" href=\"\/en\/\" target=\"_blank\">reporting software<\/a> in this article.Built-in data set is divided into server built-in data set and report built-in data set. Description will be made taking server built-in data set as an example. Server built-in data set means to create an original table similar to database table in the server data set, to serve as the server data source for report design.<\/p>\n<h3>1. Role of built-in data set<\/h3>\n<p>With builtin data set, Page Break Preview template is made available on the machine without database. If one machine makes a template with database query, a corresponding connection is required to copy this template to another machine for access. Otherwise, template access fails. In this case, the template can be accessed on any computer either by directly defining the template data set into built-in data set or outputting such template into a built-in data set template on the template-making machine. As to output template from built-in data set, refer to the Designer Export chapter.<\/p>\n<p>Specific operation of built-in data set.<\/p>\n<h3>2. Add built-in data set<\/h3>\n<p>Click the Plug Sign under the Template Data Set. Select Built-in Data Set, as shown below:<\/p>\n<p><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/20165201.png\" alt=\"\" \/><\/p>\n<h3>3. Create built-in data set<\/h3>\n<p>After opening Built-in Data Set Window, you can add the data set column, i.e., setting data type, as shown below:<\/p>\n<p><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/20165202.jpg\" width=750 alt=\"\" \/><\/p>\n<h3>4. Insert data<\/h3>\n<p>After setting column name and data type, click Insert Row or Delete Row to operate the data, as shown below:<\/p>\n<p><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/20165203.png\" alt=\"\" \/><\/p>\n<h3>5. Post-setting effect<\/h3>\n<p>After setting, you can see that a data set named <span style=\"color: purple;\">&#8216;Embedded1&#8217;<\/span> is added in the template data set, as shown below:<\/p>\n<p><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/20165204.png\" alt=\"\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We will introduce Built-in data set of FineReport repor&#8230;<\/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\/3423"}],"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=3423"}],"version-history":[{"count":2,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3423\/revisions"}],"predecessor-version":[{"id":4620,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3423\/revisions\/4620"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}