Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have added a SSRS report to one of my department home pages and two things concern me:

  1. It is very slow - almost a minute to render and any slicing takes a minute as well. Reporting services installed on the sharepoint box and SQL db engine on a different box. Reporting Server running in integrated mode and successfully paired with sharepoint.

  2. I have added the report using the admin account. But in spite of adding new users to the owners' group they are unable to view the report. What am I missing here? I am using claims based with NTLM.

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

Check the permissions of the Report Library where the reports(.rdl) are uploaded.

At times,report library will need contribute level access rights for all the users who wish to see the reports inside this library. Also it is advised that do not use inherited permissions on the report library. Stop inheriting permissions and give permissions directly on the report library.

Additionally, if you are calling the report through a report viewer webpart inside a page , ensure the permission levels for the users are the same to that of the report library.

Thirdly, check all the datasource files, rdl files are checked in and published.

Let us know if this resolves your issue or not.

share|improve this answer
    
Thanks for the post Moss. I get the idea. However, what concerns me is that I would have to give contribute access to a user who I would like to treat as a visitor in order for him to see the reports and secondly, shouldn't the library inherit permissions if I were to assign a user to the site's owner group? –  user7400 May 24 '12 at 13:54
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.