{"id":1787,"date":"2021-10-22T04:20:20","date_gmt":"2021-10-22T04:20:20","guid":{"rendered":"https:\/\/erpconsultors.com\/?p=1787"},"modified":"2021-12-30T11:28:31","modified_gmt":"2021-12-30T11:28:31","slug":"export-to-excel-report-in-business-central","status":"publish","type":"post","link":"https:\/\/erpconsultors.com\/export-to-excel-report-in-business-central\/","title":{"rendered":"Create Export to Excel Report in Business Central"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Export to Excel Report in Business Central:<\/h2>\n\n\n\n<p>For creating \u201cExport to Excel Report\u201d, follow the below steps. For example-<\/p>\n\n\n\n<p>(1) Export Sales Invoice Header data via report.<\/p>\n\n\n\n<p>(2) <a aria-label=\"Create New report (opens in a new tab)\" href=\"https:\/\/erpconsultors.com\/report-creation-in-microsoft-dynamics-365-bc\/\" target=\"_blank\" rel=\"noreferrer noopener\" class=\"rank-math-link\"><strong>Create New report<\/strong><\/a> already explained.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"643\" height=\"173\" data-attachment-id=\"3529\" data-permalink=\"https:\/\/erpconsultors.com\/new-report-in-business-central\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/new-report-in-business-central.jpeg?fit=643%2C173&amp;ssl=1\" data-orig-size=\"643,173\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"new report in business central\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/new-report-in-business-central.jpeg?fit=300%2C81&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/new-report-in-business-central.jpeg?fit=643%2C173&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/new-report-in-business-central.jpeg?resize=643%2C173&#038;ssl=1\" alt=\"new report in business central\" class=\"wp-image-3529\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/new-report-in-business-central.jpeg?w=643&amp;ssl=1 643w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/new-report-in-business-central.jpeg?resize=300%2C81&amp;ssl=1 300w\" sizes=\"(max-width: 643px) 100vw, 643px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n\n<p>(3) Add \u201cSales Invoice Header\u201d dataitem.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"520\" height=\"133\" data-attachment-id=\"1796\" data-permalink=\"https:\/\/erpconsultors.com\/add-sales-invoice-header-data-item-in-bc-d365\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/add-sales-invoice-header-data-item-in-bc-d365.png?fit=520%2C133&amp;ssl=1\" data-orig-size=\"520,133\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"add sales invoice header data item in bc d365\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/add-sales-invoice-header-data-item-in-bc-d365.png?fit=300%2C77&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/add-sales-invoice-header-data-item-in-bc-d365.png?fit=520%2C133&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/add-sales-invoice-header-data-item-in-bc-d365.png?resize=520%2C133&#038;ssl=1\" alt=\"add sales invoice header data item in bc d365\" class=\"wp-image-1796\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/add-sales-invoice-header-data-item-in-bc-d365.png?w=520&amp;ssl=1 520w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/add-sales-invoice-header-data-item-in-bc-d365.png?resize=300%2C77&amp;ssl=1 300w\" sizes=\"(max-width: 520px) 100vw, 520px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n\n<p>(4) Create a Procedure for export data from the \u201cSales Invoice Header\u201d.<\/p>\n\n\n\n<ul><li>MakeHeader.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"655\" height=\"166\" data-attachment-id=\"1803\" data-permalink=\"https:\/\/erpconsultors.com\/makeheader-in-export-to-excel-report-in-business-central\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/makeheader-in-Export-to-Excel-Report-in-Business-Central.png?fit=761%2C193&amp;ssl=1\" data-orig-size=\"761,193\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"MakeHeader in Export to Excel Report in Business Central\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/makeheader-in-Export-to-Excel-Report-in-Business-Central.png?fit=300%2C76&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/makeheader-in-Export-to-Excel-Report-in-Business-Central.png?fit=655%2C166&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/makeheader-in-Export-to-Excel-Report-in-Business-Central.png?resize=655%2C166&#038;ssl=1\" alt=\"MakeHeader in Export to Excel Report in Business Central\" class=\"wp-image-1803\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/makeheader-in-Export-to-Excel-Report-in-Business-Central.png?w=761&amp;ssl=1 761w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/makeheader-in-Export-to-Excel-Report-in-Business-Central.png?resize=300%2C76&amp;ssl=1 300w\" sizes=\"(max-width: 655px) 100vw, 655px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n\n<ul><li>MakeBody.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"655\" height=\"153\" data-attachment-id=\"1807\" data-permalink=\"https:\/\/erpconsultors.com\/makebody-in-export-to-excel-report-in-business-central\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeBody-in-Export-to-Excel-Report-in-Business-Central.png?fit=775%2C181&amp;ssl=1\" data-orig-size=\"775,181\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"MakeBody in Export to Excel Report in Business Central\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeBody-in-Export-to-Excel-Report-in-Business-Central.png?fit=300%2C70&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeBody-in-Export-to-Excel-Report-in-Business-Central.png?fit=655%2C153&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeBody-in-Export-to-Excel-Report-in-Business-Central.png?resize=655%2C153&#038;ssl=1\" alt=\"MakeBody in Export to Excel Report in Business Central\" class=\"wp-image-1807\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeBody-in-Export-to-Excel-Report-in-Business-Central.png?w=775&amp;ssl=1 775w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeBody-in-Export-to-Excel-Report-in-Business-Central.png?resize=300%2C70&amp;ssl=1 300w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeBody-in-Export-to-Excel-Report-in-Business-Central.png?resize=768%2C179&amp;ssl=1 768w\" sizes=\"(max-width: 655px) 100vw, 655px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n\n<ul><li>CreatExcelBook.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"655\" height=\"191\" data-attachment-id=\"1810\" data-permalink=\"https:\/\/erpconsultors.com\/createxcelbook-for-export-to-excel-report-in-business-central\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/CreatExcelBook-for-Export-to-Excel-Report-in-Business-Central.png?fit=666%2C194&amp;ssl=1\" data-orig-size=\"666,194\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"CreatExcelBook for Export to Excel Report in Business Central\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/CreatExcelBook-for-Export-to-Excel-Report-in-Business-Central.png?fit=300%2C87&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/CreatExcelBook-for-Export-to-Excel-Report-in-Business-Central.png?fit=655%2C191&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/CreatExcelBook-for-Export-to-Excel-Report-in-Business-Central.png?resize=655%2C191&#038;ssl=1\" alt=\"CreatExcelBook for Export to Excel Report in Business Central\" class=\"wp-image-1810\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/CreatExcelBook-for-Export-to-Excel-Report-in-Business-Central.png?w=666&amp;ssl=1 666w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/CreatExcelBook-for-Export-to-Excel-Report-in-Business-Central.png?resize=300%2C87&amp;ssl=1 300w\" sizes=\"(max-width: 655px) 100vw, 655px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n\n<p>(5) After following the above procedures. Then call these procedures on the &#8220;dataitem&#8221; and report triggers as shown.<\/p>\n\n\n\n<ul><li>Call \u201cMakeHeader\u201d procedure.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"235\" data-attachment-id=\"1814\" data-permalink=\"https:\/\/erpconsultors.com\/makeheader-procedure-for-export-to-excel-report-in-business-central\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeHeader-Procedure-for-Export-to-Excel-Report-in-Business-Central.png?fit=570%2C235&amp;ssl=1\" data-orig-size=\"570,235\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Call MakeHeader Procedure for Export to Excel Report in Business Central\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeHeader-Procedure-for-Export-to-Excel-Report-in-Business-Central.png?fit=300%2C124&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeHeader-Procedure-for-Export-to-Excel-Report-in-Business-Central.png?fit=570%2C235&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeHeader-Procedure-for-Export-to-Excel-Report-in-Business-Central.png?resize=570%2C235&#038;ssl=1\" alt=\"Call MakeHeader Procedure for Export to Excel Report in Business Central\" class=\"wp-image-1814\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeHeader-Procedure-for-Export-to-Excel-Report-in-Business-Central.png?w=570&amp;ssl=1 570w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeHeader-Procedure-for-Export-to-Excel-Report-in-Business-Central.png?resize=300%2C124&amp;ssl=1 300w\" sizes=\"(max-width: 570px) 100vw, 570px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n\n<ul><li>Call \u201cMakeBody\u201d procedure.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"612\" height=\"336\" data-attachment-id=\"1817\" data-permalink=\"https:\/\/erpconsultors.com\/makebody-procedure-for-export-to-excel-report-in-business-central\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeBody-procedure-for-Export-to-Excel-Report-in-Business-Central.png?fit=612%2C336&amp;ssl=1\" data-orig-size=\"612,336\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Call MakeBody procedure for Export to Excel Report in Business Central\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeBody-procedure-for-Export-to-Excel-Report-in-Business-Central.png?fit=300%2C165&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeBody-procedure-for-Export-to-Excel-Report-in-Business-Central.png?fit=612%2C336&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeBody-procedure-for-Export-to-Excel-Report-in-Business-Central.png?resize=612%2C336&#038;ssl=1\" alt=\"Call MakeBody procedure for Export to Excel Report in Business Central\" class=\"wp-image-1817\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeBody-procedure-for-Export-to-Excel-Report-in-Business-Central.png?w=612&amp;ssl=1 612w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/MakeBody-procedure-for-Export-to-Excel-Report-in-Business-Central.png?resize=300%2C165&amp;ssl=1 300w\" sizes=\"(max-width: 612px) 100vw, 612px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n\n<ul><li>Call \u201cCreateExcelBook\u201d procedure.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"651\" height=\"139\" data-attachment-id=\"1822\" data-permalink=\"https:\/\/erpconsultors.com\/call-createexcelbook-procedure-for-export-to-excel-report-in-business-central\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/Call-CreateExcelBook-Procedure-for-Export-to-Excel-Report-in-Business-Central.png?fit=651%2C139&amp;ssl=1\" data-orig-size=\"651,139\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Call CreateExcelBook Procedure for Export to Excel Report in Business Central\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/Call-CreateExcelBook-Procedure-for-Export-to-Excel-Report-in-Business-Central.png?fit=300%2C64&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/Call-CreateExcelBook-Procedure-for-Export-to-Excel-Report-in-Business-Central.png?fit=651%2C139&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/Call-CreateExcelBook-Procedure-for-Export-to-Excel-Report-in-Business-Central.png?resize=651%2C139&#038;ssl=1\" alt=\"Call CreateExcelBook Procedure for Export to Excel Report in Business Central\" class=\"wp-image-1822\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/Call-CreateExcelBook-Procedure-for-Export-to-Excel-Report-in-Business-Central.png?w=651&amp;ssl=1 651w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/Call-CreateExcelBook-Procedure-for-Export-to-Excel-Report-in-Business-Central.png?resize=300%2C64&amp;ssl=1 300w\" sizes=\"(max-width: 651px) 100vw, 651px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n\n<ul><li>After this create Request Page for filtering data on \u201cSales Invoice Header\u201d.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"404\" height=\"487\" data-attachment-id=\"1825\" data-permalink=\"https:\/\/erpconsultors.com\/create-request-page-for-filtering-data-in-export-to-excel-report-in-bc\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/create-Request-Page-for-filtering-data-in-Export-to-Excel-Report-in-BC.png?fit=404%2C487&amp;ssl=1\" data-orig-size=\"404,487\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"create Request Page for filtering data in Export to Excel Report in BC\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/create-Request-Page-for-filtering-data-in-Export-to-Excel-Report-in-BC.png?fit=249%2C300&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/create-Request-Page-for-filtering-data-in-Export-to-Excel-Report-in-BC.png?fit=404%2C487&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/create-Request-Page-for-filtering-data-in-Export-to-Excel-Report-in-BC.png?resize=404%2C487&#038;ssl=1\" alt=\"create Request Page for filtering data in Export to Excel Report in BC\" class=\"wp-image-1825\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/create-Request-Page-for-filtering-data-in-Export-to-Excel-Report-in-BC.png?w=404&amp;ssl=1 404w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/create-Request-Page-for-filtering-data-in-Export-to-Excel-Report-in-BC.png?resize=249%2C300&amp;ssl=1 249w\" sizes=\"(max-width: 404px) 100vw, 404px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n\n<ul><li>After doing the above steps, Export to Excel Report developed and attached in the menu suit as per the preferred folder.<\/li><\/ul>\n\n\n\n<p class=\"has-text-align-center\"><em><strong>Source Code of \u201cExport to Excel Report\u201d:<\/strong><\/em><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-background\" style=\"background-color:#e7f5fe\"><tbody><tr><td>report 50001 &#8220;Sales Register&#8221;<br>{<br>\u00a0 \u00a0 UsageCategory = Administration;<br>\u00a0 \u00a0 ApplicationArea = All;<br>   ProcessingOnly = True;<br>\u00a0<br>\u00a0 \u00a0 dataset<br>\u00a0 \u00a0 {<br>\u00a0 \u00a0 \u00a0 \u00a0 dataitem(&#8220;Sales Invoice Header&#8221;; &#8220;Sales Invoice Header&#8221;)<br>\u00a0 \u00a0 \u00a0 \u00a0 {<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 DataItemTableView = SORTING(&#8220;No.&#8221;);<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 trigger OnPreDataItem()<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 begin<br><br><em>\/\/Date Filter<\/em><br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SETFILTER(&#8220;Posting Date&#8221;, &#8216;%1..%2&#8217;, StartDate, EndDate);<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <em>\/\/Customer Filter<\/em><br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 if CustomerNo&lt;> &#8221; then<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 setfilter(&#8220;Sell-to Customer No.&#8221;, CustomerNo);<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 end;<br>\u00a0<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 trigger OnAfterGetRecord()<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 begin<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <em>\/\/Create Body or Line Part<\/em><br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 MakeBody;<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 end;<br>\u00a0<br>\u00a0 \u00a0 \u00a0 \u00a0 }<br>\u00a0<br>\u00a0 \u00a0 }<br>\u00a0 \u00a0 requestpage<br>\u00a0 \u00a0 {<br>\u00a0 \u00a0 \u00a0 \u00a0 layout<br>\u00a0 \u00a0 \u00a0 \u00a0 {<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 area(Content)<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 {<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 group(Options)<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 {<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Caption = &#8216;Options&#8217;;<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 field(CustomerNo; CustomerNo)<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 {<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ApplicationArea = Basic, Suite;<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Caption = &#8216;Customer No.&#8217;;<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 TableRelation = Customer;<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 field(StartDate; StartDate)<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 {<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ApplicationArea = Basic, Suite;<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Caption = &#8216;Start Date&#8217;;<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 field(EndDate; EndDate)<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 {<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ApplicationArea = Basic, Suite;<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Caption = &#8216;End Date&#8217;;<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }<br>\u00a0<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }<br>\u00a0 \u00a0 \u00a0 \u00a0 }<br><br>actions<br>\u00a0 \u00a0 \u00a0 \u00a0 {<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 area(processing)<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 {<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 action(ActionName)<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 {<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ApplicationArea = All;<br>\u00a0<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }<br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }<br>\u00a0 \u00a0 \u00a0 \u00a0 }<br>\u00a0<br>\u00a0 \u00a0 }<br>\u00a0 \u00a0 trigger OnPreReport()<br>\u00a0 \u00a0 begin<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.Reset();<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.DELETEALL();<br>\u00a0 \u00a0 \u00a0 \u00a0 IF StartDate = 0D THEN <em>\/\/Validation<\/em><br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ERROR(&#8216;Start Date must not be blank&#8217;);<em>\/\/Validation<\/em><br>\u00a0 \u00a0 \u00a0 \u00a0 IF EndDate = 0D THEN <em>\/\/Validation<\/em><br>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ERROR(&#8216;End Date must not be blank&#8217;);<em>\/\/Validation<\/em><br>\u00a0 \u00a0 \u00a0 \u00a0 MakeHeader; <em>\/\/Create Header Part<\/em><br>\u00a0 \u00a0 end;<br>\u00a0<br>\u00a0 \u00a0 trigger OnPostReport()<br>\u00a0 \u00a0 begin<br>\u00a0 \u00a0 \u00a0 \u00a0 CreateExcelBook; <em>\/\/ Create Excel Book<\/em><br>\u00a0 \u00a0 end;<br>\u00a0<br>\u00a0 \u00a0 var<br>\u00a0 \u00a0 \u00a0 \u00a0 StartDate: Date;<br>\u00a0 \u00a0 \u00a0 \u00a0 EndDate: Date;<br>\u00a0 \u00a0 \u00a0 \u00a0 CustomerNo: Code[250];<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer: Record &#8220;Excel Buffer&#8221; temporary;<br>\u00a0 \u00a0 local procedure MakeHeader()<br>\u00a0 \u00a0 var<br>\u00a0 \u00a0 \u00a0 \u00a0 myInt: Integer;<br>\u00a0 \u00a0 begin<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.NewRow();<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.AddColumn(&#8216;Customer No.&#8217;, FALSE, &#8221;, TRUE, FALSE, TRUE, &#8221;, TempExcelBuffer.&#8221;Cell Type&#8221;::Text);<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.AddColumn(&#8216;Customer Name&#8217;, FALSE, &#8221;, TRUE, FALSE, TRUE, &#8221;, TempExcelBuffer.&#8221;Cell Type&#8221;::Text);<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.AddColumn(&#8216;Invoice Date&#8217;, FALSE, &#8221;, TRUE, FALSE, TRUE, &#8221;, TempExcelBuffer.&#8221;Cell Type&#8221;::Text);<br>        TempExcelBuffer.AddColumn(&#8216;Invoice No.&#8217;, FALSE, &#8221;, TRUE, FALSE, TRUE, &#8221;, TempExcelBuffer.&#8221;Cell Type&#8221;::Text);<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.AddColumn(&#8216;Amount&#8217;, FALSE, &#8221;, TRUE, FALSE, TRUE, &#8221;, TempExcelBuffer.&#8221;Cell Type&#8221;::Text);<br>\u00a0 \u00a0 end;<br>\u00a0 \u00a0 local procedure MakeBody()<br>\u00a0 \u00a0 var<br>\u00a0 \u00a0 \u00a0 \u00a0 myInt: Integer;<br>\u00a0 \u00a0 begin<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.NewRow();<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.AddColumn(&#8220;Sales Invoice Header&#8221;.&#8221;Sell-to Customer No.&#8221;, FALSE, &#8221;, FALSE, FALSE, FALSE, &#8221;, TempExcelBuffer.&#8221;Cell SalesType&#8221;::Text);<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.AddColumn(&#8220;Sales Invoice Header&#8221;.&#8221;Sell-to Customer Name&#8221;, FALSE, &#8221;, FALSE, FALSE, FALSE, &#8221;, TempExcelBuffer.&#8221;Cell Type&#8221;::Text);<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.AddColumn(&#8220;Sales Invoice Header&#8221;.&#8221;Posting Date&#8221;, FALSE, &#8221;, FALSE, FALSE, FALSE, &#8221;, TempExcelBuffer.&#8221;Cell Type&#8221;::Number);<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.AddColumn(&#8220;Sales Invoice Header&#8221;.&#8221;No.&#8221;, FALSE, &#8221;, FALSE, FALSE, FALSE, &#8221;, TempExcelBuffer.&#8221;Cell Type&#8221;::Number);<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.AddColumn(&#8220;Sales Invoice Header&#8221;.Amount, FALSE, &#8221;, FALSE, FALSE, FALSE, &#8221;, TempExcelBuffer.&#8221;Cell Type&#8221;::Number);<br>\u00a0 \u00a0 end;<br>\u00a0 \u00a0 Local procedure CreateExcelBook();<br>\u00a0 \u00a0 begin<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.CreateNewBook(&#8216;SalesRegister&#8217;);<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.WriteSheet(&#8216;SalesRegister&#8217;, CompanyName, UserId);<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.CloseBook();<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.SetFriendlyFilename(&#8216;Sales Register&#8217;);<br>\u00a0 \u00a0 \u00a0 \u00a0 TempExcelBuffer.OpenExcel();<br>\u00a0 \u00a0 end;<br>\u00a0<br>}<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Note:<\/strong><br>When you add columns, you can choose some default font and cell type.<\/p>\n\n\n\n<p>AddColumn Function:procedure AddColumn(Value: Variant, IsFormula: Boolean, CommentText:Text,&nbsp;<strong>IsBold<\/strong>: Boolean,&nbsp;<strong>IsItalics<\/strong>: Boolean,&nbsp;<strong>IsUnderline<\/strong>: Boolean, NumFormat:Text[30], CellType: Option).<\/p>\n\n\n\n<hr class=\"wp-block-separator aligncenter is-style-wide\"\/>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-background\" style=\"background-color:#e7f5fe\"><tbody><tr><td><a href=\"https:\/\/erpconsultors.com\/d365-business-central-essentials-vs-premium\/\" target=\"_blank\" aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"rank-math-link\"><span class=\"has-inline-color has-black-color\">D365 Business Central Essentials vs Premium License<\/span><\/a><br><a href=\"https:\/\/erpconsultors.com\/usage-of-keys-in-business-central\/\" target=\"_blank\" aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"rank-math-link\"><span class=\"has-inline-color has-black-color\">Usage of Keys in Business Central<\/span><\/a><br><a href=\"https:\/\/erpconsultors.com\/move-fields-in-page-via-al-extension-in-bc-d365\/\" target=\"_blank\" aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"rank-math-link\"><span class=\"has-inline-color has-black-color\">How to Move fields in Page via AL Extension in D365 BC<\/span><\/a><br><a aria-label=\"Exporting Your Business Data to Excel (opens in a new tab)\" href=\"https:\/\/docs.microsoft.com\/en-us\/dynamics365\/business-central\/about-export-data\" target=\"_blank\" rel=\"noreferrer noopener\" class=\"rank-math-link\"><span class=\"has-inline-color has-black-color\">Exporting Your Business Data to Excel<\/span><\/a>&#8211; Microsoft Docs<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Export to Excel Report in Business Central: For creating \u201cExport to Excel Report\u201d, follow the below steps. For example- (1) Export Sales Invoice Header data via report. (2) Create New report already explained. (3) Add \u201cSales Invoice Header\u201d dataitem. (4) Create a Procedure for export data from the \u201cSales Invoice Header\u201d. MakeHeader. MakeBody. CreatExcelBook. (5) After following the above procedures. Then call these procedures on the &#8220;dataitem&#8221; and report triggers as shown. Call \u201cMakeHeader\u201d procedure. Call \u201cMakeBody\u201d procedure. Call \u201cCreateExcelBook\u201d procedure. After this create Request Page for filtering data on \u201cSales Invoice Header\u201d. After doing the above steps, Export to <\/p>\n","protected":false},"author":1,"featured_media":1837,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[172,175,173,176,174],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/10\/Create-Export-to-Excel-Report-in-Business-Central.jpg?fit=350%2C270&ssl=1","_links":{"self":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/1787"}],"collection":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/comments?post=1787"}],"version-history":[{"count":0,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/1787\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media\/1837"}],"wp:attachment":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media?parent=1787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/categories?post=1787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/tags?post=1787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}