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...
