The main file used for displaying reports is the RSViewerPage.aspx. This page contains a breadcrumb and a webpart called ReportViewerWebPart. This webpart renders a toolbar, the report and a parameters pane.
Hide buttons from the toolbar
I saw a couple of articles of people who disable some toolbar buttons by diving into the ConfigurationInfo table of the Reporting Services Database. This method will work for a few buttons, but not for all of them. I discovered that you don’t need to adjust that database table at all. You can use the ToolBarItemsDisplayMode property of the ReportViewer WebPart. This property allows you to hide/show specific parts of the ReportViewer’s toolbar. Be aware, this property is an enumeration field.
For example: ToolBarItemsDisplayMode=’223’ will hide:
- Open with Report Builder (Action Menu)
- Subscribe (Action Menu)
- Atom icon
Before:
After:
Why 223? You have to make the sum of the values of the parts you want to include in the toolbar. The values are shown in the reference table below:
You can set the property by adding the property in the RSViewerPage.aspx like
<RSWP:ReportViewerWebPart id="m_sqlRsWebPart" runat="server" SuppressWebPartChrome="true" Height="100%" ToolBarItemsDisplayMode="223" Width="100%" />
OR
You can pass the property as a querystring rv:ToolBarItemsDisplayMode=”223”
Related posts:
