Handling long-running reports in AX
Reports are used to render data from a couple of pages to a larger volume of copies. There can be many cases when a report may not render the data in an acceptable format, which can be identified using tools such as the Report Log Viewer. This recipe will list out the various approaches that can be used to manage performance-related issues in reports.
How to do it…
This section will discuss approaches to resolve long-running reports by adopting best practices at the time of design and at runtime through configuration changes.
Design-based resolution
The following actions can be taken to see if they improve the report performance. The modifications enlisted here are changes to the components involved in a report, and so must not be implemented in a production environment before taking the report through a testing cycle:
Reindex: If the report uses a query directly or uses one in RDP, see if the indexes have been properly used in the tables.
Restrict the data...
