Use Excel to design layouts for reports
This content is archived and is not being updated. For the latest documentation, go to What's new and planned for Dynamics 365 Business Central. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.
|Enabled for||Public preview||General availability|
|Users, automatically||Apr 1, 2022||Apr 1, 2022|
Users can now use Excel to create and edit layouts for reports.
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 palette of capabilities in Excel such as sliders, diagrams, charts, and pivot tables.
To create an Excel layout from scratch, open the report request page, and then run the report with the option Excel document (data only). The report generates an Excel file with sample data and the fields that are available in the report definition. Then you add your layout to additional tabs in the Excel file. To test the layout, simply import it as a custom layout in Business Central. After the system has validated that the layout is valid for use, you can now go to the request page and run the report with your new layout.