O'Reilly logo

Microsoft Dynamics NAV 2015 Professional Reporting by Steven Renders

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The next step

So far, we have created reports that query the database directly. This is not always recommended, or possible. The most important reason for this is performance. If you have a lot of users running reports, it creates a significant load on the database server, which might even result in loss of performance for the users working in Dynamics NAV. There are several techniques to avoid this.

Caching

You can enable report caching mechanisms using the Report Manager application. When a user runs a report, the information is retrieved from the source database. This information can then be saved in the Reporting Services database so that the next time a user runs the same report, the information is retrieved from the cache instead of the source ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required