Print Reports from a Browser with the Print Control (Report Builder and SSRS)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Although a browser is the most common client application used to view a report, browser print functionality is not ideal for printing reports. Print functionality in a browser is designed for printing Web pages. Typically, pages that you print from a browser include all of the visual elements that are on a Web page, plus header and footer information that identifies the page or Web site. Printing from a browser prints the contents of the current window. For a multipage report, the browser prints the first page at most, and possibly less if the report page extends beyond the dimensions of a printed page.
To improve the print quality of reports that you view in a browser and to print multiple pages, you can use the client-side print functionality provided in SQL Server Reporting Services. Client-side printing provides a standard Print dialog box that can be used to select a printer, specify pages and margins, and preview the report before you print. Client-side printing is intended to be used in place of the Print command on the browser's File menu. When you use client-side printing, the report is printed as it was designed, without the extra elements you see in a Web page print out.
To use client-side printing, you need to install a Microsoft ActiveX control. For more information, see Enable and Disable Client-Side Printing for Reporting Services.
You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.
To configure print properties for your report, in the Print dialog box, click the Properties button. Paper size is determined by the default height and width of the report page size as defined in the report definition. The available values are dependent on the printer type and its capabilities. Width and height display default values as determined by the print drivers that are configured on the computer. Changing these values causes the report to print using the new dimensions. Page width and height are each determined by Orientation, which is set to either Portrait or Landscape. The default orientation displayed is dependent on the page width and page height of the report.
The Print dialog box and the default printer settings for width, height, and page orientation are determined by the report definition.
To preview a report, in the Print dialog box, click the Preview button. Clicking preview opens the first page of the report in a separate preview window. Additional pages are made available as the report is rendered on the report server. A previewed report is rendered in EMF format. You can navigate to the previous or next page until the last page is reached, and the Next button is disabled.
Adjusting Print Margins
You can modify the print margins in the rendered EMF report prior to printing the report. To do this, in the Print dialog box, click the Preview button. At the top of the preview page, click the Margins button. The Margins dialog box is displayed. Configure the top, bottom, right, and left margins as desired. Click OK. The dialog box closes and the settings are stored for rendering preview and printing.