I wanted to call your attention to this new TechNet article on how to set up Excel Services with Project 2007. http://technet.microsoft.com/en-us/library/cc770224.aspx
This set up procedure was developed by my Business Intelligence team with the Excel Services team. One of the items which will make it easier to implement is that this procedure does not require Kerberos for your security setup. It also enables report creation using a tool that is very familiar to report creators.
Enjoy this and more original Project posts at our blog: http://blogs.msdn.com/project
In planning your Excel based reporting solution, you may also be interested in this “light” reading list below.
- Excel Services Data Connection Demo http://office.microsoft.com/en-us/sharepointserver/HA102078901033.aspx
- Planning External Data Sources http://technet.microsoft.com/en-us/library/cc262899.aspx
- Plan Data Connections Management http://technet.microsoft.com/en-us/library/cc263151.aspx
- Plan Excel Services Security http://technet.microsoft.com/en-us/library/cc263086.aspx
Once you’ve set up your environment, these sample reports can easily be implemented. You will need to change the data connection in each report to use the correct Single Sign On(SSO) id that you’ve configured. http://blogs.msdn.com/chrisfie/archive/2008/04/13/new-excel-services-sample-reports-for-project-server.aspx