How to: Export a Report as Another File Type
You can render a report to another file format, such as CSV, Image, PDF, Microsoft Word, or Microsoft Excel, while previewing your report in Report Designer, or you can render the report while viewing the report on the report server. Rendering the report in a specific format in Report Designer is helpful when you want to immediately save the report as another file type without publishing the report to the report server or when you want to see how your report design will appear when delivered to your report readers in a specific format. Rendering the report on the report server is useful when you set up subscriptions or deliver your reports using e-mail, or if you want to save a report that is available on the report server. For more information, see Subscription and Delivery.
To export a report as another file type in the reporting tools
Preview the report.
On the Report Viewer toolbar, click Export.
Select the format that you want to use.
A message appears asking you if you want to open or save the file.
To view the report in the selected export format, click Open.
- or -
To immediately save the report in the selected export format, click Save.
Using the application that is associated with the format that you chose, the report is either displayed or saved. If you click Save, you will be prompted for a location where you can save your report.
Note If the program cannot open the report in the format that you chose because you do not have a program associated with this file type, you will be prompted to save the exported report or to find a program online to open the report.
To export a report as another file type in Report Manager
From the Report Manager Home page, navigate to the report that you want to export.
Click the report.
The report is generated.
On the Report Viewer toolbar, click the Select a format drop-down arrow.
Select the format that you want to use.
Click Export.
A message appears asking you if you want to open or save the file.
To view the report in the selected export format, click Open.
- or -
To immediately save the report in the selected export format, click Save.
Using the application that is associated with the format that you chose, the report is either displayed or saved. If you click Save, you will be prompted for a location where you can save your report.
Note If the program cannot open the report in the format that you chose because you do not have a program associated with this file type, you will be prompted to save the exported report or to find a program online to open the report.
See Also
Concepts
Understanding Pagination in Reporting Services
Comparing Interactive Functionality for Different Report Rendering Extensions