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

Creating reports by fetching the data using views

In this recipe, we will create views which will be used further on the maps to fetch the data in the RDP class for creating the SSRS report in Dynamics AX R3. Views are the virtual tables that contain the fields specified in the query as the data source of the view. Views store the data, made by joining the multiple data sources, as a table and can be reused in other X++ SQL statements.

Getting ready

This recipe is a continuation of the previously developed report in the recipe Creating reports by fetching the data using complex queries in this chapter.

How to do it…

  1. Right click on the AOT | Data Dictionary | Views node and select New View.
  2. Create a new view named PKTCustInvoiceTrans and add a data ...

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