Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Microsoft Dynamics NAV 2015 Professional Reporting

You're reading from   Microsoft Dynamics NAV 2015 Professional Reporting Discover tips and trick for Dynamics NAV report building

Arrow left icon
Product type Paperback
Published in Sep 2015
Publisher Packt
ISBN-13 9781785284731
Length 504 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Steven Renders Steven Renders
Author Profile Icon Steven Renders
Steven Renders
Arrow right icon
View More author details
Toc

Table of Contents (13) Chapters Close

Preface 1. How Do I Start to Create a Report? FREE CHAPTER 2. Getting Started with the Tablix 3. Expressions 4. Data Visualization Techniques 5. Document Reports 6. Tips and Tricks 7. Performance Optimization Techniques 8. Word Report Layouts 9. Power BI 10. Reporting Services 11. Charts in Dynamics NAV Index

Using a report setup table


Sometimes, when you create a report, you also create a request page, so that the user can set up the report layout according to options they specify in the Options tab of the request page. Similarly, you can also create a report setup table that contains information about the report layout. You can then create a page so that users can change the fields in this table, because the information is stored in a table. Then, when you create a report, you can query this table to fetch the information that you will use in the report layout.

There's actually already an example of this principle used in document reports. You might remember the company logo that can be hidden or displayed on the left, middle or top of a document. The field is stored in the Sales and Receivables Setup table and is named Logo Position on Documents. The logo is placed in the dataset and displayed on the left, middle or right of the report header depending on its value, in the OnPreReport trigger...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image