Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter fo...
Microsoft Dynamics GP (Archived)

Management Reporter formatting issue

(0) ShareShare
ReportReport
Posted on by jking 85

My company recently upgrade to Management Reporter after using FRx for several years. Our income statements always printed one page wide in landscape when you exporting into excel. Since upgrading it always defaults to two pages wide and no matter what i do in the settings i can't get to export to one page. Obviously is not hard to correct in excel, but it becomes an issue with larger trees that export many tabs. In FRx your heading was actually in the cells so if you made a multi-tab change to the formatting it didn't effect the header. Now that Management Report puts the heading in the worksheet header you can not modify multiple tabs at once because excel wants to make all the headers the same as well when you change the page layout. So this becomes quite annoying when i have 100+ tabs on a report and i have to change the page layout one by one. Can anyone help me resolve this issue?

Thanks

*This post is locked for comments

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Management Reporter formatting issue

    In the 4 years, have you tried opening a support case with the Dynamics GP - Analytics team who supports Management Reporter? If not, I would, as it most likely isn't a unique issue and they probably can provide you with at least a work-around if there isn't an actual fix.

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter formatting issue

    Sadly, 4 years later after upgrading to GP2016R2 and MR2012sp15 I am having this same issue. Why only us?

    All exported sheets print double sided. This is an issue as we are exporting over 100 sheets. Does anyone have a fix?

  • Suggested answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: Management Reporter formatting issue

    Check the page formatting; the default in ManRep is for Letter format with three quarter inch borders for each page.

  • JIRONS Profile Picture
    JIRONS 5 on at
    RE: Management Reporter formatting issue

    I am having this same issue.  Did you find a solution?

  • jking Profile Picture
    jking 85 on at
    RE: Management Reporter formatting issue

    I know how to use shift to select multiple tabs but it creates a problem when you change the page layout of the tabs now that the report titles are in the header as oppose to within the cells of your worksheet. If you change the page layout to multiple tab it will make all the tabs have the same header which creates more problems then it solves.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter formatting issue

    Select the first tab, hold down the Shift key and click on the last tab.  Then when you change the view, such as Normal view, it changes all tabs at once.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans