Search code examples
crystal-reportsaxaptadynamics-ax-2012

Crystal Reporting From AX Database


I am having an issue finding links within Crystal Reporting. I am trying to link 2 tables. However this seems to be a long task as I battle to find any links.

Is there a method that should be followed, as the most that have the same names to not link the tables correctly.


Solution

  • You should take a look on AX Data Dictionary Tables for the involved tables, then check the Relations node of the table. Any direct relation is usually on the child table. This of cause requires developer rights to the target AX system.

    Remember to join on DataAreaId and PartitionId as well. Always check if any appropriate index exist.

    Also the Reverse Engineering Tool may be of help.