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) / MR - Non Printing rows
Microsoft Dynamics GP (Archived)

MR - Non Printing rows

(0) ShareShare
ReportReport
Posted on by Chris Flood 655

One of my customers has a report that displays all line items and totals correctly when they generate the report to the FRD viewer. However, when they export this report to Excel, the report contains hidden rows (which contain the data from the non-printing rows).

The client was recently upgraded from GP 2013 to 2013R2. 

  1. Before they upgraded, the non-printing rows never appeared on the excel report
  2. This is the first time they've run this report on 2013R2 where the non-printing rows are appearing as hidden rows in the excel report

I went into the Advanced Options and unmarked the option to include non printing rows, saved the change, and regenerated the report.  The non printing rows still appear on the exported report as hidden rows.

The good news is, the totals are correct and are not taking the non printing rows into consideration.  The client needs to prevent the non printing rows from appearing on the excel report to avoid additional maintenance and confusion when these reports are disseminated to various members of their organization.

What needs to be done to prevent the non printing rows from being included on the exported, excel report?

*This post is locked for comments

  • WSober Profile Picture
    WSober 10 on at
    RE: MR - Non Printing rows

    Making this modification solved the problem for me.

    The other boxes that we still have checked on the Output and Distribution tab are the Include headers and footers, Include format rows, and Include underscore rows within the Report Options section and the Include fonts and shading, Include comments and Include headers and footers in the Microsoft Excel options section.

  • Dae Profile Picture
    Dae 45 on at
    RE: MR - Non Printing rows

    Hello Chris,

    We are having the same issue. My users do not want to see the non-printing rows as hidden under the exported excel file.  Please let me know if you find a solution to this.

    Thank you!

  • Brenda Willey Profile Picture
    Brenda Willey 2,512 on at
    RE: MR - Non Printing rows

    I have done that and it is still exporting the non-printing rows.  I have also unchecked the Include detail for non-printing rows.   The detail level is set to Financial.  To be clear it exports them as hidden rows and they can be made visible just like any other hidden row or column in Excel.   Is there anyway to not export non-printing rows at all??

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: MR - Non Printing rows

    Try un-checking the option to "Include formulas" under the Output and Distribution tab. Having that option selected will include NP lines as hidden so that the formulas still work correctly once in Excel.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,403 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans