Lightning Report Export, "Formatted Report" for "Summary Report" does not respect "Show and Hide" configuration for "Record Count" and "Subtotal"
Last updated 2020-12-02 ·Reference W-5402516 ·Reported By 101 users
Summary
Lightning Report Export, "Formatted Report" for "Summary Report" does not respect "Show and Hide" configuration for "Record Count" and "Subtotal".
When the report is exported in Excel format it had "Record Count" column (though empty but with column header) and "Subtotal" values of each group, though they were turned off on the report wizard on frontend.
Repro
1) Login to Lighting Enabled org
2) Click [Reports] tab and click [New Rport]
3) Select [Opportunities] report type, click [Continue]
4) Click "All Time."
5) Add "Close Date" and "Won" to "GROUP ROWS"
6) Only add "# Amumount" on "Colums".
7) Check "Sum" on "# Amumount", and click [Apply]
8) Turn off "Row Counts", "Detail Rows", "Subtotal" and "Grand Total"
9) Click [Save] to save the report.
10) Click [Run]
11) Click "â–¼" -> [Export]
12) Select "Formatted Report", click [Export]
13) Open generated report, Exported report had "Record Count" and "Subtotals" even they were turned off on the frontend wizard.
Workaround
N/A
Reported By (101)



























Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.