#ProjectServer data snapshot for reporting #PS2010 #MSProject #SP2010 #Excel #SSRS #SQL

Quite often there is a requirement for some form of data snapshot in Project Server for trend analysis reporting. This post will give a simple explanation of how this can be achieved using the Project Server Reporting database and a SQL job. This example just captures some key project metrics such as Actual Work, Actual... Continue Reading →

#Excel Services REST API in #SSRS report #ProjectServer 2010 #PS2010 #MSProject #SP2010 #SharePoint

Following on from my previous post that demonstrated embedding Excel Services objects in Word using the Excel Services REST API, this post demonstrates using the Excel Services REST API in SSRS reports. Once you have gone to the time and effort creating the charts in Excel services you don’t want to have to go to... Continue Reading →

Create a free website or blog at WordPress.com.

Up ↑