Below are links to projects in Codeplex.com where you can download the Adventureworks Sample databases and sample codes for reporting services. I have included a link to download a report to link SQL Agent job names created by Reporting Services to Report Names and some other useful queries against the Report Server databases.
Also a link to the Demo files I use in our BI6236 class. And finally a link to a website that has a T-SQL function for splitting a comma-delimited list into a multi-row table.Â
 Adventureworks Sample Databases – http://msftdbprodsamples.codeplex.com/
Reporting Services Sample Code – http://msftrsprodsamples.codeplex.com/
RS Server Mgmt Report Samples – http://msftrsprodsamples.codeplex.com/wikipage?title=SS2008%21Server%20Management%20Sample%20Reports&referringTitle=Home
Report Server Job Report, All Subscriptions Query, Cache Expiration Query – http://75.126.165.131/files/sql/reportserverjobreport.zip
BI6236 Course Demo files – http://75.126.165.131/files/sql/bi6236demos.zip
RSScripter and RSLinkGen tool – http://sqldbatips.com
Code for a Split function you can use to convert multi-valued parameters into a table so you can use them in a stored procedure or function – http://tinyurl/fnsplit
