Best practice on managing reports in project server 2010 RRS feed

  • Question

  • Hi All,

    We are having different accounts (clients) and they need to get reports on their group of projects. One account does not want visibility to other accounts data. What is best proactice to manage reports ie, where to keep the reports for each accounts and how to manage the access to those reports?

    Thanks, Lovely

    Thursday, May 2, 2013 2:26 PM

All replies

  • Hi,

    your can create for each audience a separate cube and limit the access through Secure Store Service. Other than that you can use Reporting Services (SSRS) to query the group membership and expose only the associated data.


    Renke Project Management with MS Project - Oldenburg, Berlin, Munich/Germany

    Wednesday, May 8, 2013 8:24 PM
  • Hi

    use a lookup table to store the accounts. Create a project and a resource custom field using the lookup table.

    Store the account in project custom field and use the resource field to define, which accounts one should be able to see. Make the resource field a multivalue field if needed.

    Then you should use SQL Server Reporting Services for the report because you can query the userid of the person accessing the report here and use this to filter the data.

    Kind regards


    Christoph Muelder | Senior Consultant, MCSE, MCT | SOLVIN information management GmbH, Germany

    Saturday, May 25, 2013 8:06 PM