How to: Find the Data Source For a Report
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
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.
Note
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.
See also
Reporting in Microsoft Dynamics AX
How to: Create the Cross-Reference System