Home > Paul Mather, Work > #ProjectOnline / #ProjectServer #Project Cost and Work Report #JavaScript #jQuery #Office365 #SharePoint #BI #PPM

#ProjectOnline / #ProjectServer #Project Cost and Work Report #JavaScript #jQuery #Office365 #SharePoint #BI #PPM

Paul Mather
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

This script will enable users to display the project cost and work on a column chart. The projects displayed are filtered by the selected Enterprise Project Type (EPT). The script can be downloaded from the script gallery below:


To get the script to work you will need to download the following jQuery library: jquery-2.1.1.min.js – jQuery download Another version of this library may work but this was the one I used / tested with. Upload this library to your PWA site collection then update the script file with the correct location. I uploaded this file to the site collection document library as you can see in the code below:


The script also makes use of a charting library called Highcharts. Highcharts is available from a company called Highsoft. Highcharts is only free for non-commercial use, see the link below for details:


If you do use this library in scripts or applications that you sell / anything commercial you will need to purchase the correct licence to do so.

Other charting libraries can be used, just update the code based on the requirements of your chosen charting library.

This script also uses the ProjectData Odata API so users will need access to this API for the report to work.

Once the script is downloaded, upload this to the PWA site collection, in this example it was uploaded to the shared documents library. Choose where you want the script to be accessed, in this example I created a new page, added a content editor web part on the new page then referenced the uploaded script using the content editor web part:


Once loaded, the page will look like this:


The selection menu will contain the Enterprise Project Types (EPT), selecting an EPT will then update the two charts with those projects and display the cost and work.

A quick video can be seen here: http://bit.ly/1vzh4Qr

This only uses intrinsic fields so should work for any Project Online environment but do test it thoroughly first. You might want to improve the error handling, data filtering etc. before deploying to a production environment. Also remember this does require the user to have access to the ProjectData API for this to work.

The script is provided "As is" with no warranties etc.

Categories: Paul Mather, Work Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: