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 firstname.lastname@example.org, and we will send you a document describing them.