SQL Server Performance

Data not visible in reports for some users

Discussion in 'SQL Server 2005 Reporting Services' started by techieman, Nov 16, 2006.

  1. techieman New Member

    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.
  2. satya Moderator

    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
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page