Performance tuning in reports
Reports are the ultimate truth in the ERP system. The processes that are carried out inside the business logic and algorithms to calculate different values does not matter much to the user, all they need in the end is the report or document which provides the understanding of the data they feed the system. All they care about is fast running, good-looking reports. Even most projects heavily rely on the addition of many custom reports and/or the customization of existing reports to adjust to the needs of the client.
In reality, you must understand how bad reports with large runtime can affect the overall performance of the system. Let's discuss how we can tune up reports in Microsoft Dynamics NAV.