This video demonstrates creating a simple report using Microsoft Report Builder 3. The report uses the US Aid Database. A cleaned version of this database as both raw data and also as multiple tables are included here as a SQL Script;
USAidDatabase-MultipleTable.sql
http://online1.daytonastate.edu/player2.php?id=37e7897f62e8d91b1ce60515829ca282
http://www.microsoft.com/download/en/details.aspx?id=6116 - Download link for Report Builder 3
Full tutorial on using Report Builder - http://www.mssqltips.com/sqlservertutorial/2100/report-builder-30/