Tag: Management Reporter 2012

We had a call logged by a new customer recently who has just had Managagement Reporter implemented. One of the IT team was trying to get into Report Designer and continually got the message below;

I’ve seen this error before and it has been one of two things:

1. The Management Reporter 20123 Application Service isn’t running
2. The logged in Windows user has not been given access to Management Reporter

In this instance the problem was the latter. The IT team member’s own domain account was configured as a Management Reporter Administrator, but he was logged onto the server as Domain\Administrator which was not a Management Reporter user. After logging out and back in under his own domain account he was able to access Management Reporter successfully.

I was out on site a short time ago implementing Management Reporter 2012 for a client and ran into a problem with Management Reporter. I could log into Management Reporter, create reports and everything was fine; but I could not generate a report.

When I was investigating the problem I opened the Configuration Console and found that the Management Reporter 2012 Process Service was not running;

Continue reading “Management Reporter 2012 Process Service Not Running”

I was trying to install Management Reporter 2012 the other day and received an error message I’ve not seen before;

Continue reading “RDP Error Installing Management Reporter 2012”

These days I find that time passes far too quickly. Turns out it was on the 14th November that RU3 of Management Reporter was released and I said I’d do some posts on the web client part of it. Well, time flies but I’ve finally found the time to do the post I promised.

When I downloaded Management Reporter 2012 Rollup 3 I did what quite a few people seem to have done and looked for the web client installer within the setup utility. Well, it turns out there isn’t one as it is all handled by the server install. To view a report in the MR 2012 web client all you need to do is output the file to a network location or SharePoint. I’ve gone the easiest route and output the file to a network share.

In the Report Designer, open a Report Definition and switch to the Output and Distribution tab and change the radio button to Generate to multiple report library locations. In this case my report is being output to Library/P&L and if I click on it I can then choose to set a Related Report Link Location which I have set to the shared Dynamics Central location on my server;

Continue reading “Hands On With The Management Reporter 2012 Web Client”

On the 12th November, RU3 for Management Reporter 2012 was released.

Full information available here and it can be downloaded here.

Management Reporter 2012 RU3 brings a web client (reports can be deployed to a network share or to SharePoint depending on preference), the Financial Reporting Data Mart for Dynamics GP (good for dealing with large datasets), the ability to report against Dynamics GP General Ledger and Analytical Accounting information using a single company as well as more than 35 bugs.

I’ll be doing some more posts on MR 2012 RU3 over the coming couple of weeks so stay tuned.

I was on site with a client last week to do training on various parts of the system, one of which was Management Reporter.

Before the training started, I was alerted to the fact that Management Reporter had stopped working. We ran through a few issues such as the Microsoft Dynamics GP adapter disappearing from the Configuration Console (we re-added it), the Application Service was not running and couldn’t be started (it had been setup by the client using the Network Service and for some reason stopped working; we changed it to Local System and was able to restart the service but I’ve advised them to change both Management Reporter services to a Domain User account).

Once everything was set up and apparently working we encountered the final problem. When we tried to produce a report, it was added to the Management Reporter queue where it remained and did not move to a status of Processing.

I found a website discussing changing the SQL Server broker on the ManagementReporter database to true (and it was set to false) so I did this but no luck.

A little more prodding and poking at both Management Reporter and SQL Server, and I turned up the problem which was actually a fairly obvious one.

The ManagementReporter database was owned by Domain\Administrator. Running the below script to change the database owner to sa resolved the problem and allowed the reports to be processed;

Fortunately the investigation and resolution didn’t take a long time so we were able to do the full length training session.