Skip to content
Dynamics 365 Blog

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=10.0.0.0, 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

“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: http://msdn.microsoft.com/en-us/library/gg724119.aspx After that I have generated Precision Design and I have edited it to display parameter values with which the report was run:       I printed report in NL-BE language – parameters are not translated:       b. use the new created...

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