How to add drilldown links to AX 2009 SQL reports?

Finance and Operations/AX User Forum
1

Hi all

I am trying to create some SQL reports from our AX database. I want to know how I can add links in the report which open up particular records in AX? eg if I have a customers account ID in the report, how do I open the customer account in AX from the SQL report?

Also, is it possible to add SQL reports into AX? Maybe on the homepage, or as part of a role center?

Cheers

2

This is an interesting question. I’ll have to see for myself some time if this can be done. The following article might help you to accomplish such:

How to open a form in a running Ax client from an external application
http://axcoder.blogspot.com/2010/10/how-to-open-form-in-running-ax-from.html

3

Hi Naz,

Regarding SSRS reports for Dynamics Ax, Saveen Reddy’s blog will get you started. In particular -

this - http://blogs.msdn.com/b/saveenr/archive/2008/10/24/dynamics-ax-2009-creating-a-simple-ssrs-report.aspx

this - http://blogs.msdn.com/b/saveenr/archive/2008/10/26/dynamics-ax-2009-launching-an-ssrs-report-from-the-dynamics-ax-client-ui.aspx AND

this - http://blogs.msdn.com/b/saveenr/archive/2008/11/05/dynamics-ax-2009-creating-an-ssrs-2008-report-that-gets-data-from-an-ax-cube.aspx

Best wishes,