Report – Pardaan.com

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,…

14 May 2024

Dynamics NAV & BC Tips & tricks

ELI5 Using a Report as an Email Body

This is one of the most fantastic ELI5 videos I have done. Cover multiple AL technologies, from reports, over temp blobs, streams and emails with a sprinkle of RecordRefs added. Check it out: Source : Hougaard.com Read more...

29 February 2024

Dynamics NAV & BC Tips & tricks

How to validate report selections in Business Central

Recently I had to validate some filter selections on a report in Business Central and found out it was not so straight forward to do. What happened when using the trigger OnPreDataItem() or trigger OnPreReport() triggers was that I was able to validate the filter selections…

4 January 2024

Dynamics NAV & BC Tips & tricks

Report extension’s tips and tricks

Probably, most of you have already encountered the report extension object to add desired modifications to the standard report in Microsoft Dynamics 365 Business Central. Depending on the complexity of your cases, you may have come across a number of implementation restrictions in the extension. In…

29 December 2023

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: Report Selection for standard documents (Set up default reports)

Today I would like to talk about how to set up default reports to use to print documents (Report Selection for standard documents) in Business Central. Source : Dynamics 365 Lab Read more...

19 December 2023

Dynamics NAV & BC Tips & tricks

Building an alternative to RDL, genius or madness?

I have never been a fan of RDL reporting. The process and tools are not intuitive or enable me to build what I need. Lately, I have been thinking about a new way of doing this, and in this video, I demo a prototype I built…

29 November 2023

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: How to specify the report layout before printing via AL (“Report Layout List 2000000234” not “Custom Report Layout 9650”)

Today I would like to talk about how to specify the report layout (“Report Layout List 2000000234”) before printing in AL. A few days ago, a partner asked me an interesting question, the customer wants to print different report layouts according to different conditions in the…

28 July 2023