Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Exporting Standard Rep...
Microsoft Dynamics GP (Archived)

Exporting Standard Reports to Excel

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

As System Admin for our Dynamics 2010 application, it has been brought to my attention that the end-user is unable to export directly to Excel.  There is an option in the menu bar under file to Export to Excel but it is grayed out and can't be accessed.  I have reviewed the Installation and System Administration guides, but have been unable to find a way to enable it. Can anyone shed any further light on this?

Thank you in advance for your time and assistance,

Joanne Herzog

jherzog@gcpud.org

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Exporting Standard Reports to Excel

    Soma,

    While it's true that you can print the report to a text file, opening it in Excel will yield a very ugly report indeed. I do not think I would call this 'exportable'.

    Kind regards,

    Leslsie

  • soma Profile Picture
    soma 24,406 on at
    RE: Exporting Standard Reports to Excel

    I think you can save the reports to "Tab-delimited file" format instead of exporting to excel and then use excel application to open this file.

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Exporting Standard Reports to Excel

    I learned something new.  I don't think I've ever run across a "self-enabling" button before.  It seems somewhat counter-intuitive that there would be a button present that can't be enabled.  However, thank you for your timely response.  I can now move this request to the "Done" column.

    Regards,

    Joanne

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Exporting Standard Reports to Excel

    Hi Joanne

    You cannot export the standard reports to Excel. If you print the report from a Report Options window, you can't export it. The Excel button enables itself when you select a report that is exportable. Things like the trial balances, posting reports, inventory turn, etc. are reports written in Report Writer that cannot be exported.

    An easy way to tell what it was written in is if when you print the report to the window and there is a 'Modify' button at the top of the window, you can't export it. If you launch the report from the Reports content pane on the Area pages, you can't export it.

    So, nothing's wrong with your system, all reports are not exportable. Plenty of other areas where you can export. SmartLists, Navigation Lists, or open one of the excel reports that come with the system.

    Hope this is what you need!

    Kind regard,

    Leslie

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