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.