Generate MR report to Sharepoint Location

(0) Share

Report

Posted on by babubaskaran@outloo...

Dear All,

I am trying to publish a MR report into a Sharpoint site with no success. I dont have any special characters on my output name and everything looks fine. Using same sharepoint site I am able to publish excel reports from GP. Following is the error on the MR Report Queue Status. Have anyone experienced this issue, if so how did you resolved it.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

babubaskaran@outloo... 12 on at

Like (0)

Report

Very sad to see no reply on these days. I was able to narrow down this issue, its related to sharepoint online doesn't work on MR but sharepoint onsite works fine. Again both are Microsoft product and we still having problem, it will be great anyone from Microsoft respond to this issue.

My next question is MR distribute the report on sharepoint as a link, is there anyway to generate excel directly from MR to sharepoint.

Was this reply helpful? Yes No
Suggested answer

Mike Bufano 1,484 on at

Like (0)

Report

Mr Baskaran,

I am sorry to hear that you are not able to publish your MR reports to SharePoint. We provide this service to our clients regularly.

You can deploy MR reports to SharePoint On prem or to SharePoint (0365).

One of the considerations is that the service account associated with the Management Reporter Services needs to have permissions to your SharePoint site.

The other SharePoint consideration is that the "link to document " content type needs to specified in the Document Library settings where you are trying to publish to. (see screenshot)

If you would like, send me an email and we can connect and I can discuss areas that you might want to investigate.

My email is mbufano@intellitecsolutions.com

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

Thank you very much Mike for your kind reply. Yes I have used the admin ID and added them into sharepoint as owner as well as I done the link to document. please see below screen shots. After doing all these the online version didnt worked and onsite did worked. Do you know is there any way to distribute excel from MR to sharepoint site.

Was this reply helpful? Yes No
Suggested answer

Mike Bufano 1,484 on at

Like (1)

Report

You will need to use a little imagination here. To publish MR reports to 0365 Sharepoint

You will need to use both OneDrive and Flow.

You will configure MR to publish the MR report hyperlink to OneDrive.

OneDrive (for the publishing user) will be copied to the cloud.

You will use Flow to then copy the hyperlink from OneDrive to the SharePoint site.

regards

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Mike,

Thanks for your kind reply. I am trying to publish the report to my one drive link and getting same error. following is my link which I have entered in MR.

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

Hi All,

I am surprised with this, does any of you used MR and publish report to Sharepoint online if so please help me. Can any engineer in Microsoft shed some light on this please. I am trying this for last 2 weeks with no luck. Just for your information the MR publish works onsite sharepoint but not online sharepoint. following is the list of things I have tested so far.

1) Online sharepoint publish report as MR admin not working

2) Onedrive sharepoint online publish report as MR admin not working

3) Onsite sharepoint publish report as MR admin as well as non Admin both works fine

Was this reply helpful? Yes No