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

Building a report through an external datasource

In this recipe, we will create a report that connects to an Online Transaction Processing (OLTP) datasource and retrieves data through an SQL query. You will learn how to add a generic report datasource that can be used across all reports. The report here will retrieve the employee information from the Adventure Works sample database.

Getting Ready

In order to execute this recipe, you will need the Adventure Works database installed in the SQL server. This is available for free to download from Microsoft at http://technet.microsoft.com/en-us/library/ee873271.aspx.

How to do it…

  1. Open Visual Studio and create a project with the name AdventureWorkDatasoure. This project is created to hold the new report ...

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