Hello, this is my first blog post at this community, for the occasion I wrote a real short introduction of myself on the “About” page.
So let’s start with my first blog Post!
BI environment on SharePoint 2010 with SQL Server 2008 R2.
Reporting Services Integrated Mode with Report Builder 3.0.
The BI environment acknowledges three different user types, the Consumers, Power-Users and the Analysts. The consumer users will use the standard reporting and should not be allowed to open the reports with Report Builder. Other groups should be allowed to open the reports with Report Builder. There are several locations where the users can see the “Open with Report Builder” link. In this scenario we are talking about the link that is shown when a report is opened from a document library.
The report will then appear in a full screen window with Reporting Services front end. Underneath the action menu there is an option to “Open with Report Builder”. (Figure 1)
Figure 1 – Reporting Services front-end action menu
The consumer users should not be allowed to view or use the action “open with Report Builder” but we do not want to restrict the other users from using this functionality.
Solution / Work Around
There are two possible work a rounds for this problem:
1. Restrict the consumer users on the document library. Grant the consumer users the permission level view only, and grant the other users (Power-users or Analysts) the read level or higher.
When using custom permission levels be sure that the consumer role does not have the “Open Items“ underneath the list permissions.(Figure 2)
Figure 2 – Open items permission
The result is that the option of “Open with Report Builder” will be visible for all users and they can open Report Builder, but the consumer users will not be allowed to open the reports from SharePoint with Report Builder.
2. The second work around is to use the RSviewer web part (SQL Server Reporting Services Report Viewer web part) in SharePoint 2010. So instead of using the default view for Reporting Services you can build a web part page on which you place a list of reports and use the web part to show them. The RSviewer gives you the possibility to alter the action bar, and one of the options is to disable the “Open with Report Builder” action for that specific RSviewer.(Figure 3)
Figure 3 – RSViewre web part configuration
The result is that the option of “Open with Report Builder” will not be visible for any user for this specific web part page. To provision the other users with the possibility to use the action “open with Report Builder”, you can build another web part page with the option and revoke the permissions on this page for the consumer users.