I currently have a report set like:

Page Header
Category Name Sales

Category Header
=[category]

Detail
=[Name] =[Sales]

Category Footer
TOTAL =[sum_sales]


When I run this report, the output looks like:

Category Name Sales
1 A 10
B 15
TOTAL 25

2 A 13
C 20
TOTAL 33

3 A 12
B 7
C 18
TOTAL 37



However, when I export this report into Excel, the fields in the ‘Category Footer’ are not being exported. Only the Page Header, Category Header & the Detail sections are being transferred. Any ideas on why the footer is not being included in the export and how to get include it?

I would think that the recordsource gets exported, not the report.

What export instruction are you using?

I was just using the export command through the File menu.

I think the "File" is the operative word, thst is, a report is not a file.

Is there another method of export that would carry the footer along?