Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

Management Reporter 2012 Link to Excel will not work following RU7 update

Posted on by Microsoft Employee

After updating Management Reporter 2012 to RU7 our existing links to Excel will not work.  Whenever a worksheet link is included for a node in the tree the report appears to complete normally with no errors.  The node is included in the report output but all data fields are blank.  When the worksheet link is removed the report is populated with SL data.  The Excel file is located on the MR server.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter 2012 Link to Excel will not work following RU7 update

    Butch,

    Thanks for you suggestion.  I re-installed the Access Database engine as well as the MR client but this did not resolve the issue.

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: Management Reporter 2012 Link to Excel will not work following RU7 update

    I think I would try reinstalling the Access database engine. It's possible the upgrade broke a .dll registration or something.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter 2012 Link to Excel will not work following RU7 update

    Yes.  The Excel file is located on the MR server and MR service account has permissions.  Prior to the CU7 update the link was working OK.  If the Excel file is located on a drive where the account does not have permissions it fails.  With the file on the server the report runs to completion but the report for the node that is linked has no data from the Excel file or the SL company.

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: Management Reporter 2012 Link to Excel will not work following RU7 update

    It runs without incident here.

    Does the AD account running the services have permissions to the Excel file and the folder it is in?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans