Overview: Drill-Thru Support in Reports

  • Article
Microsoft Dynamics AX 2012

WHAT IS A DRILL THROUGH?

With regard to SSRS reports in Microsoft Dynamics AX 2012, a drill-though is a hyperlink embedded directly in the report content. These hyperlinks can be statically defined in the report definition or generated dynamically based on the reporting session context including user security rights, AX metadata, and configuration keys.

Supported URL targets:

  • Forms in the AX rich client
  • Enterprise Portal pages
  • Internet/intranet sites
  • SSRS reports

 

MULTIPLE CLIENT SUPPORT

The AX Reporting Framework is used to support both the rich client as well as the Enterprise Portal environment. AX Forms are accessed using references to Menu Items. The framework also takes care of determining the appropriate destination depending on the context of the report execution. SSRS Reports will direct users to an AX Form when rendered in the Report Viewer control and to an EP Web Part when rendered within the EP client.

Report developers are able to alter the textual formatting and styles used by report navigation links across all AX Reports directly in the report style templates. These settings are honored by the Auto Design templates and will be maintained when transitioning to a Precision Design.

MULTIPLE CONTEXT INDEXES

Most AX Forms rely on a single field reference to establish the navigation context. For instance, you can identify which Customer to high-light in the Customer Details Form using just the Customer Account. This is an example of context derived from a single index. However, there are objects that require multiple field references to establish the navigation context. The Main Account table is a perfect example since it requires both the Main Account ID in addition to the Ledger Chart Of Accounts ID to establish context for a single record.

To provide this flexibility, the AX Reporting Framework allows for a varying number of context arguments to facilitate navigation to an AX Form or EP Web Part.