Wednesday, 4 January 2012

Modify Microsoft Dynamics AX 2012 SSRS configuration files using PowerShell

This post is to highlight a pet project I have been working on. Working for a partner I frequently do new environment installations. AX 2012 allows you install multiple SSRS environments on the one machine but it can be tedious with the SSRS configuration file changes.
http://technet.microsoft.com/en-us/library/hh389762.aspx

I have scripted the process and loaded on here http://dax2012ssrs.codeplex.com.

Updated 26 March 2012:
Added permission issue
http://blogs.msdn.com/b/axsupport/archive/2012/02/02/microsoft-dynamics-ax-2012-reporting-extensions-error-system-security-permissions-environmentpermission-while-running-report.aspx

Updated 21 January 2013:
Added changes to be compatible with R2
http://dynamicsnavax.blogspot.com/2013/01/modify-microsoft-dynamics-ax-2012-r2.html

11 comments:

Skaue said...

Great stuff! Works like charm. Thanks for sharing.

Have you experienced that the report is running fine, but it simply does not load any data? It works fine for one of the instances, but the second instance loads the report but only the labels and no data.

Munib said...

Sorry for the late response but no. I haven't had that issue.
I have multiple environments running fine.

AxWonders said...

Hey man,

Do you think you can send me a quick instruction on how to edit the scripts? By edit, what do you mean? The SSRS instance?

I'm not a power shell guy and it would be great if you could help me out with this.

Thanks!

AxWonders said...

I got it man. Thanks!

Munib said...

Hey AxWonders,
As you found it was the path to the SSRS install folder that is changed at the top of each script.

I never got the time to making it a single script with a parameter you pass to it. That's possibly a future project. :-)

Anonymous said...

Hi, could you please send me the instruction of how to modify the scripts and run them?

I'm not familiar with power shell, hope you can help me out.

vikjon0 said...

Not sure what's up with the version on the site. You need a version 6.2 on the reportserver web.config and 2 of the files are backed up as config.xml and no date

Munib Ahmed said...

Hi vikjon0,
I have updated the version number to be compatible with AX2012 and AX2012 R2. See the latest on codeplex. I was updated last month.

With the backups. I haven't noticed that issue. If you can suggest a fix. Much appreciated.

Nag K said...

Hi Munib,

Does this work with SQL2012 SSRS?

I thought I better check before trying.

Nag

Munib Ahmed said...

Yep. Works and tested with SQL 2008 to SQL 2012.
AX 2012 RTM to AX 2012 R2.

Anonymous said...

Hi,
I am experiencing that the report is running fine in TST, but it simply does not load any data? It works fine for one of the instances, but the second instance loads the report but only the labels and no data. we have one report server/instance for both TST & DEV. Do we need to have multiple instances of report servers for multiple AOS instances (DEV & TST) Also ...
We have the issue with the Business Connector. I have verified the settings for the Microsoft Dynamics AX 2012 Configuration for the one of our client:
Local client has configuration = ‘AXR3_DEV’
Business Connector has configuration = ‘AXR3_TST’

Therefore, with these settings, we have not possibility to test SSRS reports in the DEV, but also we cannot deploy the SSRS reports in the TST.

If we change all parameters to the ‘AXR3_DEV’ we can use for developing and testing DEV, but we will not be able to test and deploy reports to the TST.
If we change these parameters to the ‘AXR3_TST’ – we will not be able to use the DEV for SSRS reports.