I'm inheriting a solution that creates a project site in sharepoint and then writes a InfoPath form to that site's library to save the project details. Now I need to create a report against all projects. My initial reasearch is telling me that I'm going to have to make a webpart to programmatically run thru each site, grab the InfoPath xml file, and put them all together and then query it with xquery or something. Does anybody have any alternatives or any guidance to this to help get me started. I'm a seasoned .net web developer, but this infopath/sharepoint combo has got this '3-teir' guy a little bit confused.
B