web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Header Information in ...
Microsoft Dynamics GP (Archived)

Header Information in Body of Management Reporter Excel Exports

(0) ShareShare
ReportReport
Posted on by Jerry Bierema 155

Hello,

When exporting a report to excel, one has the option of exporting header and footer information.  However headers and footers do not appear in the body of the Excel worksheet and are only visible to the end user in the Page Layout view, not the Normal View.  Is there a method to move the header information into the body of the Excel Worksheet without using macros?

Thanks

Jerry

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Ryan Sandness Profile Picture
    Ryan Sandness on at

    Hi Jerry,

    The headers and footers are placed into the Excel Headers and Footers. In Excel 2010 this is in the following location:

    1. View | Page Layout - > Normal.

    2. Page Layout | Print Titles | Header/Footer

    I believe using the Header/Footer features in Excel gives a more consistent experience.

    I'm not sure if the end user knowing they can see this header in this location is sufficient. Otherwise you may want to log a suggestion on the Connect site if you think this should be displayed in a different or customizable manner.

    There may also be a way to configure Excel to make this view more visible that I am not aware of.

    Thanks

    Ryan

  • Jerry Bierema Profile Picture
    Jerry Bierema 155 on at

    Hi Ryan,

    Thanks for your response - the headers do show in the body of the Excel worksheet if you select to export to a single worksheet.  Just a new way of thinking about how to deploy the results.

    Thanks

    Jerry

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans