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.

Creating new reports

While creating a report, you might have noticed that there are two major phases:

• Construction of dataset

• Creation of report layout

All other operations can be included in these two major phases. It is essential to understand the importance of understanding...