Hello all -
I recently assisted in the migration of a Microsoft Dynamics GP 2010 environment to Microsoft Dynamics GP 2013. We are encountering an issue when a user runs a report within Management Reporter and then attempts to save/export the report in Excel format.
In scenario 1 when the user attempts to save/export to Excel, they generate a report to Internet Explorer. Once the report is displayed in IE, they choose "Download"-->"Microsoft Excel" and are prompted with "You may be prompted to disable the pop-up blocker once the report starts to download. You can keep working in Management Reporter while it's downloading. Do you want to continue downloading your report?". The user clicks "Yes" and then they presented with an error of "The website cannot display the page" HTTP 500 with Internet Explorer and the Excel file is not generated.
In scenario 2, the user runs the report and views it within Management Reporter and they click on "Excel" to export the report, and an error is generated with the following message, "Management Report - Variable 0 has a data row value of 1 which was not found in the variableOffsets".
As a workaround, the user is generating a PDF report from Great Plains and then they are exporting the PDF to Excel. We are also able to run the report and save it in XPS format without any issues.
The current software versions of our Microsoft Dynamics GP 2013 environment are:
From what I’m reading, it looks like we are on the initial release version of Microsoft Management Reporter 2012 which was probably an oversight during the migration. From the description of the issue above, is this issue fixed in a hot fix for Management Reporter? Is there a patch I need to be on before updating to the latest hot fix for Mangement Reporter? If there is a hot fix that will resolve this issue, would it be a best practice to also update any of the other Microsoft Dynamics GP 2013 components in our environment? Thanks.
