SSRS 2012: change action of reportbuilder button?

Hi HansAnderss,

If you want to hide Report Builder button for all users, we can refer to the following steps to achieve this goal:

1. Connect to reporting services server and open Reporting Services Configuration Manager.
   


2. Go to database setup and note Database Server name and database name.
   


3. Open SQL Server Management Studio and connect to the database server from previous step.
   


4. Expand database node then expand tables, right click ConfigurationInfo table to select “Edit Top 200 Rows”.
   


5. Then make the value of “EnableReportDesignClientDownload” to “False” to disable Report Builder button.

If you want to hide Report Builder button for some particular users, we can refer to the following steps to achieve this goal:

1. Open SQL Server Management Studio to Reporting Services, expand the Security node and System Roles.
   


2. Under the System Roles folder, right-click System Administrator and System User to uncheck "Execute Report Definitions" task. Or custom a system role do not contain the "Execute Report Definitions" task. The users assign in these roles will not be able to see the report builder button.

If there are any other questions, please feel free to ask.

Thanks,

Katherine Xiong

---

Katherine Xiong

TechNet Community Support