SQL Server Reporting Services Reports using SharePoint Lists as a Data Source

Here is a good article describing the options for using Reporting Services with SharePoint Lists:

http://rockstarguys.com/blogs/colin/archive/2006/11/10/accessing-sharepoint-list-items-with-sql-server-2005-reporting-services.aspx