...
- 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 Select a format export option drop-down, choose Excel designed by OfficeWriter.
# Click Export and - when prompted - When prompted, click Open . Excel will open and display your report the way you created it.
...