Export (0) Print
Expand All

How to: Find the Data Source For a Report [AX 2012]

Updated: September 20, 2011

Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

This topic describes how to find the report data source information from the Application Object Tree (AOT). A report data source can be one of the following:

  • query

  • business logic

  • report data provider

  • AX enum provider

You can also find a report that uses a specific data source as opposed to finding the data source that a report uses. For example, you may want to know which reports use a specific data source.

NoteNote

You must generate cross-reference information for your application before you can find the data source for a report. The data source will not display if the cross-reference system does not exist or is out of date.

For more information, see How to: Create the Cross-Reference System.

For information on the data source of a report, see How to: Define a Report Dataset.

To find the data source

  • In the AOT, expand the SSRS Reports node, expand the Reports node, right-click the report for which you want to find the data source, click Add-ins, click Cross-reference, and then click Using (instant view). The data source for the report will display in the Complete cross-reference for the selected nodes form.

To determine the report that is using a data source

  • In the AOT, right-click the data source. For example, in the Data Dictionary > Tables node, right-click the CustTable table, click Add-ins, click Cross-reference, and then click Used By. The reports that use the CustTable table as a data source display.

Community Additions

ADD
Show:
© 2014 Microsoft