Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

User Excel Reports not being displayed

Posted on by Microsoft Employee

I've deployed Excel Reports in GP 2013. I have set the user level reports directory and have saved a report to it. However, this new report is not being displayed in GP for the user. I'm stumped what to look for. I've doubled checked the folder locations to ensure they are spelled the same.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: User Excel Reports not being displayed

    I should clarify. The report itself works. It's not being displayed in the list with the other Excel reports in GP.

    I did find my answer. The folder structure must match on the share and user directory. For example, if the files on the share are ...\[company name]\Sales then you must create ..\[company name]\Sales in the user location as well. While I see the necessity, it's not anywhere in the documentation I can find.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: User Excel Reports not being displayed

    I did not not. I assumed since I did a Save-As on an out of the box report, it would just reference that ODC for the out of the box report. Is this wrong? Do I have to put the ODC file in the user folder too?

  • RE: User Excel Reports not being displayed

    Hi George,

    When you created this report did you create an ODC file as well? The ODC file is the connection between the report and SQL which refreshes the data.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: User Excel Reports not being displayed

    Yes, it is. I took an out of the box one, hide a column (just for testing) and saved in the user location.

  • RE: User Excel Reports not being displayed

    Is this a custom report that you have placed in the location where you deployed the Excel Reports?

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans