In this article, I will explain how to remove or hide breadcrumb in SSRS Reporting Service SharePoint Integrated Mode.
- 1 Hide breadcrumb in SSRS
-
2
Hide Breadcrumb in SSRS SharePoint Integrated Mode Using Report URL Parameters
-
2.1
Report Viewer Parameters in SSRS (Reporting Service SharePoint Integrated Mode)
- 2.1.1 rv:HeaderArea [Full, None].Default: Full
- 2.1.2 rv:ToolBar [Full, Navigation, None].Default: Full
- 2.1.3 rv:ParamMode [Full, Collapsed, Hidden].Default: Full
- 2.1.4 rv:AsyncRender [true, false].Default: true
- 2.1.5 rv:DocMapAreaWidth [Non-negative integer]
- 2.1.6 rv:DocMapMode [Displayed, Collapsed, Hidden].Default: Dislayed
- 2.1.7 rv:DockToolBar [Top, Bottom].Default: Top
- 2.1.8 rv:ToolBarItemsDisplayMode
-
2.1
Report Viewer Parameters in SSRS (Reporting Service SharePoint Integrated Mode)
You might also like to read Missing SQL Server Reporting Services Service Application in SharePoint 2016.
In SSRS, the breadcrumbs are really helpful for end-users to navigate various pages and find their way back from where they came from. but sometimes, you might need to hide it to avoid showing the Report Document Library and lost the current view,
- Open “ReportingServices.css” file that has been located on this path
C:\Program Files\Microsoft SQL Server\MSRS10_50\Reporting Services\ReportManager\Styles
Note: The above path depends on the installed SQL Server version, Ex: SQL Server 2012 Reporting Service path is C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\ Reporting Services\ReportManager\Styles
- Open the file with an appropriate text editor.
- Find CSS element called “.topBar”.
- Add “display:none;” at “table.msrs-topBreadcrumb” as shown below:
Note: If your farm consists of more than one server, so you apply all the previous steps to all servers that host SRSS.
Alternatively, you can also remove Breadcrumb Navigation Link in SSRS by doing the following:
- Edit the same file “ReportingServices.css“.
- Search for “msrs-banner” and “msrs-linkpanel“.
- Add “display:none;” as shown below:
Note: If your farm consists of more than one server so you need to apply all the previous steps to all servers that host SRSS.
In some cases, the previous solutions might not work on some browsers! So, it’s preferred to hide breadcrumb in SSRS as OOTB through Report URL Parameters.
- In SharePoint, open your SSRS report.
- Check the Report URL.
- After “?”, add the following word “rv:headerarea=none&“ as shown below:
Note: rv: QueryString stands for a relative URL.
Below is the list of Report Viewer Parameters in SSRS that you may need to control the tool bar and breadcrumb in SSRS Report Viewer.
rv:HeaderArea [Full, None].Default: Full
Control how the Report Viewer web part’s header is displayed in the full-page view.
Control how the ReportViewer web part’s toolbar is displayed in the full-page view.
Control how the ReportViewer web part’s header is displayed in the full-page view.
rv:AsyncRender [true, false].Default: true
Control whether the report is rendered asynchronously or synchronously.
rv:DocMapAreaWidth [Non-negative integer]
Control the display width in pixels of the ReportViewer web part’s Document Map area.
Control the display of the Document Map area of a report.
rv:DockToolBar [Top, Bottom].Default: Top
Controls whether the ReportViewer web part’s toolbar is docked to the top or bottom.
rv:ToolBarItemsDisplayMode
Controls turning off or on specific parts of the ReportViewer web part’s toolbar. This is an enumeration field.
eg. For no Actions “menurv:ToolBarItemsDisplayMode= 63 (or 0x3F);” For all of Actions menu only “rv:ToolBarItemsDisplayMode= 960 (or 0x3C0)“
Conclusion
In conclusion, we have learned how to remove or hide breadcrumb in SSRS SharePoint Integrated Mode.
Applies To
- SQL Server Reporting Service – SharePoint Integrated Mode.
- SQL Server Reporting Service – Native Mode.
See Also
- SSRS 2016: You are not allowed to view this folder. Contact your administrator to obtain the necessary permissions.
- Scale-Out Deployment for SQL Reporting Service (SSRS).
- Install and Configure SQL Server Reporting Service (SSRS).
- Missing SQL Server Reporting Services Service Application in SharePoint 2016.
- SQL Reporting service SharePoint 2016.
the best article about this issue many thanks
thanks
Hi. This by far is closest to the issue I’m facing. I want to add rv:HeaderArea=None into my url as well. But I cannot figure out how. We’re using SP 2013 with SSAS in SQL server 2012. Thanks a lot!
This is very attention-grabbing, You’re a very skilled blogger.
I’ve joined your rss feed and sit up for in quest of more of your great post.
Additionally, I have shared your website in my social networks
This blog was… how do I say it? Relevant!! Finally I have found something which helped me.
Thanks!
you always welcome
Fine way of telling, and pleasant post to obtain facts about my presentation topic, which i am going to convey in institution of higher education.