Book Image

Microsoft Dynamics NAV 2009: Professional Reporting

Book Image

Microsoft Dynamics NAV 2009: Professional Reporting

Overview of this book

Microsoft Dynamics NAV is widely used in enterprises with its enhanced reporting features, but there still isn’t a book that covers reporting in depth, until now. This book will show you what’s possible and exactly how to develop reports for Dynamics NAV 2009. Learn why reports are designed in a specific way and then apply this knowledge to your advantage. Microsoft Dynamics NAV 2009: Professional Reporting is an essential guide to understanding the effort involved in creating reports in Dynamics NAV 2009, and all of the available reporting possibilities. Reading this book will result in a better understanding and it will help you save time during development.The book starts with an overview of what kind of reports you can create without a developer using charts, dimensions, and analysis views. The next chapter will introduce the new architecture of Role Tailored Client (RTC) reports and the basics on how to create them or have them generated. Moving on we will discuss data visualization, where you will learn how and when to implement all the available Visual Studio controls. Document reports and other types of specific reports are covered next, and you will get to know all the best workarounds for getting them to work correctly.Knowing other related features is vitally important to obtain a helicopter view of all the reporting possibilities of Dynamics NAV, and the next chapter will introduce Business Intelligence concepts and available technologies that could be used in combination with the Dynamics NAV database. Technology is evolving rapidly and new versions of Dynamics NAV are in the pipeline, so the book will also provide you with a view to the future and how to prepare for it.
Table of Contents (15 chapters)
Microsoft Dynamics NAV 2009: Professional Reporting
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Index

Comparing RDL and RDLC


In this section, I will compare RDL and RDLC. Both technologies have their advantages and disadvantages and it is important to remember how to get the maximum out of both of them.

SSRS

Dynamics NAV RTC Reports

RDL

RDLC

Runs on SQL Server

Runs on Workstation/Laptop (Client)

Define Query in SQL:

  • T-SQL

  • Views

  • Stored Procedures

  • Functions, DMV, DMF, …

Define data items in Classic Report Designer:

  • Data Item(s)

  • C/AL Code

  • Views via Linked Object(s)

Multiple Datasets

Always one DataSet

Multiple DataSources (OLAP, OLTP, Other, …)

Always one DataSource

Can query multiple companies

Always one Company

No Flowfields, FlowFilters available. Instead you can create a SQL subquery, view, function, stored procedure,…

Can use FlowFields and FlowFilters

No multilanguage functionality, possible via: Expressions, View, Translation Table…

Multilanguage functionality out of the box

Parameters in report

Parameters in Request Page

Toolbox contains more items and data regions...