yes it is and it is 2000. What happens is it dumps stuff into a spreadsheet, but it looks horrible. It doesn't appear that any of the data is contained within it. I would cut paste it, but there is a lot.
It's hard ot say what the problem without seeing the report. I have a Matrix Report that i sugly in Excel because it has drill down, but all the data is there. And FYI right out of the RS BOL (red highlighting added):
Renders a report in a page-oriented format.
This format is recommended for printing. It is not recommended for large reports.
Acrobat (PDF) File
Opens a report in the Adobe Acrobat Reader.
Choose this format for large reports, paginated reports, and for reports that are delivered as a file.
Renders a report in MHTML. The report opens in Internet Explorer.
This format produces a self-contained, portable report (embeds images within the report). Choose this format to view reports offline or for e-mail based delivery.
Renders a report in Microsoft Excel.
This format is useful for report data that you want to manipulate offline or in Microsoft Excel. Avoid this format for large reports.
This format requires Microsoft Excel version 10 from Office 2002 or version 11 from Office 2003.
Renders a report in XML. The report opens in a browser.
The purpose of this format is to copy report data from report server to other applications or servers.
Renders a report in comma-delimited format. The report opens in a viewing tool associated with CSV file formats.
This format produces the smallest file size. The purpose of this format is to copy report data from report server to other applications or servers.
HTML with Office Web Components
Renders a report in an Office Web Component that loads within the browser window.
This format provides interactive features that you can use to manipulate a report that is connected to a report server. This format requires that you have Office Web Components version 10 from Office 2002 installed on your client computer.