{"id":1741,"date":"2025-03-11T18:56:46","date_gmt":"2025-03-11T18:56:46","guid":{"rendered":"\/enterprise\/?post_type=ht_kb&#038;p=1741"},"modified":"2025-03-20T13:16:49","modified_gmt":"2025-03-20T13:16:49","slug":"adding-to-rg","status":"publish","type":"ht_kb","link":"\/enterprise\/knowledge-base\/adding-to-rg\/","title":{"rendered":"Adding to RG an option to display data from A1 (no Metadata)"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Improvement<\/h2>\n\n\n\n<p>Report Generator &#8211; Added a new option for Excel to display data from A1 with no Metadata, i.e., report header, filters summary and number of results. <br>The option can be used for ad-hoc reports and for scheduled reports via Task scheduler.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"411\" height=\"342\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m.jpeg\" alt=\"A screenshot of a computer\n\nAI-generated content may be incorrect.\" class=\"wp-image-1742\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m.jpeg 411w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-300x250.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-50x42.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-60x50.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-ai-generated-content-m-100x83.jpeg 100w\" sizes=\"auto, (max-width: 411px) 100vw, 411px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Notes<\/p>\n\n\n\n<p>Supported environments: <br>.Net<\/p>\n\n\n\n<p>Version<\/p>\n\n\n\n<p>5.25.1<\/p>\n\n\n\n<p>Instructions<\/p>\n\n\n\n<p>Sbo upgrade.<\/p>\n\n\n\n<p>Examples<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Display Metadata<\/strong><\/h2>\n\n\n\n<p>Excel layout including Metadata such as Report header, filters summary and number of results .<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"954\" height=\"516\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica.jpeg\" alt=\"A screenshot of a computer\n\nDescription automatically generated\" class=\"wp-image-1744\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica.jpeg 954w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-300x162.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-768x415.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-50x27.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-60x32.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-100x54.jpeg 100w\" sizes=\"auto, (max-width: 954px) 100vw, 954px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"983\" height=\"573\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat.jpeg\" alt=\"A screenshot of a spreadsheet\n\nDescription automatically generated\" class=\"wp-image-1746\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat.jpeg 983w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-300x175.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-768x448.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-50x29.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-60x35.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-100x58.jpeg 100w\" sizes=\"auto, (max-width: 983px) 100vw, 983px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Display Data from A1 Column<\/strong><\/h2>\n\n\n\n<p>Excel layout not including Metadata such as Report header, filters summary and number of results.<\/p>\n\n\n\n<p>Select report<\/p>\n\n\n\n<p>Press \u201cSettings\u201d to apply the new option<\/p>\n\n\n\n<p>Xlsx File Settings<\/p>\n\n\n\n<p>Display Data from A1 Column = Yes<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"951\" height=\"518\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-1.jpeg\" alt=\"A screenshot of a computer\n\nDescription automatically generated\" class=\"wp-image-1748\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-1.jpeg 951w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-1-300x163.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-1-768x418.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-1-50x27.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-1-60x33.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-1-100x54.jpeg 100w\" sizes=\"auto, (max-width: 951px) 100vw, 951px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>When enabled, the system displays the Excel spreadsheet from A1. <br>The metadata is not displayed.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"993\" height=\"520\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-2.jpeg\" alt=\"A screenshot of a computer\n\nDescription automatically generated\" class=\"wp-image-1750\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-2.jpeg 993w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-2-300x157.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-2-768x402.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-2-50x26.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-2-60x31.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-2-100x52.jpeg 100w\" sizes=\"auto, (max-width: 993px) 100vw, 993px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Totals without breaks<\/strong><\/h2>\n\n\n\n<p>When totals without breaks is enabled, the totals header lines (Sum\/Min\/Max\/Avg\/Count) are relocated in the last column. \u200e<\/p>\n\n\n\n<p>Totals without breaks (XLSX Only) = Yes\u200e<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"952\" height=\"518\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-3.jpeg\" alt=\"A screenshot of a computer\n\nDescription automatically generated\" class=\"wp-image-1752\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-3.jpeg 952w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-3-300x163.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-3-768x418.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-3-50x27.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-3-60x33.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-3-100x54.jpeg 100w\" sizes=\"auto, (max-width: 952px) 100vw, 952px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"875\" height=\"666\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-1.jpeg\" alt=\"A screenshot of a spreadsheet\n\nDescription automatically generated\" class=\"wp-image-1754\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-1.jpeg 875w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-1-300x228.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-1-768x585.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-1-50x38.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-1-60x46.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-1-100x76.jpeg 100w\" sizes=\"auto, (max-width: 875px) 100vw, 875px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Scheduled Reports<\/strong><\/h2>\n\n\n\n<p>Excel layout not including Metadata such as Report header, filters summary and number of results.<\/p>\n\n\n\n<p>Select report<\/p>\n\n\n\n<p>Press \u201cScheduler\u201d to apply the new option<\/p>\n\n\n\n<p>Xlsx File Settings<\/p>\n\n\n\n<p>Display Data from A1 Column = Yes<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"962\" height=\"522\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-4.jpeg\" alt=\"A screenshot of a computer\n\nDescription automatically generated\" class=\"wp-image-1756\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-4.jpeg 962w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-4-300x163.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-4-768x417.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-4-50x27.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-4-60x33.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-4-100x54.jpeg 100w\" sizes=\"auto, (max-width: 962px) 100vw, 962px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"756\" height=\"340\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-5.jpeg\" alt=\"A screenshot of a computer\n\nDescription automatically generated\" class=\"wp-image-1758\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-5.jpeg 756w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-5-300x135.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-5-50x22.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-5-60x27.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-5-100x45.jpeg 100w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1147\" height=\"464\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-6.jpeg\" alt=\"A screenshot of a computer\n\nDescription automatically generated\" class=\"wp-image-1760\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-6.jpeg 1147w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-6-300x121.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-6-1024x414.jpeg 1024w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-6-768x311.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-6-50x20.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-6-60x24.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-6-100x40.jpeg 100w\" sizes=\"auto, (max-width: 1147px) 100vw, 1147px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"694\" height=\"282\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-7.jpeg\" alt=\"A screenshot of a computer\n\nDescription automatically generated\" class=\"wp-image-1762\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-7.jpeg 694w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-7-300x122.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-7-50x20.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-7-60x24.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-computer-description-automatica-7-100x41.jpeg 100w\" sizes=\"auto, (max-width: 694px) 100vw, 694px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"991\" height=\"526\" src=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-2.jpeg\" alt=\"A screenshot of a spreadsheet\n\nDescription automatically generated\" class=\"wp-image-1764\" srcset=\"\/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-2.jpeg 991w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-2-300x159.jpeg 300w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-2-768x408.jpeg 768w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-2-50x27.jpeg 50w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-2-60x32.jpeg 60w, \/enterprise\/wp-content\/uploads\/sites\/3\/2025\/03\/a-screenshot-of-a-spreadsheet-description-automat-2-100x53.jpeg 100w\" sizes=\"auto, (max-width: 991px) 100vw, 991px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Improvement Report Generator &#8211; Added a new option for Excel to display data from A1 with no Metadata, i.e., report header, filters summary and number of results. The option can be used for ad-hoc reports and for scheduled reports via Task scheduler. Notes Supported environments: .Net Version 5.25.1 Instructions Sbo&#8230;<\/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-1741","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\/1741","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=1741"}],"version-history":[{"count":1,"href":"https:\/\/help.synerion.com\/enterprise\/wp-json\/wp\/v2\/ht-kb\/1741\/revisions"}],"predecessor-version":[{"id":1766,"href":"https:\/\/help.synerion.com\/enterprise\/wp-json\/wp\/v2\/ht-kb\/1741\/revisions\/1766"}],"wp:attachment":[{"href":"https:\/\/help.synerion.com\/enterprise\/wp-json\/wp\/v2\/media?parent=1741"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.synerion.com\/enterprise\/wp-json\/wp\/v2\/ht-kb-category?post=1741"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.synerion.com\/enterprise\/wp-json\/wp\/v2\/ht-kb-tag?post=1741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}