title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom |
---|---|---|---|---|---|---|---|---|
Interactive sort, document maps, and links in a paginated report |
Enable your users to change the sort order of values in a paginated report, show or hide items, or select links to other reports or Web pages in Report Builder. |
maggiesMSFT |
maggies |
03/14/2017 |
reporting-services |
report-design |
conceptual |
updatefrequency5 |
[!INCLUDEssrs-appliesto] [!INCLUDE ssrs-appliesto-ssrs-rb] [!INCLUDE ssrs-appliesto-pbi-rb] [!INCLUDE ssrb-applies-to-ssdt-yes]
In Web-based environments, you can add a number of features that let your users interact with paginated reports. Your users can change the sort order of values in your report, show or hide items in the report, or click links that go to other reports or Web pages. You can also add a table of contents or document map. Your report users can click items in the table of contents or document map to jump to areas within a report.
Report Builder and Report Designer support three types of links with the following actions:
-
Bookmark links Jump to other areas within the report.
-
Hyperlinks Jump to URLs that specify the address of Web pages or reports on a report server by using URL access.
-
Drillthrough report links Jump to other reports on the same report server. For more information, see Drillthrough Reports (Report Builder and SSRS).
Note
Links that are bound to dataset fields can be vulnerable to tampering for malicious purposes. For more information, see Secure Reports and Resources.
You can also let your users control report display and content by designing expressions that include parameter references for sort, filter, and visibility. For more information, see Report Parameters (Report Builder and Report Designer), Filter, Group, and Sort Data (Report Builder and SSRS), and Add Dataset Filters, Data Region Filters, and Group Filters (Report Builder and SSRS).
Note
[!INCLUDEssRBRDDup]
Interactive Sort (Report Builder and SSRS)
Explains how to add interactive sort buttons to column headers.
Create a Document Map (Report Builder and SSRS)
Explains how to add a table of contents to support navigation in a large report.
Add a Bookmark to a Report (Report Builder and SSRS)
Explains how to add bookmarks to create links within a report.
Add a Hyperlink to a URL (Report Builder and SSRS)
Explains how to add a link from your report to a URL
Drillthrough, Drilldown, Subreports, and Nested Data Regions (Report Builder and SSRS)