Solved

Cannot view report in sql reporting services

Posted on 2013-06-05
2
563 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

810 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