Interactive Functionality for Different Report Rendering Extensions (Report Builder and SSRS)

 

Applies To: SQL Server 2016

Reporting Services provides features for interacting with a paginated report at run time. Not all of the report rendering formats support the full range of interactive features. Use the following table to understand how each interactive feature works in specific formats.

System_CAPS_ICON_note.jpg Note


You can create and modify paginated report definition (.rdl) files 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.

Paginated reports that are rendered to XML, CSV, or Image formats do not support interactive features.

Reports that you view in the Reporting Services web portal, SharePoint Web parts, or in a browser are rendered in HTML. HTML and Windows Forms are the only report output formats that fully support all interactive features. Alternate HTML formats (such as MHTML) support many interactive features. If exceptions for MHTML exist, they are noted in the following table.

Document maps

Export OptionSupport Information
Preview/Report Viewer, HTMLInteractive document map provides a navigation pane of hierarchical links that can be used to navigate to different sections of a report.
PDFPDF renders a document map as the Bookmarks pane. All items in the document map are listed one after the other down the pane. It includes a hierarchy of links. If a page range is specified, only those bookmarks that are rendered exist in the hierarchy.
ExcelExcel renders a document map as the first worksheet in the workbook. It includes a hierarchy of links. When the link in the document map is clicked, the appropriate target cell in the respective worksheet is opened.
WordWord renders the document map as Table of Contents labels.
Other (for example, TIFF, XML, and CSV)Not available in MHTML, XML, CSV, or Image.

Drillthrough links to other reports

Export OptionSupport Information
Preview/Report Viewer, HTMLUsers click on data values in the report to view related data in another report.
PDFDrillthrough links are not available in PDF. Consider using hyperlinks for PDF reports that link to other pages.
ExcelDrillthrough links are rendered in Excel.

The link becomes a hyperlink pointing to the report referenced by the drillthrough link. Clicking the link opens a report in a browser window.
WordDrillthrough links are rendered in Word.

The link becomes a hyperlink pointing to the report referenced by the drillthrough link. Clicking the link opens a report in a browser window.
OtherNot available in XML, CSV, or Image.

Toggle items within a report

Export OptionSupport Information
Preview/Report Viewer, HTMLUsers click expand and collapse icons to view sections of a report.
PDFThe report server exports the current show or hide state of the report to PDF. Interactive toggling is not supported
ExcelDrilldown links and items that can be toggled are rendered as collapsible outlines in Excel. You can expand and collapse sections of the report in Excel. For more information about Excel-imposed limitations, see Exporting to Microsoft Excel (Report Builder and SSRS).
WordThe report server exports the current show or hide state of the report to PDF. Interactive toggling is not supported
OtherNot available in MHTML, XML, or CSV. When exporting to an Image format, the report server exports the current show or hide stated of the report to PDF. Interactive toggling is not supported.

Interactive sorting

Export OptionSupport Information
Preview/Report Viewer, HTMLFor tabular repots, users click sort arrows on column to change how the data is sorted.
PDFNot available in PDF.
ExcelNot available in Excel.
WordNot available in Word.
OtherNot available in MHTML, XML, CSV, or Image.

Hyperlinks to external Web content or images

Export OptionSupport Information
Preview/Report Viewer, HTMLUsers click links to open external Web pages in a new browser window.
PDFHyperlinks are rendered by the PDF rendering extension. When a user clicks on a hyperlink, the linked pages are opened in the browser.
ExcelHyperlinks are rendered in Excel.
WordHyperlinks are rendered in Word.
OtherHyperlinks are not available in MHTML, XML, CSV, or Image.

For MHTML, and Image, external images are rendered as a static picture.

Bookmark or anchor

Export OptionSupport Information
Preview/Report Viewer, HTMLUsers click links to navigate to another section of the same report.
PDFNot available in PDF.
ExcelBookmarks are rendered in Excel.

The bookmark becomes a hyperlink pointing to the name of the report item.
WordBookmarks are rendered in Word.

The bookmark becomes a hyperlink pointing to the bookmarked report item. Only 40 characters of a bookmark or anchor name is converted when the report is exported which can lead to duplicate bookmark or anchor names. Spaces are converted to underscores (_).
OtherNot available in XML, CSV, or Image.

Prompted parameters obtained at run time

Export OptionSupport Information
Preview/Report Viewer, HTMLA parameter input area appears at the top of the report. This area is part of the HTML Viewer used to display reports in a browser.
PDFThe report server exports the report to PDF using the parameter values currently in effect for the report.
ExcelThe report server exports the report to Excel using the parameter values currently in effect for the report.
WordThe report server exports the report to Word using the parameter values currently in effect for the report.
OtherThe report server exports the report to other formats using the parameter values currently in effect for the report.

Filters applied at run time

Export OptionSupport Information
Preview/Report Viewer, HTMLThe filtered data is displayed to the user at run time.
PDFThe report server exports the report to PDF using filtered data in the current report.
ExcelThe report server exports the report to Excel using filtered data in the current report.
WordThe report server exports the report to Word using filtered data in the current report.
OtherThe report server exports the report to other formats using filtered data in the current report.

Export Reports (Report Builder and SSRS)
Interactive Sort, Document Maps, and Links (Report Builder and SSRS)
Matrices (Report Builder and SSRS)
Tables, Matrices, and Lists (Report Builder and SSRS)
Charts (Report Builder and SSRS)

Community Additions

ADD
Show: