Excel Services Reporting for Project Server

Project Server 2010 has taken the integration with SharePoint to a new level. As a result, users of Project Server have four main choices of Business Intelligence (BI) tools to use for reporting: Project Server Views, Performance Point, SQL Reporting Services, and Excel Services. Excel Services has the advantage that Microsoft Office Excel can be used as the tool to develop or modify reports.

But there are some subtleties that must be addressed when accessing Excel Services reports over the Internet (or even within a corporate network). This is because by default, Excel will try to make a direct connection to the data source. If the data source is a database (like the Reporting Database for Project Server), then this direct connection may not be available over the Internet (or in a corporate network).

By changing configurations from their default values, the Project Hosts Operations team has developed methods to get around this problem, allowing users to open Excel Services reports from Excel on their PCs. If you are interested in learning more about these methods, please email info@projecthosts.com, and we will send you a document describing them.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: