>I want to do a report with many "group by" clauses, header, subtotal and total. I will probably use the report designer of VFP. But I would like to know if it is possible to do the same from VFP to Excel. Can I transfer all formatted information from Report Designer to Excel?

Basically, no, you can't transfer anything from the Report Designer to Excel. What you *can* do is use Automation to format the data in Excel, including adding subtotal and total formulas.

Another option would be to look into Crystal Reports, and they have an option to export to an XLS file.

- della