We have sales reports that show company and month by month sales.
The detail section consists of ALL invoices, grouped by company.
The company footer shows the sum of the invoiced amounts month by month.
The detail section is selected as "Not visible".
So the report shows the companies and month by month sales.

When exported to Excel, because the detail section is hidden, no data is exported at all.

I guess I could perform the summation of the data at the SQL level, but the report runs fine. It just won't export to a spreadsheet.

Any other approaches?

It has been my experience that the exporting of reports to excel does not give the results that one may hope for. Formatting is lost, totals are usually lost etc.

Exporting a Query is a much better alternative.

Just my opinion.

rfove,

I've exported reports to Excel, but I used 'pre-formed' templates, and had to move
data from some cells that the data landed in to cells within the template area.

Just have to play with the layout to get it like you need it.

Good luck with your project. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)