O'Reilly logo

Microsoft Dynamics AX 2012 R3 Reporting Cookbook by Deepak Agarwal, Chhavi Aggarwal, Kamalakannan Elangovan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9. Developing Reports with Complex Databases

The following recipes will be covered in this title:

  • Creating reports by fetching the data using complex queries
  • Creating reports by fetching the data using views
  • Creating reports by fetching the data using maps

Introduction

In the earlier chapters, we designed simple SSRS reports using queries or database tables. However, sometimes businesses need more analytical reports with a complex logic that would not be possible through queries or database tables. We need to use other AOT objects to develop such reports. In this chapter, we will develop the SSRS reports in Dynamics AX R3 using complex queries, views, and maps to fulfill business requirements. Using queries, maps, and views will help fetch ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required