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.
Tag Archives: Report
Dynamics 365 Business Central: report extensions and global variables in preview mode
Today I received a call from a partner that was going crazy on a problem during the preview of some statistical reports in Dynamics 365 Business Central.
The report was a custom modification of an existing one (done via a reportextension object). In this reportextension, the partner added some global variables used to perform filters and actions on the report’s dataitem, but the report seems not working correctly on preview (global variables changed in the request page was cleared).
Dynamics 365 Business Central: How to build extension (Package/Publish) without generating report layout files??? – (“al.compilationOptions” -> “generateReportLayout”)
Today I would like to share a mini tip of Business Central, how to build extension (Package/Publish) without generating report layout files in VS Code.
When we create a new report, there are two main tasks to consider. First, we define the report dataset of data items and columns. Then, we design the report layout.
Using Isolated Storage on Report Extensions
Isolated Storage is a data storage that provides isolation between extensions, so that you can keep keys/values in one extension from being accessed from other extensions.
Getting Started With Reports and Report Extensions In Business Central
In this post you will learn how to start working with reports and report extensions in Microsoft Dynamics 365 Business Central. Also, you will learn 2 ways to import the report layout.
Dynamics 365 Business Central: How to substitute a report for another report via AL
Last week we discussed how to select a report layout before printing in Business Central. Today I would like to talk about another interesting topic about Report, how to substitute a report for another report via AL.
Dynamics 365 Business Central: Select a report layout before printing
Recently I was asked a very interesting question, is there any way to select a layout file when printing a report?
As you might know, we have powerful report management features in Business Central. We can manage and select the default layout for the report in the Report Layout Selection page.