With Microsoft Dynamics NAV 2015 Microsoft introduced a great new property on the Report object: Temporary.

This behaves the same as the SoureTableTemporary property on a page and basically eliminates the need of using integer dataitems and loops on reports.

It also makes it easier to use Query as a datasource for a report like I did for a page in this post:

https://markbrummel.wordpress.com/2013/09/10/tip-35-using-queries-in-pages-reports/

Lets repeat this exercise. We will use the same Query and Temporary Table and use in on a report instead.

The query combines sales information from the Value entries per customer.

And we create a class for the query as a table.

We need to define the table on a report and activate the new property

QueryOnReport

And since the table is now empty we need to populate it like the table on the page like this:

QueryOnReport2

Then after we created a Layout for the report:

QueryOnReport3

Voila, enjoy