How to enable My reports

Click on Site Settings

image

Check the Enable My reports to Support User-owned folders for publishing and running personalized reports and click apply

image

To grant a user access to publishing reports to my reports folder

Go to home Click on the Properties tab, click on edit link next to the username. Make sure My reports Role is checked.

image

Advertisements

How to Enable Report Builder tab in SSRS

Many of the SSRS administrator I have interacted are a little confused about enabling Report Builder tab. The reason is when the get on the box where they have installed reporting services, they browse to http://localhost/reports they are able to see the report builder tab, but when the try to access the site remotely they cannot see it. To confuse matters future, the administrator keeps granting access to the Report Builder Role and nothing happens.

image

Below is the step by step instructions on how to enable Report Builder

1. Remote in or log into box where you have installed SSRS

2. Go http:\\localhost\Reports

image

3. Click on site setting in the Right hand corner, you will get the below from

image

4. Click Configure system-level role definitions,

image

Click New Role

image

5. Add a new role name: Report Builder, Description “This role will make report builder visible to users”

Same as shown above click OK

6. Select Site Setting

7. click Configure site-wide security

image

Click Ok.

When User1 access the site remotely should see the Report Builder Tab.