...
- Open a browser and go to the Reporting Services Report Manager (usually installed at http://<server address>/Reports).
- Navigate to where you published your report.
- Select the report. Reporting Sevices will display the report but only show you the data set.
- From the export option drop-down, choose Excel designed by OfficeWriter.
- When prompted, click Open . Excel will open and display your report the way you created it.
Samples
RDL: Excel-QuickStartRDL2008R2.rdl