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.