https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_a908fb56b928e7b5238867bdc9c9b2ea16c55d665a9df83b2d8f0693a32f1887926a74c1c2f4e4c941943ba400dee1943412f58006a495a9e810a568c06f96b5.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_2c8afe007ce38fe75a29ee62b4cebc5985bca42d0432cc65f4552709c4f3a93e0a0c7b4642a5087570e4b387ad4159d0ea4f1b8a705372c2e7630a1bbac58cc4.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_a238e70a1e55f9074fec487fcda2109ff9727c93c98de774759520f4a7b585ca50072b6240969ce2500fe0ceebddda6abc7201f942e11791b3771d67e55c5ec0.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_5e7f9127cd3194d52486d3db69427d088a53bb8cb6d6b38da5efb1a2d3e077b7e3d3e83f7292d1b0a55e625ccece4237b1810248c8db174e41a21882d3b73425.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_8b4f95f16b9448227b995f0057cd0102250b9561e1d44113c289ac4200a8b06f96bce038bbcea58301adb8c1d2c25c0ab747ebfb08459c1b0e439bf58e77a16e.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_6b9c7a1777d673840afb7532e61481653df38b73d222cb7649f89dc815e7b569a03011ca78f4800f791ff813da81f7a0be8691367dc75a812f3011398380c323.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_3d131e71dca14520ec804a0fc861b02cd3448867240047451659de511aca192b992e5c2bd76aea5d4ce00f4902e648fa9c10698ecea5d9a1719c5a224bc3d278.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_dd08be141c935e080e9aebab1a7da823650eafe28f73cc7d5961e142045a7d657f6c3cfc2f3d6b4dd1c09c49f677fe4badf6cfa78bcd183f719f8e2cec9a9773.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_df2c9bd99d621c126477aa3f1c5f929267dd2fb90062ec0bdc50bd8eda59f1c62d936af6e299c50bfd22004664cbe552a4f73f86e2ea37d746db71ef02c75218.js
Export to Excel Report in Business Central: For creating “Export to Excel Report”, follow the below steps. For example-
(1) Export Sales Invoice Header data via report.
(2) Create New report already explained.
(3) Add “Sales Invoice Header” dataitem.
(4) Create a Procedure for export data from the “Sales Invoice Header”.
(5) After following the above procedures. Then call these procedures on the “dataitem” and report triggers as shown.
Call “MakeHeader” procedure. Call “MakeBody” procedure. Call “CreateExcelBook” procedure. After this create Request Page for filtering data on “Sales Invoice Header”. After doing the above steps, Export to Excel Report developed and attached in the menu suit as per the preferred folder. Source Code of “Export to Excel Report”:
report 50001 “Sales Register” { UsageCategory = Administration; ApplicationArea = All; ProcessingOnly = True; dataset { dataitem(“Sales Invoice Header”; “Sales Invoice Header”) { DataItemTableView = SORTING(“No.”); trigger OnPreDataItem() begin//Date Filter SETFILTER(“Posting Date”, ‘%1..%2’, StartDate, EndDate); //Customer Filter if CustomerNo<> ” then setfilter(“Sell-to Customer No.”, CustomerNo); end; trigger OnAfterGetRecord() begin //Create Body or Line Part MakeBody; end; } } requestpage { layout { area(Content) { group(Options) { Caption = ‘Options’; field(CustomerNo; CustomerNo) { ApplicationArea = Basic, Suite; Caption = ‘Customer No.’; TableRelation = Customer; } field(StartDate; StartDate) { ApplicationArea = Basic, Suite; Caption = ‘Start Date’; } field(EndDate; EndDate) { ApplicationArea = Basic, Suite; Caption = ‘End Date’; } } } } actions { area(processing) { action(ActionName) { ApplicationArea = All; } } } } trigger OnPreReport() begin TempExcelBuffer.Reset(); TempExcelBuffer.DELETEALL(); IF StartDate = 0D THEN //Validation ERROR(‘Start Date must not be blank’);//Validation IF EndDate = 0D THEN //Validation ERROR(‘End Date must not be blank’);//Validation MakeHeader; //Create Header Part end; trigger OnPostReport() begin CreateExcelBook; // Create Excel Book end; var StartDate: Date; EndDate: Date; CustomerNo: Code[250]; TempExcelBuffer: Record “Excel Buffer” temporary; local procedure MakeHeader() var myInt: Integer; begin TempExcelBuffer.NewRow(); TempExcelBuffer.AddColumn(‘Customer No.’, FALSE, ”, TRUE, FALSE, TRUE, ”, TempExcelBuffer.”Cell Type”::Text); TempExcelBuffer.AddColumn(‘Customer Name’, FALSE, ”, TRUE, FALSE, TRUE, ”, TempExcelBuffer.”Cell Type”::Text); TempExcelBuffer.AddColumn(‘Invoice Date’, FALSE, ”, TRUE, FALSE, TRUE, ”, TempExcelBuffer.”Cell Type”::Text); TempExcelBuffer.AddColumn(‘Invoice No.’, FALSE, ”, TRUE, FALSE, TRUE, ”, TempExcelBuffer.”Cell Type”::Text); TempExcelBuffer.AddColumn(‘Amount’, FALSE, ”, TRUE, FALSE, TRUE, ”, TempExcelBuffer.”Cell Type”::Text); end; local procedure MakeBody() var myInt: Integer; begin TempExcelBuffer.NewRow(); TempExcelBuffer.AddColumn(“Sales Invoice Header”.”Sell-to Customer No.”, FALSE, ”, FALSE, FALSE, FALSE, ”, TempExcelBuffer.”Cell SalesType”::Text); TempExcelBuffer.AddColumn(“Sales Invoice Header”.”Sell-to Customer Name”, FALSE, ”, FALSE, FALSE, FALSE, ”, TempExcelBuffer.”Cell Type”::Text); TempExcelBuffer.AddColumn(“Sales Invoice Header”.”Posting Date”, FALSE, ”, FALSE, FALSE, FALSE, ”, TempExcelBuffer.”Cell Type”::Number); TempExcelBuffer.AddColumn(“Sales Invoice Header”.”No.”, FALSE, ”, FALSE, FALSE, FALSE, ”, TempExcelBuffer.”Cell Type”::Number); TempExcelBuffer.AddColumn(“Sales Invoice Header”.Amount, FALSE, ”, FALSE, FALSE, FALSE, ”, TempExcelBuffer.”Cell Type”::Number); end; Local procedure CreateExcelBook(); begin TempExcelBuffer.CreateNewBook(‘SalesRegister’); TempExcelBuffer.WriteSheet(‘SalesRegister’, CompanyName, UserId); TempExcelBuffer.CloseBook(); TempExcelBuffer.SetFriendlyFilename(‘Sales Register’); TempExcelBuffer.OpenExcel(); end; }
Note: When you add columns, you can choose some default font and cell type.
AddColumn Function:procedure AddColumn(Value: Variant, IsFormula: Boolean, CommentText:Text, IsBold : Boolean, IsItalics : Boolean, IsUnderline : Boolean, NumFormat:Text[30], CellType: Option).
We are leading Giants in the ERP Industry. We are specialists in Microsoft Dynamics NAV, Microsoft Dynamics 365 Business Central, and Microsoft Azure.
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_b4edcd5e09b8567e4d34ca5d4a0298720bbc9ed1562c789890a2501dce8b4cb7c6a4b3005d140340b745e8011e49dd7e9b177f95340b35569f100ca4486a183b.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_b4edcd5e09b8567e4d34ca5d4a0298720bbc9ed1562c789890a2501dce8b4cb7c6a4b3005d140340b745e8011e49dd7e9b177f95340b35569f100ca4486a183b.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_65cfde2c9a1160e3f8bdce516df72b5756b3619d2713091e9859c644b442c60272aefac9b6187a49b1bf2b1ba26423e966c54688962e6882e1e86263376b656f.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_b4edcd5e09b8567e4d34ca5d4a0298720bbc9ed1562c789890a2501dce8b4cb7c6a4b3005d140340b745e8011e49dd7e9b177f95340b35569f100ca4486a183b.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_b0373d3cb4403606e148aa5af648d9373e9f5e75094da38c5f851807f03d565e6482524415f99efaa5ab8fbde8359dcecea813a698d5dc1ef8134b436c47b06e.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_db1c913a83c88d8cab44e43ecf18124944f24630192845b02c79742d84415f2010e284908222c1b7b01b178656923edd4d8f04276d73b0ffb3772d6360b727d8.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_81d5be29eef5325d529144b1cf9522f7bf9b5d1e46d0edc720e8c2f5005699a07426cf9dffd209bd01f1328ee24d3f530a8c87ffb70650185dfaaf80cfd86ccb.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_5635a050070f452fbae05f45000a486de7552b60e86cecc95dfe0b4a8477a245f189236f36c1e58f5c08c92ea6f0c85946c891e6f159545f15a436276a13f385.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_8f5bf474531feade4e42bde551d3e6d289f99963b07d175aee05f60f236c4a7ac0a34959e937418dbed5eda3e3dab49b8fdc1a5d2d785d74a659484ab380d6eb.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_d150b59c99e69be0690552a524e5abcb757bfb295db7f3ec89459a525ab0ce710e94dfb07e169f8eac3fec251366d32c46f12c5659392c9c429087a1283754f5.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_adc337e56d6a8ef9ff77307d6e9b187369c8644b28cc89b1ae9669daca31a1e9f4c929cd6261c5208ec64d28970409b84de27ce9a3b1fd93639b57516a5799fa.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_1efecc32bc7c41e53459ab8c7be93f8d742b7d601b30bbd41aee7ef83bcc98257ea128b5b3ab7887ad26bf11daacfbee7e3439e452f7202c3ff065adfb59f928.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_7d866a1be92842f524adb73c6d465d31f4c719f48109dcec253f9df01a05d13c4bc30d88e6f6cf0e2a8ab6de64b63a18be0c262cf0c679f070ebb17aed0cee86.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_c6356a7dd6ba23fcdaa526fb0894fdce3519178652172ca04c7a0320abbbd59d5f5a77b7161f49079d22e0afbe844457721ea8d0cc0ea2162a7fb6f3b5cdf433.js
https://erpconsultors.com/wp-content/cache/breeze-minification/js/breeze_9575f6eace6602aa65000e19810824bee628f4e358fe1d603ce2ed362483ee7602a73b5d7431f06823645acf6f554c79536109a748782cd79960b175f5cb571d.js