Edit

Print a Report (Report Builder and SSRS)

  • Article

After you save a report to a report server, you can view and print the report from a browser, the Reporting Services web portal, or any application that you use to view an exported report. Before saving a report, you can print it when you preview it.

When you print a report, you can specify the size of the paper to use. The size of the paper determines the number of pages in a report and which report data fits on each page. Paper size affects only reports that are rendered with hard page-break renders: PDF, Image, and Print. Setting the paper size has no effect on other renderers. For more information, see Rendering Behaviors (Report Builder and SSRS).

From the report viewer toolbar in the Reporting Services web portal or in preview in Report Builder, you can export a report to a hard page-break renderer or select the Print button to print a copy of the report. You might need to set the paper size or other page setup properties. Use the Report Properties dialog box to change page setup properties, including paper size.

You can specify print page margins in two different locations: in design mode and in run mode.

  • Design mode. When you set page margins in design mode, these settings are saved in the report definition when you save the report.

  • Run mode. When you set page margins in run mode, this information is not saved in the report definition. The next time you print the report, you will get the settings from the report definition, unless you indicate your print margins again.

    Note

    Print margins are not displayed in design or run modes. There is no relationship between the design surface area and the print area of your report. To see print margins, in run mode, select Print Layout on the Run tab on the Ribbon.

For more information about report paging, see Pagination in Reporting Services (Report Builder and SSRS).

Note

You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.

  1. Open a report.

  2. On the Home tab, select Run.

  3. (optional) Select Print Layout to see how the report will look when it is printed.

  4. (optional) Select Page Setup to set paper, orientation, and margins.

    Note

    The default values for these come from the report properties, which are set in Design view. The values you set here in the Page Setup dialog box are for this session only. When you close this report and reopen it, it will have the default values again.

  5. Select Print.

  6. In the Print dialog box, select a printer and specify other printing options.

  1. In the Reporting Services web portal, navigate to the report that you want to print. Open the report.

  2. On the toolbar at the top of the report, select Print.

    Note

    The first time you print an HTML report, the report server prompts you to install an ActiveX control used for printing. You must install and configure the control to print.

  3. In the Print dialog box, select a printer, and then select Print.

  1. In the Reporting Services web portal, navigate to the report that you want to print. Open the report.

  2. On the toolbar at the top of the report, select a rendering format, and then select Export. The report opens in a viewer application that corresponds to the rendering format.

    For example, if you select PDF, the report opens in Adobe Acrobat Reader.

  3. On the File menu in that program, select Print.

Change paper size

  1. Right-click outside of the report body and select Report Properties.

  2. In Page Setup, select a value from the Paper Size list. Each option populates the Width and Height properties. You can also specify a custom size by typing numeric values in the Width and Height boxes. Select OK.

    Note

    Size values have a default unit based on the user's locale settings. To designate a different unit, type a physical unit designator such as cm, mm, pt, or pc after the numeric value.

Set page margins in design mode

  • Right-click the blue area around the design surface, select Report Properties, and then select the Page Setup page.

Set page margins in run mode

  • Select Page Setup on the Run tab.

See also