{"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:\/\/frg.fineres.com\/en\/2016\/06\/02\/finereport-data-display-format-style\/","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 &#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\/3497"}],"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=3497"}],"version-history":[{"count":3,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3497\/revisions"}],"predecessor-version":[{"id":8472,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3497\/revisions\/8472"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}