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

Surrogate fields in reports

The feature of surrogate keys that was introduced with AX 2012 is powerful, but at times creates ambiguity on their usage. A surrogate key is a key whose value has no meaning to people. A large number generated by the system, such as Recid, could be a surrogate key. The goal of this recipe is to clarify and showcase examples that use surrogate keys in possible patterns. This recipe is divided into two sections: the first section will discuss the usage of surrogate keys in a query-based report, followed by the section that details their application in RDP-based reports.

How to do it…

  1. To implement this recipe, we will use the example of student and student marks tables. Create these tables and relate the student marks table ...

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