Wednesday, February 15, 2012

Export report to Excel - not workin

HI,
I am running Excel 2000 with RS. I have created a report and when I right
click on the report and select 'Print With', 'Excel', the contents of the
excel file are all machine code and does not contain anything from the
report?
How do you export to excel?
ThanksWhen you do a right mouse click on the report you are just getting some
options for IE. Instead you should select a format and then click on export
in the toolbar. Make sure you have at least service pack 1 installed to
support Excel 2000 format otherwise you will just get a bunch of
gobbledeegook in Excel.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Susan" <Susan@.discussions.microsoft.com> wrote in message
news:D40B5446-8385-44FD-BF77-7F7DA003009F@.microsoft.com...
> HI,
> I am running Excel 2000 with RS. I have created a report and when I right
> click on the report and select 'Print With', 'Excel', the contents of the
> excel file are all machine code and does not contain anything from the
> report?
> How do you export to excel?
> Thanks

No comments:

Post a Comment