Sub Reports

[Tkandy]

I am only a beginner at Access, and have got a report i send out every month and it is consists of lots of subreports, I email this out as a PDF at the moment but would like to be able to send it out in excel, when i try it will only do the first Subreport. i would also like to keep all the formatting i have in the PDF report. Is this possible to put this all in one excel spreadsheet? if so please i will need some help or pointers in the right direction.

 

[SOS]

Exporting to Excel does not retain report formatting. Sorry, not available.

As for the other sub reports, it should send it all but it may be in strange places on the spreadsheet due to the hierarchy of the report/sub reports.