Wednesday, March 20, 2013

Dynamics AX 2009 SSRS reports


          Q: Is there an error while trying to deploy Dynamics AX 2009 SSRS reports?


A: Here are the checkpoints:

1) See if all the prerequisites have been installed for Report Server. (Windows SDK, Microsoft Visual Studio 2008 Shell Re-distributable package - Isolated mode, reporting extensions)

2) Check your Reporting Services Configuration Manager - In the Service Account - you must select the second option- "Use another account and provide the proper credentials". Once done, apply the settings.

3) Now run the Report Service Web Service URL's under "Web Service URL tab" and check it's opening correctly. Make sure that the dynamics folder exists.

4) If Dynamics Folder doesn't exist, go to MSDAX 2009 and under Administration >> Setup >> Business Analysis >> Reporting Services open Reporting Servers. Now make sure you have the record created. Then click on "Create" button to create the new Dynamics Folder. You can cross check it by re-visiting the Reports URL in IE. You will find the dynamics folder.

5) Now go to Report Server and run the Setup Microsoft Dynamics AX 2009 Reports Deployment as administrator. Click on single report and deploy. The reports will deploy and you can verify the same in report manger URL.
If you have a question about Dynamics AX that you would like answered, please email us. Or visit the BWIR website for more information about the company.

 

No comments:

Post a Comment