O'Reilly logo

Microsoft Dynamics AX 2012 Reporting Cookbook by 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

Using a query as a datasource in a report

A query is the simplest way to fetch data for a report. Queries are beneficial as they are reusable and are easy to design. This recipe will guide you in creating a query in the AOT with the necessary optimization for a report datasource. The later part will guide you through creating a Visual Studio project for report development and use the query created to create a report datasource.

Getting ready

To work through this recipe, AX 2012 or AX 2012 R2 rich client with developer permission is required.

How to do it...

You can use a query as a datasource in the report, as follows:

  1. Open the AX Development Workspace.
  2. Navigate to AOT | Queries, right-click and select New Query.
  3. Rename the query to PKTReleasedProducts ...

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