Data not visible in reports for some users | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Data not visible in reports for some users

Hi All, While viewing reports though Project Web Access (PWA), for certain users it shows data and for certain user it doesn’t show the data i.e. blank report is shown with only header. A role RSExecRole has been created in database. A user prjrdr has been created and assigned to this role.
In reports data is shown of Project Server database and WSS Content database. In both databases above stated role and user have been added. Can please any one help me to solve this problem…. Thanks in advance.

Make sure those users has required privilegs to view report, refer to books online for SQL 2005 for Tutorial: Setting Permissions in Reporting Services topic. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.