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:
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?
In the world of ERP solutions, the capability to create reports and disseminate them across different systems is of paramount importance. This functionality becomes even more critical within platforms like Microsoft Dynamics 365 Business Central, celebrated for its robust reporting features.
If we want to answer a simple question in Business Central – “How many items we have in each location?” then there aren’t that many great built in reports available. There is the standard “Items by Location” report that is not that great. It doesn’t offer exporting, doesn’t offer filtering, you can’t see item values etc.