Knowledge is Key — SSRS with Dynamics AX

In this blog i have created a knowledge base for SSRS, which is really important now as Microsoft announces the future of AX Reporting is SSRS

What softwares do we need to start working on SSRS ?.
Visual Studio (for developing SSRS reports),
SQL SERVER with SSRS and SSAS (necessary for reporting, it should be configure properly as well),
Dynamics ax,
AX component for reporting, that will add the Visual studio template for Dynamics ax SSRS
How i can learn SSRS development with Dynamics AX?
Saveen Reddy, lead program manager for Dynamics AX Business Intelligence, acknowledges this difficulty in making the transition and has a series of posts on his blog, which might help developers and consultants alike “being productive”. Saveen also have recorded lots of Web cast related to SSRS, which is worth to watch for developers and consultants. Web casts can be access from his blog or from below link.

BI reporting

How we can debug the business logic in AX from SSRS report ?
There are certain steps that have to perform to debug the business Logic in AX. We have to use the ‘attach-to-the-server-process‘ approach using Visual studio. One approach to debug your business logic consist of the following steps
· Rebuild the report in VS in debug mode
· Save it back to the AOD
· Deploy the report
· Set a breakpoint at a strategic location in your business logic code
· Using Visual studio attach to the Dynamics ax server process
· Invoke your report
· Hit the breakpoint and start debugging
How can we call the SSRS report with AX menu item ?.
The basic steps
•Create an AX Query
•Create a new AX Reports Project and a new report in that project
•Create a dataset in the report bound to that query
•Create a design to report to render the dataset
•Preview the design
•Deploy the design to SSRS
•View the report via IE
•Save the Report project back into AX
Advertisements

One Response to Knowledge is Key — SSRS with Dynamics AX

  1. jie889 says:

    Hi Amir,

    I have done some modifications for several report (salesInovice, purchpurchaseOrder,prodpicklist…), when I am working with kanbanpicklist report, I could not debug. There is a temp table kanbanpageTmp, when i made modification in the method inserpiclinglist(), and running the report, I can see the modification which i have maken on the report, but when i set breakpoint in the method inserpiclinglist(), the break wont start.I have tried debugging from visual studio, but i could not see the processes ax32sev.exe. is that the problem I couldnot get the debgger work?

    Looking forward to receiving your reply!

    Thanks in advance!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: