Skip to main content
Post a question

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
News and Announcements icon
Community site session details

Community site session details

Session Id : V6uT/2DHh2bfoUWeCaOX57
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Management Reporter Li...
Microsoft Dynamics SL (Archived)

Management Reporter Linked to Excel

Like (0) ShareShare
ReportReport
Posted on 2 Aug 2012 18:29:47 by Gary Waylander 345
I have a Management Reporter financial report that has volume information in certain rows (which is obtained from an Excel spreadsheet with a tab for each entity in the reporting tree) and financial information in other rows of the report.  In the row definition the volume rows have a link to external worksheet defined in column” J” with the cell links defined in column “K”.  The column definition has a column type of FD.  In the Reporting Tree the worksheet link is defined in column “G”, the workbook path is in column “H”(the path is a mapped network drive) and the worksheet name is defined in column “I” for each entity in the tree.
When I run the report I get the following error:
”The report definition you have selected is linked to an Excel file M:\MR Files\Units.xls that could not be found.  The folder does not exist.”
I tried putting the spreadsheet in different locations, such as the “C” drive on the computer and the Management Reporter default file location with no luck.  What am I missing?  The help, training and examples I have been able to locate were of little use.

*This post is locked for comments

  • CFROTON Profile Picture
    CFROTON 4,710 on 17 Jul 2020 at 22:24:34
    RE: Management Reporter Linked to Excel

    Dear Brenda,

    I think they mean the location of the folder for Excel spreadsheet or export. Put the Service user with read/write or just use "Everyone" group.

    Best Regards,

    Jana MacDonald

  • Brenda Willey Profile Picture
    Brenda Willey 2,520 on 17 Jul 2020 at 18:50:04
    RE: Management Reporter Linked to Excel

    How to i find what the MR process service user has access to?

  • Bfor Profile Picture
    Bfor 15 on 09 Jan 2015 at 11:54:51
    RE: Management Reporter Linked to Excel

    Hi,

    We are encountering the same problem.  The user had full access to the location but after giving access to everyone/ domain users it worked.  Do you know which account we need to provide access to, for example the management reporter service account?

    Thanks

  • Suggested answer
    Bill Degnan Profile Picture
    Bill Degnan 656 on 08 Sep 2014 at 21:51:21
    RE: Management Reporter Linked to Excel

    I had to delete and recreate the lines in the reporting tree if any part of the path to the spreadsheet changed. Try to delete and recreate the lines in the reporting ttree.

  • Community Member Profile Picture
    Community Member on 08 Sep 2014 at 19:04:03
    RE: Management Reporter Linked to Excel

    Once I used a unc path it worked for me.

  • lmaykot Profile Picture
    lmaykot 15 on 24 May 2013 at 18:06:59
    RE: Management Reporter Linked to Excel

    I am having the same problem. I already tried using the UNC path, still same error. Now I am stuck, entering the data manually after the report is run. So much for automation.

    Why is it so hard for Microsoft to make something user-friendly? Every new step I make with MRS, I find another thing that is not necessarily as easy as the instructions say.

  • Butch Adams Profile Picture
    Butch Adams 4,761 on 10 Apr 2013 at 20:05:02
    RE: Management Reporter Linked to Excel

    Jacob,

    Since you think it isn't rights, is it by chance that someone has the Excel workbook open? a poorly formed or misspelled filename in the report? DNS name resolution?

    Look for anything that makes the file not locatable from the view of the user that is running the process service.

    ...b

  • jac_rod Profile Picture
    jac_rod 39 Moderator on 09 Apr 2013 at 19:03:03
    RE: Management Reporter Linked to Excel

    Anyone figure this out?  I'm running into exactly the same problem.  I'm pretty sure it's not rights, because a differnet error shows up if the process service doesn't have access to the folder (The current user does not have access to this folder).

    After saving the Excel file to the local drive that the MR installation is on, the report processes just fine.

  • Suggested answer
    cgust Profile Picture
    cgust on 15 Jan 2013 at 18:33:06
    Re: Management Reporter Linked to Excel

    If you need to designate a specific tab, there is a field in Management Reporter where you also can do that.  It doesn't go in the file path.

  • Suggested answer
    cgust Profile Picture
    cgust on 15 Jan 2013 at 18:29:37
    Re: Management Reporter Linked to Excel

    The Excel file needs to be in a location  where the MR Process service user has access to read it though - this could be the MR server, but other servers also might meet this criteria, depending upon how the server is set up.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,423 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,557 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans