Ultimately my goal is to create a report in Reporting Services 2012 Integrated that will roll up workplan lists from client sites to display in a grid format. Is there a way to query similar lists among all client sites? Too keep it simple, is there a way to just query all the project names from across all client sites? Thanks!

In other words, we want to create a roll up report in SSRS 2012 of our task lists from our 100+ Sharepoint 2010 sub-sites. This would result in displaying these tasks in a similar way as the rollup web parts would. However, this project requires summary of data (counts, totals, conditional totals, etc..) as well as flexibility of filtering that keeps us from using a roll up web part. One additional requirement would be that the sites are added and removed. This results in a need for this report to have a dynamic aspect to its data connections.