Visual Studio SSRS Report design with AX Classes and TMP table

Hello, I will try to explain how to design SSRS reports in Visual Studio and deploy to Axapta 2012 system...

You need to have a Visual Studio installation with the Dynamics Ax 2012 visual studio tools installed. To open the visual studio as connected to your AOS; you can use a modified shortcut.

To achieve this;

-          Go to your Visual Studio folder (standard is “C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\”)

-          Find “devenv.exe” and send a shortcut to your desktop.

-          Right click on shortcut è  properties and add the following command at the end of the “Target” field after leaving a space; “/AxConfig AXC file path”.  AXC file is the configuration file of the AOS you are using.

After this, open Visual Studio and select “New Project è Microsoft Dynamics AX è Report Model.”

On the right pane, you will see “Solution Explorer”. Right click on the solution and select “Add è Report”

You will see that a Report design will be open on the main screen. There is “DataSets” section that you will select your DP class and so your TMP table fields. Right click on Datasets and select “Add Dataset”.

Open the properties of your new Dataset and select “Data Source Type” è “Report Data Provider”. Then click on the three dots right end of the “Query”  row and selet your DP class and follow the instructions to add your return fields to your new design.

Now right click on the “Designs” tab and select add. Here you have 2 choices; you can select an AutoDesign or Precision Design. AutoDesign can be useful for fast debugging your code because you will just drag and drop your fields into a grid and your report is ready, but if you need a better looking report, Precision Design will be a better choice.

When you are done with the report designs just right click on the solution and select “Deploy Solution” to send the report to AX. Also, to send the VS solution to AX, again right click on the solution and select “Add report to AOT”. This will send the solution to AX system.

After all, you can use this report name and design name in your Controller class as to specifiy which report will be called.