{"id":1801,"date":"2025-03-11T19:25:34","date_gmt":"2025-03-11T19:25:34","guid":{"rendered":"\/enterprise\/?post_type=ht_kb&#038;p=1801"},"modified":"2025-03-20T13:16:36","modified_gmt":"2025-03-20T13:16:36","slug":"rg-add-excel-totals-option","status":"publish","type":"ht_kb","link":"\/enterprise\/knowledge-base\/rg-add-excel-totals-option\/","title":{"rendered":"RG &#8211; Add Excel Totals option"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">\n  Improvement\n<\/h3>\n\n\n\n<p>\n  Report Generator &#8211; Added a new option for Excel to support &#8220;old style&#8221; totals.\n<\/p>\n\n\n\n<p>\n  English :  Totals without breaks (XLSX Only)\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"981\" height=\"78\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/word-image-1801-1.jpeg\" alt=\"\" class=\"wp-image-1802\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/word-image-1801-1.jpeg 981w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/word-image-1801-1-300x24.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/word-image-1801-1-768x61.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/word-image-1801-1-50x4.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/word-image-1801-1-60x5.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/word-image-1801-1-100x8.jpeg 100w\" sizes=\"auto, (max-width: 981px) 100vw, 981px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>\n  When enabled \u2013 \n<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The total lines are separated from the data lines.<br>  <\/li>\n\n\n\n<li>The total lines contain formulas.<br>  <\/li>\n<\/ul>\n\n\n\n<p>\n  Notes\n<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>This option does not support subtotals<br>  <\/li>\n\n\n\n<li> Supported environments: <br>    <br>    .Net<br>  <\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\n  Version\n<\/h3>\n\n\n\n<p>\n  5.24.1\n<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\n  Instructions\n<\/h3>\n\n\n\n<p>\n  Sbo upgrade with the next hotfix to be released.\n<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\n  Examples\n<\/h3>\n\n\n\n<p><strong>Totals without breaks<\/strong>\n<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1015\" height=\"564\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-12.jpeg\" alt=\"A screenshot of a computer\n\nAI-generated content may be incorrect.\" class=\"wp-image-1804\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-12.jpeg 1015w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-12-300x167.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-12-768x427.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-12-50x28.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-12-60x33.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-12-100x56.jpeg 100w\" sizes=\"auto, (max-width: 1015px) 100vw, 1015px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1421\" height=\"357\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-13.jpeg\" alt=\"A screenshot of a computer\n\nAI-generated content may be incorrect.\" class=\"wp-image-1806\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-13.jpeg 1421w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-13-300x75.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-13-1024x257.jpeg 1024w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-13-768x193.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-13-50x13.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-13-60x15.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-13-100x25.jpeg 100w\" sizes=\"auto, (max-width: 1421px) 100vw, 1421px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1444\" height=\"365\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-close-up-of-a-document-ai-generated-content-may.jpeg\" alt=\"A close-up of a document\n\nAI-generated content may be incorrect.\" class=\"wp-image-1808\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-close-up-of-a-document-ai-generated-content-may.jpeg 1444w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-close-up-of-a-document-ai-generated-content-may-300x76.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-close-up-of-a-document-ai-generated-content-may-1024x259.jpeg 1024w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-close-up-of-a-document-ai-generated-content-may-768x194.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-close-up-of-a-document-ai-generated-content-may-50x13.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-close-up-of-a-document-ai-generated-content-may-60x15.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-close-up-of-a-document-ai-generated-content-may-100x25.jpeg 100w\" sizes=\"auto, (max-width: 1444px) 100vw, 1444px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Totals with breaks<\/strong>\n<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1051\" height=\"577\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-14.jpeg\" alt=\"A screenshot of a computer\n\nAI-generated content may be incorrect.\" class=\"wp-image-1810\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-14.jpeg 1051w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-14-300x165.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-14-1024x562.jpeg 1024w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-14-768x422.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-14-50x27.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-14-60x33.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-14-100x55.jpeg 100w\" sizes=\"auto, (max-width: 1051px) 100vw, 1051px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1401\" height=\"302\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-15.jpeg\" alt=\"A screenshot of a computer\n\nAI-generated content may be incorrect.\" class=\"wp-image-1812\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-15.jpeg 1401w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-15-300x65.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-15-1024x221.jpeg 1024w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-15-768x166.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-15-50x11.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-15-60x13.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-15-100x22.jpeg 100w\" sizes=\"auto, (max-width: 1401px) 100vw, 1401px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1408\" height=\"326\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-16.jpeg\" alt=\"A screenshot of a computer\n\nAI-generated content may be incorrect.\" class=\"wp-image-1814\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-16.jpeg 1408w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-16-300x69.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-16-1024x237.jpeg 1024w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-16-768x178.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-16-50x12.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-16-60x14.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-16-100x23.jpeg 100w\" sizes=\"auto, (max-width: 1408px) 100vw, 1408px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Improvement Report Generator &#8211; Added a new option for Excel to support &#8220;old style&#8221; totals. English : Totals without breaks (XLSX Only) When enabled \u2013 Notes Version 5.24.1 Instructions Sbo upgrade with the next hotfix to be released. Examples Totals without breaks Totals with breaks<\/p>\n","protected":false},"author":4,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"ht-kb-category":[66],"ht-kb-tag":[56],"class_list":["post-1801","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-reports","ht_kb_tag-enterprise"],"_links":{"self":[{"href":"https:\/\/help.synerion.com\/enterprise\/wp-json\/wp\/v2\/ht-kb\/1801","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.synerion.com\/enterprise\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.synerion.com\/enterprise\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.synerion.com\/enterprise\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/help.synerion.com\/enterprise\/wp-json\/wp\/v2\/comments?post=1801"}],"version-history":[{"count":1,"href":"https:\/\/help.synerion.com\/enterprise\/wp-json\/wp\/v2\/ht-kb\/1801\/revisions"}],"predecessor-version":[{"id":1816,"href":"https:\/\/help.synerion.com\/enterprise\/wp-json\/wp\/v2\/ht-kb\/1801\/revisions\/1816"}],"wp:attachment":[{"href":"https:\/\/help.synerion.com\/enterprise\/wp-json\/wp\/v2\/media?parent=1801"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.synerion.com\/enterprise\/wp-json\/wp\/v2\/ht-kb-category?post=1801"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.synerion.com\/enterprise\/wp-json\/wp\/v2\/ht-kb-tag?post=1801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}