Export (0) Print
Expand All

Print a Report (Report Builder and SSRS)

After you save 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 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 Report Manager or in preview in Report Builder, you can export a report to a hard page-break renderer or click 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 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, click 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 Note

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 print a report in Report Builder

  1. Open a report.

  2. On the Home tab, click Run.

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

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

    Note 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. Click Print.

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

To print a report from a Web browser application

  1. Start Report Manager (SSRS Native Mode).

  2. In Report Manager, navigate to the report that you want to print. Open the report.

  3. On the toolbar at the top of the report, click Print.

    Note 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.

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

To print a report from other applications

  1. In Report Manager, 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 click 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, click Print.

To change paper size

  1. Right-click outside of the report body and click 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. Click OK.

    Note 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.

To set page margins in design mode

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

To set page margins in run mode

  • Click Page Setup on the Run tab.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft