subreport to excel

[cooldisk2005]

All,
I have a report that has several fields from a main table.

I also have 2 subreports on that report that are associated with 2 other tables.

The report is in continuous format.

I want to be able to convert that report to excel, but when I do it doesn't put the report into a continuous format in excel.

All the data is in excel, but the subreport data is in different places in excel, and not in nice rows as it looks in the report in access.

Does anyone know how to make it format correctly in excel?

Any help will be surely appreciated.

Thanks,
Jerome