One of the awesome new features of Microsoft Dynamics 365 Business Central 2021 Wave 1 (version 18) is the ability to extend reports. In this video I explore the simplest reportextension possible, adding a single field to the dataset of the standard invoice report.
One of the noisy limitations on Dynamics 365 Business Central until version 17.X was the impossibility to extend standard reports. If you want to add a simple new field to a standard report, you are forced to create an entire new report (new dataset), maybe from scratch or (better) by manually copying the standard dataset into a new .al file and then modifying it. You cannot handle the report dataset as an “extendible” object open for contributions between extensions.
In this video, I show how to start aggregating your design extensions into a single extension that’s managed with Visual Studio Code. This is a great way for customers consultants to get started with development and a great method for customers to organize the chaos.
Do you love reports? Personally, NO! 🙂 But that is, as a Business Central developer I think that sometimes (forced or not) you need to work with reports in your solutions.
As a quick recap, in Dynamics 365 Business Central a report layout controls content and format of the report, including which data fields of a report dataset appear on the report and how they are arranged, text style, images, and more.
As most of you, I guess know, it is not allowed to extend Business Central API’s. This page type cannot be extended by creating a page extension object. Instead, you must create a new API by adding a page object
However, sometimes we just need to send more data about the entity: Customer, Vendor, Sales/Purchase documents etc.