Printing Reports from Other Applications
SQL Server Reporting Services provides an export option that allows you to easily view a report in other applications. The Export command is available on the report toolbar that appears at the top of a report when you open it in a browser or Web-based application. Exporting a report displays it in a different application (for example, exporting a report to Excel opens the report in Microsoft Excel). For printing purposes, exporting a report is recommended only if the application has specific printing features that you want to use.
To export a report to another application, you must have that application installed. For example, you must have Adobe Acrobat Reader installed on your computer before you can export to the Acrobat (PDF) format. If you choose to export a report to TIFF format, the report server places the report in a viewing application that is associated with the TIFF file type. Although the application used depends on which version of Microsoft Windows you have, typically this tool is Windows Picture and Fax Viewer. The default resolution corresponds to a screen resolution of 96 dots per inch (DPI). You can increase the resolution in Windows Picture and Fax Viewer to 300 DPI or 600 DPI to match the capabilities of your printer. For more information about adjusting the resolution, see the Windows product documentation.
If you choose Web archive (also known as MHTML), the report is exported to your default browser. Printing from the browser may result in report path information being added at the bottom of every page. In most cases, you can set browser options to omit path information on a printed page. For more information, see the product documentation for the browser you are using.
Although printing from a browser is generally not recommended, Reporting Services provides client-side printing that allows you to obtain high quality print output for reports that are viewed from a browser or Web-based application. For more information, see How to: Print a Report (Report Manager).