Tag: Management Reporter 2012

I did a couple of posts a while ago on fixing the sample company reports (the first post fixed the Row and Column Definitions and the second the Reporting Tree Definitions), but there has been another issue with them that has been bugging me for a while.

The reports are configured to run for periods around the current system date, which means dates in 2013. But the Fabrikam sample company is in 2017 so the reports return no data. With Management Reporter storing its reports and configuration information on a SQL Server database, it is possible to tweak the reports to run for 2017.

I checked each of the reports to see how what Base period they were using and then worked out what I needed to update to set the reports to run for similar periods in 2017.

Continue reading “Fixing Base Period On Management Reporter Sample Company Reports”

A client reported a problem with Management Reporter returning incorrect figures when a link to the Financial Dimensions on the Row Definition had been entered in lower case.

The reports in question had been created in FRx which was rather more forgiving that Management Reporter is for these things. The client had quite a large number of reports which may, or may not, have had segments entered in lower case so the client didn’t want to have to check and update manually.

I again delved into the Management Reporter SQL database and updated the ControlRowCriteria table to capitalise the Low and High values of the link to financial dimensions using the script below:

Once the update had been run, the client checked their reports and confirmed that they were now returning the correct figures.

A client was recently having problems with the Microsoft Dynamics GP Datamart in Management Reporter 2012, so I removed the DDM and installed the Legacy GP Connector. I tested it on the server and all worked okay so I asked the user to try.

Unfortunately, it didn’t just work and they got the below error:

Management Reporter – Unable to connect to the ‘{company}’. The connection to the Microsoft Dynamics GP database failed. Contact your system administrator.

Continue reading “Management Reporter Is Unable To Connect To The Company”

We recently took on a new client who already had Microsoft Dynamics GP and had been migrated to Management Reporter before we took them on for support.

I did a little exercise of checking configuration and tidied up where needed. One item I found was two companies in Management Reporter which were not needed; these were the FW and FWC companies.

When I selected the first of them and hit delete, I received the following message:

Management Reporter 2012 – This company is referenced by an existing report definition or reporting tree definition. Remove these associations before deleting the company.

Continue reading “Can’t Delete Company In Management Reporter”

As you may have noticed I have been doing a fair bit of work recently with Management Reporter and this has involved a number of upgrades from FRx which has meant I have used the Migration Wizard a number of times.

When I used it a few weeks ago (screenshots taken at the time but I haven’t had time to post it until now) everything went well. I was able to view the report definitions and check that everything looked okay. However, I ran into a problem when it came to generating a report. Any report. I received the following message:

Management Reporter – Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled.

Continue reading “Bad Building Blocks – Error generating report in Management Reporter”

If you intend to use the FRx Migration Wizard when upgrading a client to Management Reporter then you need to have the Access Database Engine Redistributable installed on the same machine as the Migration Wizard.

And more than just having it installed, you need to have the correct version installed because in either case you will receive the following error:

Management Reporter – The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.

The important item to remember is that there are two versions of the redistributable; x86 and x64. The version required is the one which matches the operating system. So for example, an x64 OS with x86 Office, needs the x64 version installed.

A couple of days ago , the Dynamics PTS blog announced the release of Management Reporter 2012 Rollup 6.

This rollup has a range of new features including:

• The ability to generate a single report link for a report group and open all reports from a single page in the web viewer
• 14 new default reports for new Dynamics GP customers (existing customers can easily import these reports)
• Transaction descriptions greater than 100 characters are now supported
• Support for bi-directional text in Management Reporter Report Designer and Web Viewer

Partners can get more information here and download RU6 here.

Full details are available on the Dynamics PTS blog.

After dealing with an obscure and unhelpful Integration Manager error recently, I’ve also had a Management Reporter one; when trying to generate a report the following error was consistently produced;

An unknown error has occurred while processing report

Continue reading “Management Reporter – An Unknown Error Has Occurred”