Problem / Solution
Any report designer will often need to find ways to offer easy navigation paths to report consumers. SSRS provides several methods to navigate a report including document maps and bookmarks.
Document maps create a separate windows pane with a set of hyperlinks which can be used to navigate around a report, a virtual table of contents. Furthermore, the document map rendering options function slightly different within each of the various rendering formats, and some functionality does not work at all in certain renderings. Thus, for PDF renderings, the document map functionality is expressed through PDF bookmarks. In Report Viewer and Report Preview (online), the document map actually opens on the left side of a report. For Excel, documentm maps are expressed through the use of a table of contents worksheet which is linked to specific worksheets..
Be sure to read my full MSSQLTips.com tip on SSRS document maps and bookmarks at: https://www.mssqltips.com/sqlservertip/3504/sql-server-reporting-services-bookmarks-and-document-maps/
Key Learning Items
The video covers how to:
- Using Document Maps in SQL Server Reporting Services
- Using Bookmarks in SQL Server Reporting Services
Read Companion Tip
I have a passion for crafting Business Intelligence Solutions for my user groups. My experience includes almost 15 years of SQL Server involvement with the last 12 years focused specifically on Business Intelligence, SharePoint, OLAP, SSRS, and Decision Support solutions. Currently, I am a Business Intelligence Architect in the healthcare industry, and I also teach database and analytics classes for Kennesaw State University, Southern New Hampshire University, and Reinhardt University. My education includes an MBA and an undergraduate in Accounting (yes I am a reformed accountant!), both from Kennesaw State University. I enjoy every day by trying to grow my faith and spend precious time with my family. I have been happily married to my wife of over 20 years, and we have two teenagers one who we home school with the help of a University Model School, Cornerstone Prep in Acworth, GA (cornerstoneprep.org). Our other child is a Construction Management major at KSU’s Southern Poly / Marietta campus. We are a soccer and Cross Country (XC) family who play, coach, and referee soccer or run for fun most every day. For several years, our family has volunteered (and played with the dogs and cats) at Etowah Valley Humane Society in Cartersville, GA.
- MSSQLTips Awards: Champion (100+tips) – 2016 | Author of the Year – 2015 | Author Contender – 2014, 2016-2021