Management Reporter formatting issue

(0) Share

Report

Posted on by jking

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

All responses (6)

Answers (0)

Derek Albaugh on at

Like (0)

Report

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 on at

Like (0)

Report

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 22,784 on at

Like (0)

Report

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 5 on at

Like (0)

Report

RE: Management Reporter formatting issue

I am having this same issue. Did you find a solution?
jking 85 on at

Like (0)

Report

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 on at

Like (0)

Report

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.