Take Control of Your Data with Excel Report Layouts in Business Central

The 2024 Wave 1 release of Dynamics 365 Business Central made enhancements to Excel report layouts, letting users and developers create their own Excel layouts for reporting. This new feature goes beyond exporting data to Excel, which has been available since the Dynamics NAV days. Instead, it is an extension (Dynamics BC Excel Report) that provides the report along with the data from the report request pages. Data from multiple tables will appear in multiple worksheets.

Source : ArcherPoint
Read more…

D365 Business Central : Using Excel Layout for Reporting

Since Business Central 2022 Wave 1 (BC20), we have the ability to use Excel Layout for reporting. Excel layouts work the same way as Word and RDLC layouts in that they can be edited and saved back again into Business Central. With Excel layouts for Business Central reports, users can now create and edit report layouts simply by using the full capabilities in Excel such as sliders, diagrams, charts, and pivot tables. Let’s try to create one using Inventory Order Details.

Source : That NAV Guy
Read more…

Dynamics 365 Business Central: How to disable “Edit in Excel” on a specific page

With pages in Business Central that display a list of records in rows and columns, like a list of items, sale orders, or invoices, you can export the list to Microsoft Excel, and view it there. Depending on the page, you have two options for viewing in Excel.

Source : Dynamics 365 Lab
Read more…