Create a Document Map (Report Builder and SSRS)
Applies To: SQL Server 2016
A document map provides a set of navigational links to report items in a rendered report. When you view a report that includes a document map, a separate side pane appears next to the report. A user can click links in the document map to jump to the report page that displays that item. Report sections and groups are arranged in a hierarchy of links. Clicking items in the document map refreshes the report and displays the area of the report that corresponds to the item in the document map.
To add links to the document map, you set the DocumentMapLabel property of the report item to text that you create or to an expression that evaluates to the text that you want display in the document map. You can also add the unique values for a table or matrix group to the document map. For example, for a group based on color, each unique color is a link to the report page that displays the group instance for that color.
You can also create a URL to a report that overrides the display of the document map, so that you can run the report without displaying the document map, and then click the Show/Hide Document Map button on the report viewer toolbar to toggle the display.
The document map is intended for use in the HTML rendering extension—for example, in Preview and the Report Viewer. Other rendering extensions have different ways of articulating a document map:
PDF renders a document map as the Bookmarks pane.
Excel renders a document map as a named worksheet that includes a hierarchy of links. Report sections are rendered in separate worksheets that are included with the document map in the same workbook.
Word includes a document map as the table of contents.
Atom, TIFF, XML, and CSV ignore document maps.
For more information, see Interactive Functionality for Different Report Rendering Extensions (Report Builder and SSRS).
In Design view, select the report item such as a table, matrix, or gauge that you want to add to the document map. The report item properties appear in the Properties pane.
To select a tablix data region, click in any cell to display the row and column handles, and then click the corner handle.
In the Properties pane, type the text that you want to appear in the document map in the DocumentMapLabel property, or enter an expression that evaluates to a label. For example, type Sales Chart.
If you do not see the Properties pane, on the View tab, in the Show/Hide group, select Properties.
Repeat steps 1 and 2 for every report item that you want to appear in the document map.
Click Run. The report runs and the document map displays the labels you created. Click any link to jump to the report page with that item.
In Design view, select the table, matrix, or list that contains the group that you want to display in the document map. The Grouping pane displays the row and column groups.
In the Row Groups pane, right-click the group, and then click Edit Group. The General page of the Tablix Group Properties dialog box opens.
In the Document map list box, type or select an expression that matches the group expression.
Repeat steps 1-4 for every group that you want to appear in the document map.
Click Run. The report runs and the document map displays the group values. Click any link to jump to the report page with that item.
In Report Manager, browse to the report that has the document map.
For example, for the AdventureWorks2012 sample reports, the following URL specifies the report named Product Catalog.
Copy the report path on the server. In the example, the report path is
Create a new URL with the following three components:
The report viewer on the report server:
The name of the report you copied in step 1, for example:
The device information parameters that specify hiding the document map:
The following URL consists of these three components appended in the order they are listed.
http://localhost/ReportServer/Pages/ReportViewer.aspx? %2fAdventureWorks2012+Sample+Reports%2fProduct+Catalog &rs%3aCommand=Render&rc%3aFormat=HTML4.0&rc%3aDocMap=False
To use this URL, copy it and remove all line breaks.
Paste the URL in Report Manager, and then press ENTER. The report runs, and the document map is hidden.
For more information, see "URL Access" in the Reporting Services documentation in SQL Server Books Online.