To troubleshoot Management Reporter 2012 report problems, go to the Windows Event Viewer to get additional information on the error. The Event Viewer can be found in Control Panel, under Administrative Tools. In Event Viewer, click Windows Logs and then click Application. Under the Source column look for Management Reporter Report Designer or Management Reporter 2012 Services. Client errors can be found at the workstation and MR Service errors can be found at the MR server. You may need to check the Event Viewer in one or both places.
Here is a list of errors received when the report error occurs and the possible associated error(s) in Event Viewer. Find your error in the list and use the appropriate Cause\Resolution sections.
Event Viewer messages:
Microsoft.Dynamics.Performance.Reporting.Engine.Server.WorksheetLinkAdapter.PopulateReportCellFromWorksheet(String workSheetName, ExcelWorkbook workBook, RowCriterion reportRowCriteria, ValueColumn reportValueColumn, WorksheetModifierType offset)
See Cause 1
See Cause 2
The Excel link in the row definition has an incorrect reference. See Resolution 1 in the “Resolution” section.
Summary level of tree has a mask in the Dimension column. See Resolution 2 in the “Resolution” section.
In the row definition, check the Excel links and verify they are not referencing a CALC column. For example, the row definition has a reference of @WKS(B=B2, C=C2). In the column definition, column C is a formatted as a CALC column. Excel data cannot be placed in a CALC column.
In the tree definition, remove any dimension restrictions from the Dimension column, at the summary level.