v2019 client (just upgraded from v2016), exporting A/R Aging to Excel via "Microsoft Excel (97-2003)" (i.e. 'report format'; non-data-only) now has the column headings repeating for each page whereas v2016 does not and only has the column headings once near the top. And it does not appear that the available settings/options at time of exporting have any impact on this.
I have determined this to relate to the A/R Aging Crystal .rpt file in the newer version of Sage 100 (and fyi the A/P Aging as well has changed, and possibly others). Although it looks like we could technically just copy in the Aging file from the client's prior system, I'm not necessarily recommending that, and therefore it would seem to likely make the most sense to just create an additional modified version of this standard report with suppressed duplicated column headers, specifically for this exporting routine. I believe it'd just be these two quick changes to the .rpt:
- PHb remove section's conditional/formula suppression
- GH2b enable section's hard-suppression and remove section's conditional/formula suppression
------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
------------------------------