Export to Excel problem

[nickfatool]

Another Excel related question..

Rephrased re-posted..
"Totals vanish when exporting to Excel"

I'm using the DoCmd.OutputTo method of transferring the
contents of a formatted report out to an Excel file.
The report contains 6 subreports and I've attempted to
line them all up so as to achieve a sense of continuity.
Everything is just fine except for calculated fields in
each subreports' ReportFooter (Sums and Averages of data
within the Detail). The problem is compounded with every
subreport, in Excel, the cells that should contain
precalculated sums actually contain an Excel Formula SUM
($C$2:$C$xxx) where xxx is the actual row the cell is on.
In effect it is reporting a running sum over all of my
subreports. Plus the average calculations in subreport footers do not appear at all.

Any clues on where I should start?


Thanks in advance..

Rob Dexter.

 

[Sorcerer1]

I wonder if this is because access is only exporting the values of the underlying table, not sure if Access is capable for exporting calculations based on reports. Try doing some calcs in your query to see if it exports these.

 

[nickfatool]

It does export a calculated field I have in the report header, and I just tried calculating a field within the report detail, that Exports to excel as well. It has a hard time with the footer, it will not display any kind of calculated field or even label, it seems to urge Excel to summarize the column if you have a calculated summary field in the Access report footer.

Real strange..