{"id":3747,"date":"2016-07-14T03:00:11","date_gmt":"2016-07-13T19:00:11","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3747"},"modified":"2025-04-17T13:50:29","modified_gmt":"2025-04-17T05:50:29","slug":"data-dictionary","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/product-functions\/data-dictionary.html","title":{"rendered":"What is Data Dictionary?"},"content":{"rendered":"<p>Today we will introduce data dictionary of FineReport <a href=\"http:\/\/www.finereport.com\/en\/\" target=\"_blank\" rel=\"noopener\">reporting tool <\/a>in this article.Data presentation requires meaningful actual value.<\/p>\n<div id=\"toc_container\" class=\"toc_transparent no_bullets\"><p class=\"toc_title\">Contents<\/p><ul class=\"toc_list\"><li><a href=\"#1_Overview_of_Data_Dictionary\">1. Overview of Data Dictionary<\/a><ul><li><a href=\"#11_Database_table_setting\">1.1 Database table setting<\/a><\/li><li><a href=\"#12_Data_query_setting\">1.2 Data query setting<\/a><\/li><li><a href=\"#13_Custom_setting\">1.3 Custom setting<\/a><\/li><li><a href=\"#14_Formula_setting\">1.4 Formula setting<\/a><\/li><\/ul><\/li><\/ul><\/div>\n<h2><span id=\"1_Overview_of_Data_Dictionary\">1. Overview of Data Dictionary<\/span><\/h2>\n<p>In original data of <a title=\"FineReport BI and reporting tool report designer\" href=\"http:\/\/www.finereport.com\/en\/features\/report-designer\" target=\"_blank\" rel=\"noopener\">report designer<\/a>, what\u2019s saved is the data of code nature. However, data presentation requires meaningful actual value.<\/p>\n<h3><span id=\"11_Database_table_setting\"><strong>1.1 Database table setting<\/strong><\/span><\/h3>\n<p>In database table setting, we will select corresponding database and table and fill in actual value and desired display value, as shown below:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201607114.png\" alt=\"\" width=\"634\" height=\"291\" \/><\/p>\n<h3><span id=\"12_Data_query_setting\"><strong>1.2 Data query setting<\/strong><\/span><\/h3>\n<p>Data query setting in report designer is to query data set. We will select corresponding data set and set actual value and display value, as shown below:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201607115.png\" alt=\"\" width=\"625\" height=\"228\" \/><\/p>\n<h3><span id=\"13_Custom_setting\"><strong>1.3 Custom setting<\/strong><\/span><\/h3>\n<p>Custom display value in report designer, as shown below:<\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201607116.png\" alt=\"\" \/><\/p>\n<h3><span id=\"14_Formula_setting\"><strong>1.4 Formula setting<\/strong><\/span><\/h3>\n<p>Formula data dictionary is shown below:<\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201607117.png\" alt=\"\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today we will introduce data dictionary of FineReport reporting tool in this article.Data presentation requires meaningful actual value. Contents1. Overview of Data Dictionary1.1 Database table setting1.2 Data query setting1.3 Custom setting1.4 Formula setting 1. Overview of Data Dictionary In original data of report designer, what\u2019s saved is the data of code nature. However, data presentation&#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":[2168,185,2169,312,204,616,2176,2164,372,1501,612],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3747"}],"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=3747"}],"version-history":[{"count":5,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3747\/revisions"}],"predecessor-version":[{"id":19643,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3747\/revisions\/19643"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=3747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=3747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=3747"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=3747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}