Solved

Cannot view report in sql reporting services

Posted on 2013-06-05
2
565 Views
Last Modified: 2013-06-10
I have 3 users that cannot view a report in SQL Reporting services. I checked their site security settings and they are set up as Administrators. What other places should i be checking?

-Thanks
0
Comment
Question by:Allanore
2 Comments
 
LVL 17

Expert Comment

by:Kent Dyer
ID: 39223763
If it is only three people..  Can they view/execute other reports?  I would have to assume they would?  You mentioned that you checked permissions - what about linked reports or child reports?  Do these users have permissions to the child reports?  If these are all good..  Maybe check the problem report and trim it down for testing to say maybe one record?  Are you doing anything odd with the tablix?  For example, last quarter and then two quarters ago?

HTH,

Kent
0
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 500 total points
ID: 39231099
Try to give them Folder permissions.

Folder permissions
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question