Some reports from Reporting extensions can raise error when running on SQL 2008 R2

Thanks to our colleague in Japan we found problem when running some Dynamics AX reporting extensions report on SQL 2008 R2.

When we open some standard SSRS reports with SQL2008R2 (ie. TSInvoicedPurchaseAmount.TS_InvoicedPurchaseAmountDetail.Report ), we receive following error.

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset ‘InvoiceAmountDetailedReport’. (rsErrorExecutingCommand)
Query (58, 19) Parser: The syntax for ‘Item’ is incorrect.

This is because the Item is reserved word of MDX and execution is causing the error. So to fix the problem we need to change parameter name for DataSet ‘InvoiceAmountDetailedReport’.

Fortunately there are already hotfixes which fixed this problems:

KB2519061
TSInvoicedPurchaseAmount.TS_InvoicedPurchaseAmountDetail.Report
TSInvoicedPurchaseAmount.TS_InvoicedPurchaseAmountWebpart.Report

KB2520255
ProjCashFlow.ProjActualvsBudgetNetCashflow.XYChart
ProjCostControl.ProjTotalBudgetCost.LineChart
ProjHourUtilization.ProjUtilizationEfficiency.XYChart
ProjStatements.ProjActualvsBudgetConsumption.XYChart
ProjStatements.ProjActualvsBudgetCost.XYChart
ProjStatements.ProjActualvsBudgetGrossMargin.XYChart
ProjStatements.ProjActualvsBudgetNetWIP.XYChart
ProjStatements.ProjActualvsBudgetPayroll.XYChart
ProjStatements.ProjActualvsBudgetRevenue.XYChart

Right now both hotfixes are not published so please contact Support Team to get both hotfixes.

–author:	Yuji Imaoka
–editor:	Czesława Langowska
–date:	18/March/2011

Tags