Tip #45 | NAV2015 | Report Temporary Property


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

Advertisements
This entry was posted in Tips and Tricks. Bookmark the permalink.

3 Responses to Tip #45 | NAV2015 | Report Temporary Property

  1. Pingback: Tip #45 | NAV2015 | Report Temporary Property - Mark Brummel - Author of Microsoft Dynamics NAV 2013 Application Design

  2. Pingback: Tip #45 | NAV2015 | Report Temporary Property | Pardaan.com

  3. Dorin Birsan says:

    Very nice. Thank you.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s