{"id":3407,"date":"2016-05-21T03:00:20","date_gmt":"2016-05-20T19:00:20","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3407"},"modified":"2024-04-09T12:04:56","modified_gmt":"2024-04-09T04:04:56","slug":"finereport-data-set","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/product-functions\/finereport-data-set.html","title":{"rendered":"FineReport Data Set"},"content":{"rendered":"<p>We will introduce data set of FineReport <a title=\"reporting tools\" href=\"\/en\/\" target=\"_blank\" rel=\"noopener\">reporting tool<\/a> in this article.Data set means the data collection that is taken from database and directly applied in the template design.<\/p>\n<h3>1. Overview<\/h3>\n<p>Data set means the data collection that is taken from database and directly applied in the template design.<br \/>\nData set, based on application scope, can be divided into <span style=\"color: blue;\"><a href=\"http:\/\/enhelp.finereport.com\/doc-view-235.html?c=7&amp;v=8\" target=\"_blank\" rel=\"noopener\">Server Data Set<\/a><\/span> and <span style=\"color: blue;\">Template Data Set<\/span>.<\/p>\n<p><strong>1.1 Server data set<\/strong><\/p>\n<p>Server data set is defined in <span style=\"color: green;\"> Server &gt;Server Data Set<\/span>, which is applicable to the data sets of all reports on the entire server, including <span style=\"color: blue;\"> Database Query<\/span>,<span style=\"color: blue;\"> Built-In Data Set<\/span>, <span style=\"color: blue;\">File Data Set<\/span>, <span style=\"color: blue;\">SAP Data Set<\/span>,<span style=\"color: blue;\">Stored Procedure<\/span>, <span style=\"color: blue;\">MDD<\/span>, <span style=\"color: blue;\"><a href=\"http:\/\/enhelp.finereport.com\/doc-view-125.html?c=2&amp;v=1\" target=\"_blank\" rel=\"noopener\">Linked Database<\/a><\/span> and <span style=\"color: blue;\">Tree Database<\/span>.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201651801.jpg\" alt=\"\" width=\"708\" height=\"472\" \/><\/p>\n<p><strong>1.2 Template data set<\/strong><\/p>\n<p>Template data set is defined in the <span style=\"color: green;\">Template &gt; Template Data Set<\/span> or the Data Set Window, which is only applicable to the data set of single template. Specific types are same as those in the server data set.<\/p>\n<p><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201651802.png\" alt=\"\" \/><\/p>\n<p><span style=\"color: red;\">Template data set is only valid for current template.<\/span><\/p>\n<h3>2. Data set window<\/h3>\n<p>The Data Set Window of designer will display all defined data sets, including Template Data Set and Server Data Set, as shown below:<\/p>\n<p><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201651803.png\" alt=\"\" \/><\/p>\n<p><span style=\"color: red;\">Note: Data Set Window can add, delete and query the template data set, but can only preview the server data set and stored procedure data set.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We will introduce data set of FineReport reporting tool in this article.Data set means the data collection that is taken from database and directly applied in the template design. 1. Overview Data set means the data collection that is taken from database and directly applied in the template design. Data set, based on application scope,&#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],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3407"}],"collection":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/comments?post=3407"}],"version-history":[{"count":14,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3407\/revisions"}],"predecessor-version":[{"id":18740,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3407\/revisions\/18740"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=3407"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=3407"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=3407"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=3407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}