I tried to deploy a web service that allows me to use TFS queries as data source on some of the reports. The benefit of using TFS queries vs. the data warehouse is that you don't have the delay of data update from the operational data store to the data warehouse.
Anyway after getting the code snippet from
this post and tweaked it a little bit. I'm ready to deploy it to a IIS server. I ran into an error that complains about the permission of to the global assembly cache. After some digging online the following post helped me fixing the issue, specifically step #5. Thanks Dan! Great job writing up the post!
http://blog.hmobius.com/post/2006/06/30/Problems-with-IIS5-dotNet-v11-to-v2-migration-woes-part-5.aspx
Thanks to Ewald as well for providing a great solution in SSRS.
