Adding VB Scripts Inside SSRS Reports

Posted By Posted by: EPM Partners on November 12, 2012

Problem: Converting a comma separated string outputted from a multi select parameter into an array of strings to be used in SSRS report expressions. Solution: You can store custom VB code in an SSRS report and this functionality can be used to include a variety of custom built functions but in this case it will be used to convert a

Read More


Blog Posted In Blog Posted In: Reporting
Blog Posted In 

Reporting on Lists from Project Workspaces (SharePoint Sites)

Posted By Posted by: Laith Adel on July 14, 2011

It has been always a challenge to report on custom SharePoint lists in project workspaces, lists like Issues and Risks have its own special reporting techniques (I won’t go through this here), but if you create other lists in your project workspace, like “Changes’ . ‘Purchase Orders’, Lessons Learned’, etc. it was always hard to

Read More


Blog Posted In 

Portfolio Management reports white papers

Posted By Posted by: EPM Partners on June 27, 2011

A number of Microsoft bloggers have recently announced some great new content for Project Server reporting and I thought that it is well worth repeating here.   Copied from Christophe’s Blog: I’m thrilled to announce the release of the following two white papers which provide step by step guidance on surfacing key Project Portfolio Management

Read More


Blog Posted In Blog Posted In: Project Server, Reporting
Blog Posted In 

Removing Unwanted HTML Contents from SQL Server Reporting Services (SRS) Reports

Posted By Posted by: EPM Partners on June 20, 2011

When using SRS to deliver reports derived from data entered through multiline text fields, SRS frequently returns non alphabetic characters like those returned below: The following VB function removes unwanted HTML content from data retrieved from the Project Server Reporting database that is managed originally within a multiple-Line field on a Project Detail Page (PDP).\

Read More


Blog Posted In Blog Posted In: Reporting
Blog Posted In Comments Off on Removing Unwanted HTML Contents from SQL Server Reporting Services (SRS) Reports

Resource Utilisation Report

Posted By Posted by: Laith Adel on March 10, 2011

I have been asked so many times to develop/configure a resource Utilisation report that would be simple, easy to read by users and accurate. Although Project Server comes with a nice graphical (and tabular) view of resource availably and Utilisation through Project Web Application (PWA) – “Resource Availability” , like the graph below: I find

Read More


Blog Posted In Comments Off on Resource Utilisation Report

SQL Reporting Services Integration Errors

Posted By Posted by: EPM Partners on December 2, 2010

When trying to configure the SQL Reporting Services Add-in for SharePoint 2010 from Central Admin you might see the following error:   (Error Text: Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. …) Most common cause: Kerberos There are actually a few causes

Read More


Blog Posted In Comments Off on SQL Reporting Services Integration Errors

Your First PerformancePoint Report

Posted By Posted by: EPM Partners on August 7, 2010

One of the biggest areas of advancement in Project Server 2010 is reporting, with Project now utilising; Excel Services, SQL Analysis Services, SQL Reporting Services and PerformancePoint the options are almost endless. However most people I encounter look at that list and say; “What on earth is PerformancePoint?”, so lately I had another opportunity to

Read More


Blog Posted In Blog Posted In: How to, Reporting
Blog Posted In Comments Off on Your First PerformancePoint Report

Quickly Updating the Default BI Data Connections

Posted By Posted by: EPM Partners on July 12, 2010

As you’ll quickly find in Project Server 2010, if you want to use the default Business Intelligence Center data connections then in order to include your own custom fields, then you’ll need to update the connectors. Here’s a quick guide on doing that to get to that data for your first Project Status Report. Before

Read More


Blog Posted In Blog Posted In: How to, Project Server, Reporting
Blog Posted In Comments Off on Quickly Updating the Default BI Data Connections

SQL Reporting Services 2008 R2 Required for SharePoint 2010 Add-in

Posted By Posted by: EPM Partners on May 14, 2010

Found this one out the hard way this week; it seems that currently the only supported version of SSRS for the SharePoint 2010 SRS Add-in is SQL 2008 R2. At least one forum poster from MSFT has confirmed this. Annoying as it can be surprisingly hard enough to convince customers to install Windows 2008 let alone upgrade their SQL servers!

Read More


Blog Posted In Blog Posted In: Project Server, Reporting
Blog Posted In Comments Off on SQL Reporting Services 2008 R2 Required for SharePoint 2010 Add-in