There is a comprehensive round-up of current SQL Server reporting samples from Microsoft available on Codeplex here http://www.codeplex.com/MSFTRSProdSamples. Samples include reports for SQL Server 2005 and SQL Server 2008.

To run the individual reports featured in these samples go to the Report Library page.