Skip to main content

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

Comments

tommy.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 Ahmed 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 Ahmed 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.

Popular posts from this blog

AX - How to use Map and MapEnumerator

Similar to Set class, Map class allows you to associate one value (the key) with another value. Both the key and value can be any valid X++ type, including objects. The types of the key and the value are specified in the declaration of the map. The way in which maps are implemented means that access to the values is very fast.
Below is a sample code that sets and retrieves values from a map.
static void checkItemNameAliasDuplicate(Args _args) { inventTable inventTable; Map map; MapEnumerator mapEnumerator; NameAlias nameAlias; int counter = 0; ; map = new Map(Types::String, Types::Integer); //store into map while select inventTable { nameAlias = inventTable.NameAlias; if (!map.exists(nameAlias)) { map.insert(nameAlias, 1); } else { map.insert(nameAlias, map.lookup(nameAlias) + 1); } } //retrieve from…

Azure DevOps Release Pipeline–Walkthrough

It is a great start to 2019. Joris from Microsoft has welcomed the year with the release of the Azure DevOps Release Pipeline task on the marketplace. Official blog:https://community.dynamics.com/365/financeandoperations/b/newdynamicsax/archive/2019/01/18/first-azure-devops-task-released Addition blog:https://daxmusings.codecrib.com/2019/01/azure-devops-release-pipeline.html I thought I would do a walkthrough for those that haven’t had a chance to play with it yet.
New release pipeline In Azure DevOps, click on the New release pipeline.
You will get an option to select from a template. Just select “Empty Job”. In the first stage, make sure the Agent job is using “Hosted VS 2017”.

In the Agent job click on the + icon to add a task. Select the LCS Asset Upload task. If you don’t see, then you have not installed it. Just select the “Dynamics 365 Unified Operations Tools” link at the bottom. Otherwise, install from here https://marketplace.visualstudio.com/items?itemName=Dyn365FinOps.dynamics36…

Detailed guide on creating Business Events with Azure Service Bus

I have been working with the new Business Events feature released in FinOps and you should read the docs site first.
This blog post focuses primarily on setting up Azure Service Bus endpoint. Setting up the Azure services can be tricky if you are not familiar with Azure Key Vault and application registrations.
I have sequenced the post so that you don't have to jump around. There are four key elements to this: Create the app registrationCreate the service busCreate the key vault secretConfigure FinOps Create an App Registration In the Azure Portal, navigate to the Azure Active Directory menu. Click on App registrations (there is the old one and the preview menu - they are the same but the UI is a bit different). I will show the original App registrations way.


Create a new Web app/API registration and give it a name. It doesn’t really matter in our case what the sign-on url is.




Take note of the Application ID as you will need it later for setting up the Business Event.

Under the Ke…