Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

Installing Reporting Services extensions on SQL Server 2014

Hello, When installing Reporting Services extensions on SQL Server 2014 you may run into this error: “Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. An operation is not legal in the current state. (Exception from HRESULT: 0x80131509)”. To resolve this issue you should install the following components of SQL 2008 R2… Read more

AX 2012 Pre-requisite checker sees both the OLD SQL and the upgraded SQL instance.

Issue – I have a sql server that we have upgrade from SQL 2008 R2 to SQL 2012 SP1 and am attempting to install the AX 2012 R2 report extenstions. The pre-req checker recognizes both SQL 2012 and SQL 2008, even though SQL 2008 has been upgraded to SQL 2012 and no SQL 2008 instances are… Read more

Dynamics AX 2012 Reporting: How to add company logo into query based report

In the old X++ framework (Dynamics AX 2009 and earlier) when you wanted to display company logo on report you could use display method on table. In Dynamics AX 2012 that would not work. For RDP reports you could add CompanyLogo field into temporary table and then fill it in Data Provider class (for details… Read more

"Parameter is missing a value" error running a customized report in Microsoft Dynamics AX 2012

A Microsoft Dynamics AX 2012 report with a new parameter added to the contract may fail with the following error: The ‘ParameterName’ parameter is missing a value For example: The ‘SalesPackingSlipHeaderDS_FromDate’ parameter is missing a value   This error is thrown because no value is provided for the parameter in the contract while it is… Read more

Microsoft Dynamics AX 2012 Reporting: How to translate parameters values

Sometime ago I run into following problem. I followed step provided in msdn article: After that I have generated Precision Design and I have edited it to display parameter values with which the report was run:              3. I deployed report and created display menu item and opened the report –        I specified… Read more

AX 2012 – Proper configuration usage is critical when you have multiple Dynamics AX 2012 environments

Hi all, Lately in support we have been getting lots of questions that tie back to configuration usage.  This can manifest itself in many different ways: Not finding an object to use as a report datasource in Visual Studio 2010 while the object shows up in the AOT. Attempting to deploy a report and it… Read more

Unable to deploy AX 2012 Reporting Extensions on SQL Server 2012 Reporting Server

We came across an issue where we had: – a new server that never had Microsoft SQL Server 2008/2008 R2 or SQL Server 2012 ever installed – we were using a Microsoft Dynamics AX 2012 Installation files from a network share to install the AX Reporting Extensions – In the updates folder inside the installation share, we… Read more

Microsoft Dynamics AX 2012 Reporting extensions: Error System.Security.Permissions.SecurityPermission while running report

Sometimes we can see that when running some Reporting Services report (ie: TS_DeliveryPerformanceWebPart.Report we get error System.Security.Permissions.SecurityPermission Aditionaly in Microsoft SQL Reporting Services log you can see following error ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ‘ConfirmDateParameterValues’. —> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.Security.SecurityException: System.Security.Permissions.SecurityPermission… Read more