Book Image

Microsoft Dynamics NAV 2015 Professional Reporting

By : Steven Renders
Book Image

Microsoft Dynamics NAV 2015 Professional Reporting

By: Steven Renders

Overview of this book

Table of Contents (19 chapters)
Microsoft Dynamics NAV 2015 Professional Reporting
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Index

Alternatives for building a faster dataset


I have always demonstrated building the dataset using data items that reference database tables or the integer data item. I will now demonstrate two techniques that you can apply to complex reports to improve report performance and also make the report easier to maintain.

Using a temporary table

The first technique is using a temporary table. This technique is used a lot in document reports and I might have mentioned it already very briefly in previous chapters.

A buffer table is a fancy name for a temporary table, or a table that is used as a temporary table. In Dynamics NAV, when you want to use a temporary table, you need to declare a variable that references an existing table and then set its temporary property to yes. You can also do that in a report, and up to version 2013 it was the only way to use temporary tables in reports. In version 2015, it's still possible, but there's an alternative. A data item has a new property named Temporary. You...