{"id":3497,"date":"2016-06-02T03:00:38","date_gmt":"2016-06-01T19:00:38","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3497"},"modified":"2019-10-24T14:47:31","modified_gmt":"2019-10-24T06:47:31","slug":"finereport-data-display-format-style","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/product-functions\/finereport-data-display-format-style.html","title":{"rendered":"FineReport Data Display Format &#8211; Style"},"content":{"rendered":"<p>We will introduce Data Display Format &#8211; Style of FineReport <a title=\"reporting software\" href=\"\/en\/\" target=\"_blank\"><span style=\"color: blue;\">reporting software<\/span><\/a> in this article.The data style obtained from the data table is not the desired style.In this case, it is necessary to set the display style of the cell.<\/p>\n<h3>1. Description<\/h3>\n<p>The data style obtained from the data table is not the desired style.<\/p>\n<p>For example, the Arrival Date is changed in a format of year, month, day, and a symbol of \u201c\uffe5\u201d is added before Freight Charge, as shown below:<\/p>\n<p><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/20166105.png\" alt=\"\" \/><\/p>\n<p>In this case, it is necessary to set the display style of the cell. Here is a simple example to show the method of changing data display style.<\/p>\n<h3>2. Realization Steps<\/h3>\n<p><strong>2.1 Open report<\/strong><\/p>\n<p>Open the report of <span style=\"color: blue;\">%FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Primary\\DetailReport\\Details_1.cpt<\/span><\/p>\n<p><strong>2.2 Change the style of Arrival Date<\/strong><\/p>\n<p>Select data column cell of Arrival Date, right click to select Menu <span style=\"color: purple;\">Style &gt; Custom Style &gt; Format<\/span>, or directly select<span style=\"color: purple;\"> Cell Attribute Table \u2013 Style &gt; Custom Style &gt; Format<\/span> in the Cell Attribute panel on the right and select Date Type to change it to YYYY, MM, DD, as shown below:<\/p>\n<p><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/20166106.png\" alt=\"\" \/><\/p>\n<p><strong>2.3 Change style of freight charge<\/strong><\/p>\n<p>Select data column cell of Freight Charge, right click to select Menu <span style=\"color: purple;\">Style &gt; Custom Style &gt; Format<\/span>, and select Currency, as shown below:<\/p>\n<p><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/20166107.png\" alt=\"\" \/><\/p>\n<p>Users can define display modes of the actual values of cells, such as number and date through style without changing the actual values.<span style=\"color: blue;\">See more styles<\/span><\/p>\n<h3>3. Save and issue reports<\/h3>\n<p>For completed templates, refer to <span style=\"color: blue;\">%FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Primary\\DetailReport\\Details_2.cpt<\/span><\/p>\n<p>Click <a href=\"http:\/\/www.finereporthelp.com:8889\/demo\/ReportServer?reportlet=doc\/Primary\/DetailReport\/Details_2.cpt\" target=\"_blank\"><span style=\"color: blue;\">Details_2.cpt<\/span> <\/a>to check template effect online.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We will introduce Data Display Format &#8211; Style of FineReport reporting software in this article.The data style obtained from the data table is not the desired style.In this case, it is necessary to set the display style of the cell. 1. Description The data style obtained from the data table is not the desired style&#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\/3497"}],"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=3497"}],"version-history":[{"count":3,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3497\/revisions"}],"predecessor-version":[{"id":8472,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3497\/revisions\/8472"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=3497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=3497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=3497"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=3497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}