Now recently I came across a post from Bert De Temmerman on Yammer: https://www.yammer.com/dynamicsnavdev/threads/736254082498560 and that got my inspiration flowing…
He suggests that when you add this action to the “Report Layout Selection” page, you can export any dataset by first running the request-page:
So let us focus on the Developing report in Microsoft Dynamics Business Central MSDYN365BC. The format is mentioned in the Blog 01 – Customer Requirement for AL Development 2.5 Interface Report.
In this video, I show how to customize a standard report in Microsoft Dynamics 365 Business Central.
In Microsoft Dynamics 365 Business Central, we have a more intuitive and faster way to create new Power BI reports that you can share with other users in Business Central. In this webinar, you will learn how to create and embed a Power BI report and learn about the options in Business Central to enable Power BI reports to end users.
Before we go any further, I don’t want you to go and change your reports if you’re not going to get any benefit from doing so. Use Performance Analyzer (as shown here) to determine which visuals on your report are the cause of slow performance – there’s no point redesigning visuals that are fast anyway.
Performance wise it can be very interesting to use query objects as a data-source in a report (or any other object).
Imagine you want to create a report that shows the top X records from a table, let’s say for example Customers, then creating a report dataset with a top-x filtering can be very cumbersome.
It is possible to substitute reports from the base application with “custom reports“. Great!
This can be done by subscribing to the “OnAfterSubstituteReport” event published by “Codeunit 44 – ReportManagement“.
Source : Roberto Stefanetti NAV & Business Central Blog
Read more…