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.
- Before they upgraded, the non-printing rows never appeared on the excel report
- 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
I have the same question (0)
