In SSRS 2014 User unable to see Report in Report Manager

blossompark
blossompark used Ask the Experts™
on
Hi All,
In Report Manager I have assigned a user to the browser role at the report level  of a single report (and also to the browser role of a folder) but she cannot see the folder or  report in her browser.
Here is what she can see
rs The Folder and Report are both set to  not inherit Parent Security.
The user is assigned to the Browser role in the Home Folder.
If you require any further information please do not hesitate to ask.
Any Guidance appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Commented:
"User unable to see Report in Report Manager" - did the user tried to access the reports you granted this level of access via the "Report Server" not "Report Manager" URL?

This is because as said here: https://docs.microsoft.com/en-us/sql/reporting-services/security/role-definitions-predefined-roles?view=sql-server-2014#bkmk_browser 
The Browser role is a predefined role that includes tasks that are useful for a user who views reports but does not necessarily author or manage them.

Author

Commented:
Hi Icohan
thanks for your reply....
i had not made the distinction between "Report Server" and "Report Manager".
I have sent the user the "Report Manager" URL , assuming that is where users should access reports.
I do not have access to my desktop currently and I will check in the morning  as this may be my fundamental misunderstanding and thus the issue.
Thank you and I will update once I check :-)

Author

Commented:
Hi Icohan,
Unfortunately it doesn’t seem to matter which link the user uses…
The core issue is, I am trying to give a user access to a single report in a sub folder of the HOME folder.
But it seems I can only give her access to the contents of the whole folder.
When I remove her from the Browser role at the folder level and give her access to an individual report in that folder she cannot see the report in the browser window…
When I give her access to the browser role at folder level she can see every report in the folder, which seems logical.
The core issue is how can I give her access to selected reports in the folder?
lcohanDatabase Analyst

Commented:
To grant access to a single SSRS Report steps to be done as described below :

To add a user or group to an item role
Start Report Manager and locate the report item for which you want to add a user or group.

Hover over the item, and click the drop-down arrow.

In the drop-down menu, click Security.

Click New Role Assignment.

 Note

If an item currently inherits security from a parent item, click Edit Item Security in the toolbar to change the security settings. Then click New Role Assignment.

In Group or user name, enter a Windows domain user or group account in this format: <domain>\<account>. If you are using forms authentication or custom security, specify the user or group account in the format that is correct for your deployment.

Select one or more role definitions that describe how the user or group should access the item, and then click OK.

Repeat to create assignments for additional users or groups.


from here: https://docs.microsoft.com/en-us/sql/reporting-services/security/grant-user-access-to-a-report-server?view=sql-server-2014

Author

Commented:
Hi Icohan , thanks for that, it confirms what I have been doing so at least I feel i have been doing it correctly, but I am still having issues.
I have found the person in our organisation who set up the Report Server so I will meet with them and see if I can get clarity....
Thank you :-)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial