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

Adding a parameter for an external datasource query

This recipe will extend the previous recipe to add a parameter that will influence the data retrieved through the SQL query.

Getting Ready

This recipe requires that you have the Adventure Works database installed and you have ready access to the SQL server. This is a continuation of the report developed in the Building a report through an external datasource recipe in this chapter.

How to do it…

  1. Open the project and the report associated with the project.
  2. Select the dataset and open the query editor window to modify the query as shown here:
    SELECT NationalIDNumber, LoginID, JobTitle, BirthDate, MaritalStatus, Gender, HireDate, VacationHours, SickLeaveHours FROM HumanResources.Employee WHERE (NationalIDNumber ...

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