I was asked lately how to find the great reports and dashboards that Microsoft shows in its sales demonstrations. Happily, Microsoft makes those example files available online for anyone who has Project Server 2007. The reports are based on Microsoft SQL Reporting Services which has a wide range of reporting functionality. You could, for example, create reports which are scheduled to leave the report file in a particular area and then automatically send an email notification to someone that it’s ready to be viewed. The files are best looked at as examples of how to get SQL Reporting Services reports into Project Server 2007 and how to connect those reports to the Project Server 2007 Reporting Database.
You can see the links to these files on the new Download Tools Page.