This post is about how to configure Project Server 2013 default reporting service. Project Server 2013 on premise have Business Intelligence Center into each instance of Project Web App, which provides Out-of-box report for Project Server. There are a few configurations required to run these reports. Here, I am going to show the configurations to run these reports.
In the left Navigation of PWA (Project Web App), there is a link for Report Library that shows Project Server out of box reports.
When I tried to run this report, I got the below shown error:
After a research and few findings, I got it working; let’s see how. To run these reports, Excel Services and Secure Store Service are the prerequisites.
Start the Excel Calculation Services service
- Go to Central Administration -> System Settings section -> click Manage services on server.
- Click the Server drop-down list, and then click Change Server and choose the appropriate server.
- Start Excel Calculation Services.
Create an Excel Services service application
- Go to Central Administrator -> Application Management -> Manage service applications
- Check Excel Service Application if its running or not.
- Create new Excel Service Application.
- Click New -> click Excel Services Application.
- Provide a name and select the Create new application pool option and type a name for the application pool in the text box.
- Select the Configurable option and provide the account name for running the application pool as shown below and Click OK.
Add a trusted file location and data connection libraries
- Go to Central Administrator -> Application Management -> Manage service applications
- Click on Excel Services service application that we created in the step above. Doing so will open up the page below:
- Click on Trusted File Locations, Add the location of Report Library from PWA Instance as shown Below and also check Trusted Children checkbox while adding Trusted File Locations
– Location will be the url of your report Library in Project Web App
- Click on Trusted Data Connection Libraries, and add the location of data connection library from PWA Instance as shown below:
Start Secure Store Service
- Go to Central Administration -> System Settings section -> click Manage services on server.
- Click the Server drop-down list, and then click Change Server and choose the appropriate server.
- Start Secure Store Service.
Start Secure Store Service Application
- Go to Central Administrator -> Application Management -> Manage service applications.
- Create New -> Secure Store Service.
- Click on Secure Store Service that we created; this will show a message to add a new target application as shown below
Important: The sample reports included with each instance of Project Web App are configured to use a Secure Store target application called ProjectServerApplication. You must create this target application for the sample reports to work.
Create a new target application
- Enter Target Application ID as “ProjectServerApplication”
- Enter Display Name box, and type a name for the Secure Store Target Application.
- In the Contact Email box, type an email address.
- From the Target Application Type drop-down list, select Group.
- Click Next.
- On the ‘specify the credential fields for your Secure Store Target Application’ page, click Next.
- On the ‘specify the membership settings’ page, perform the following steps:
- In the Target Application Administrators box, type the name of the user who will administer this target application.
- In the Members box, type the name of the domain group you created for report viewers.
- Click OK.
- On the Secure Store Service Application page, select the check box for the target application that you just created.
- On the ribbon in the Credentials section, click Set.
- In the Set Credentials for Secure Store Target Application (Group) dialog box, type the user name and password of the account you created for the secure store target application.
Now run the reports from Project Web App, and there you are!
