Report Footer not exporting to excel

[ezfriend]

I have a report that the Report Footer section display a total of some document counts; however, when export to excel file, only some of the data were exported and some are missing.

The settings for all of the controls in the Report Footer section are the same with the exception of the different formula.

Any idea?

See attachment (export to excel)
Excel file
Summary Report (jpg version of the Access report)

 

[RainLover]

Reports do not export to Excel very well.

The alternative is to export a query.

But you will not get totals that way either.

You may be able to export to an Excel template but I cannot help in this regard as I simply do not export.

 

[boblarson]

You can use the Excel common object model to do the export and manipulate the totals in the way you want. It isn't completely easy but it isn't that hard either. Have you done anything with the Excel objects (like Dim objXL As Object, etc.) intead of using TransferSpreadsheet or OutputTo.

 

[ezfriend]

Thanks for the suggestion, Boblarson.

I'll give the Excel Object a try. I did some thing like that a while back with excel

object so this should be easy to just get back to it.

The thing that questions me is that why some of the totals get exported fine, but not all. It must be a Microsoft thing.