...
- If the template for the report that you want to view is not already open in Microsoft Excel:
##- Open Excel.
- From the OfficeWriter Designer toolbar, select Open Report > Retrieve.
- Navigate to the report definition file on the report server that you created with OfficeWriter and open it.
- Open Excel.
- Click the View button on the OfficeWriter Designer toolbar. The report will open in another Excel window.
# - Click Close Report View to return to your template.
...
- From the report export options, select Excel designed by Officewriter.
!ssrs_2008r2.jpg!
#
- You will be prompted to save or open. To save the report as an Excel file, click Save. To view the report, click Open.