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
In Detail
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.
Steven Renders is a Microsoft Certified Trainer with skills that span the business and technical domains. He specializes in Microsoft Dynamics NAV and Microsoft SQL Server. He has more than 15 years of both business and technical experience. He provides training and consultancy that focuses on Microsoft Dynamics NAV, Microsoft SQL Server, business intelligence solutions, Microsoft SQL Server Reporting Services, and database performance tuning. Furthermore, he is also an expert in Microsoft Dynamics NAV, on which he has already delivered many training sessions. He was also the author of the official Microsoft training material on Dynamics NAV reporting, development, upgrading, and SQL Server performance tuning. He is the author of the books, Microsoft Dynamics NAV 2015 Professional Reporting and Microsoft Dynamics NAV 2009: Professional Reporting and also a reviewer of the books, Programming Microsoft Dynamics NAV 2009, Programming Microsoft Dynamics(R) NAV 2013, and Implementing Microsoft Dynamics NAV 2013. He has also presented at various Microsoft MSDN and TechNet conferences, NAV Techdays, communities, events, and the MCT Summit. In 2011, he started his own company, think about IT, which specializes in training and consultancy, helping companies learn, implement, understand, and solve complex business requirements related to IT, both in Belgium and abroad. His specialties are Microsoft Dynamics NAV, Microsoft SQL Server, Business Intelligence & Reporting, and Power BI. You can contact him at steven.renders@thinkaboutit.be and through his website (www.thinkaboutit.be). You can also view his LinkedIn profile at http: //be.linkedin.com/in/stevenrenders, and his Twitter handle is @srenders.
