Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / MR CU 10 now exports N...
Microsoft Dynamics GP (Archived)

MR CU 10 now exports NP rows to excel - why?

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

Although I have a fond respect to the new features of CU 10 release and its hot fixes 1 and 2 for Management Reporter 2012 I do not understand why Microsoft have now introduced the functionality to export Non printed (NP) rows to Excel.

1. Set a row with data to use print control NP

2. run report and export to excel

3. The Line that was set to NP is now on the excel file but hidden

Anyone else having this issue.  This issue prevents client on CU 9 or less from upgrading to CU 10 where they use Management Reporter to export reports to excel to integrate with other systems.

*This post is locked for comments

  • Diane Seider Profile Picture
    Diane Seider on at
    RE: MR CU 10 now exports NP rows to excel - why?

    We also just ran into this issue with a client.  They are in fact on CU 13 but when they uncheck the box to export formulas - the NP rows are still exported to excel.  Does any one know if this has been fixe beyond CU13 or if it is scheduled to be fixed in a future release?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MR CU 10 now exports NP rows to excel - why?

    In CU13 if you uncheck the 'Include formulas' checkbox the NP rows are not exported to Excel.

  • Suggested answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: MR CU 10 now exports NP rows to excel - why?

    As of CU10 Management Reporter can export formulas to Excel; as a result non printing rows need to be exported as the formula would include the numbers for non printing rows and Excel can only do so if the row is exported.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MR CU 10 now exports NP rows to excel - why?

    There are a number of clients in the same position where they export documents to excel for integration with other systems.  If they do not offer an option to exclude this in the export, the approach looks to be that we need to redesign certain reports so that they export out correctly - i.e. possibly using a linked report etc to get the detail instead of hiding the rows above .

  • kdraper Profile Picture
    kdraper on at
    RE: MR CU 10 now exports NP rows to excel - why?

    Yeah, I hope they give an option not to export NP to Excel, this is a problem for the users.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: MR CU 10 now exports NP rows to excel - why?

    Hello M.Nunes

    That's the standard export functionality introduced in CU 10, the Non-printing rows are exported and kept hidden. I am not aware if there is anyway to prevent that, but I don't think so .

    >> Reference: Export a report in Desktop Viewer

    Your feedback is highly appreciated,

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans