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 layout

Now that we have seen how the dataset of a typical document report is generated, let's have a look at how we can create the layout.

Filtering the dataset

Since a document report contains several data items that contain information that needs to be displayed in different sections of the layout, you use separate tables (Tablix) to do that. But, by default, if you access a dataset field from a Tablix, the Tablix will loop over and show all the dataset records. That is why you need to assign a filter to each table, so that only those records that come from a specific data item are shown in the Tablix.

Open the layout for Report 206 Sales - Invoice and then open Document Outline, to see an overview:

You can see similar information in the report ...

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