Discover tips and trick for Dynamics NAV report building
About This Book
Create and customize reports in Dynamics NAV 2015 using RDLC, Word, Power BI, and Reporting Services
Work with different elements in the toolbox such as tablix, which can be used as a List, Table, or Matrix and understand the differences between them and when to use which
This book is a pragmatic guide with clear instructions and real-world examples to teach you about the reporting capabilities of Dynamics NAV 2015
Who This Book Is For
If you are a consultant, developer, customer, user, or just interested in the reporting capabilities of Dynamics NAV, then this book is for you.
Basic knowledge of Dynamics NAV will be helpful.
What You Will Learn
Understand why reports are designed in a specific way and then apply this knowledge to your advantage
Develop document reports using different techniques
Apply filtering and sorting, and create groups
Use RDLC to visualize information
Visualize information, KPIs, and trends using expressions, Gauges, Charts, Data bars, Indicators, and Spark lines
Create and optimize your dataset for RDLC and for Word layouts
Use Power BI with Dynamics NAV to bring your data to life
Build Reporting Services reports on top of Dynamics NAV
Microsoft Dynamics NAV is a multi-lingual, multi-currency business management solution that organizations use to manage their accounts, supply chain, sales, payroll, and HR. It is an ERP tool for organizations that is fast to implement, easy to configure, and simple to use. It is widely used because simplicity is a part of its development, product design, usability, and implementation.
This book will help you to master, analyze, and deliver the most challenging reporting requirements in Dynamics NAV 2015.
The book starts by explaining report development and it's different phases such as data model, layout, and testing you go through. It introduces you to RDLC and the different controls in the toolbox, such as the Tablix, in its many forms. You will learn to use expressions to make your layout dynamic and to overcome typical problems.
Moving on, the book will teach you to visualize data and be able to understand and read a report as it is intended. You will also learn to use Microsoft Word to create a layout for a report. With Power BI and Power Pivot, Power View, and Power Map, you will learn how easy and powerful it is to bring your data to life, so you can spot trends and perform in depth analysis of your business. Reporting Services is also explained as another way that you can apply the knowledge you have about RDLC to build RDL layouts outside of Dynamics NAV.
By the end, you will create different types of charts so you can visualize key performance indicators inside the Dynamics NAV application.
Style and approach
This book is an essential guide in to understanding what is involved in creating reports in Dynamics NAV and its reporting capabilities.
Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the code file.