Output report to Excel doesn't include some totals

[NthDegree via AccessMonster.com]

Have report that basically looks like the following:

Physicians code level header

Detail line with Source (how paid), Procedure Amount, Percentage (calculated
by Procedure Amount/Total of all procedure amounts)

Physicians footer contains: Sum of Procedure Amounts, Sum of Percentage
(should be 100%).

Report works fine when just printing or previewing, however when doing a:

DoCmd.OutputTo acOutputReport, strReportName, acFormatXLS, strDirectory &
"DR_Charges_Report.xls", False

the Sum of Percentages is blank. According to the documentation, the header
and footer groupings in an Access report should be converted to levels in the
Excel spreadsheet but all that does hide or unhide the detail lines.

Any clues would be appreciated.