Excel Formulas for Report Totals
If the report:
- Uses the generic sub-total and total calculations, outputting the
report to an Excel spreadsheet converts the calculations to Excel
column formulas.
- Does not use the Report Designer's generic calculations, the output
to Excel is a text string matching that of the previewed report.