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 by user but the user experience was not optimal since the selection page closed when the validation error occured.

Source : D365 BC & Power Apps
Read more…

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 this article, we will review solutions to some simple restriction cases in report extensions and provide you with a few valuable tips in the process.

Source : Simplanova
Read more…

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 over the weekend of a new report layout engine. Check it out:

Source : Hougaard.com
Read more…

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 sales order, but the report is the same. Is there a way to deal with it?

Source : Dynamics 365 Lab
Read more…