We have sales reports that show company and month by month sales.
The detail section consists of ALL invoices, grouped by company.
The company footer shows the sum of the invoiced amounts month by month.
The detail section is selected as "Not visible".
So the report shows the companies and month by month sales.
When exported to Excel, because the detail section is hidden, no data is exported at all.
I guess I could perform the summation of the data at the SQL level, but the report runs fine. It just won't export to a spreadsheet.
Any other approaches?