SQL Server 2008 Books Online (October 2009)
Printing Reports

After you publish a report to a report server, you can view and print the report from a browser, Report Manager, or any application that you use to view an exported report. Before publishing a report, you can print it when you preview it.

All print processing is performed on demand and on the client computer. There is no server-side print functionality that enables you to route a print job directly from a report server to a printer that is attached to the Web server. Printers and print options are selected by individual report users using a standard Print dialog box.

ms155993.note(en-us,SQL.100).gifNote:
Although users cannot specify a printer as a target delivery destination in a subscription, SQL Server Reporting Services includes a sample Printer Delivery extension that shows developers how to author a delivery extension that provides this functionality. By creating a custom delivery extension, a developer can provide subscription users with the ability to route a report directly to a printer on a scheduled basis, without user intervention required. For more information, see Readme_Printer Delivery Extension Sample and Delivery Extensions Overview.

Report authors who design reports specifically for print output can use page breaks, report headers and footers, expressions, and background images to create a print-based design. Examples of report design elements intended for print output might include terms and conditions that you print on the back of every report, or graphic and text elements that mimic letterhead.

Due to the way pagination is implemented for different rendering formats, you may not be able to achieve optimum print output results for every report in every rendering format. Report pages are designed to accommodate variable amounts of data. Reports that include a matrix, for example, can cause a page to grow both horizontally and vertically depending on whether a user expands the rows and columns. A user who does not expand a matrix will get different print results than a user who does.

Reporting Services does not provide a way to combine landscape and portrait mode pages in the same report, nor does it provide a way to create a print-based layout that replaces or exists alongside the layout of a report as rendered in a browser or other application. For most exported reports, report printouts include everything that is visible on the report, as viewed by the user on a computer monitor.

If you are a developer, you can configure and use the RSClientPrint ActiveX control in custom applications. For more information, see Using the RSClientPrint Control in Custom Applications and Enabling and Disabling Client-Side Printing for Reporting Services.

ms155993.note(en-us,SQL.100).gifNote:
HTML report printouts may contain only the content on the first page if you are using the browser's Print command. You can achieve better results if you print HTML reports using the Reporting Services client printing functionality. For more information, see Printing Reports from a Browser Using the Print Control.

In This Section

Printing Reports from a Browser Using the Print Control

Describes how to use client-side printing to print reports from your Web browser or Report Manager.

Printing Reports from Other Applications

Describes how to print reports exported to another application.

How to: Print a Report (Reporting Services)

Provides step-by-step instructions on how to print a report from the Preview tab in Report Designer.

See Also

Tasks

How to: Print a Report (Report Manager)

Concepts

Exporting Reports
Understanding Simple and Complex Expressions (Reporting Services)
Adding Page Headers and Footers
Adding Images to a Report
Understanding Pagination in Reporting Services
Printing Reports How-to Topics

Other Resources

How to: Print Reports (Reporting Services in SharePoint Integrated Mode)
Managing Report Server Content

Help and Information

Getting SQL Server 2008 Assistance
Tags :


Community Content

MyMCSF
.Print(), Object does not support this property or method.
No problem running it in IE 6, when clicking on the printer icon, got the error and chose <Yes> to debug, it's this line.

RSClientPrint.Print(https://rpt.MyCompany.com/ReportServer, "...");

Reviewing the Watch, there is no "Print()" or "print()" method listed. Did anyone have this problem before? I can export the rpt to different file like .pdf .xls, so and so. Thanks.
Tags :

Page view tracker