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

Trans headers and footers


In Dynamics NAV, before version 2009, in the classic client, the report layout was developed in what was called the Section Designer. This was a layout designer that was optimized to create simple ERP types of reports without using data visualizations, though it contained some nice features that we use a lot in ERP reports. Two of these features are transheader and transfooter, sometimes also referred to as transport or running totals.

The idea behind it is that, when report information spans over multiple pages, you add a row (or a textbox or another report item) to the top of the next page that contains a total of the information that was shown in the previous page. Similarly, at the bottom of the page, you can also display a page total. You need to use an expression in the rdlc report layout, because there are no transheader of transfooter report items in the toolbox.

What you need is some kind of variable that can contain a page total (one or multiple) for...