Simplest way would be to use the For XML clause in your query. Persist the query to the file system. Now you can connect to this using Report Builder.

I do have an example in my recent book on SQL Server Reporting Service 2012 the details of which you can find here:

http://www.sys-con.com/node/2712920

or here:

http://hodentekmsss.blogspot.com/2013/05/contents-of-my-forthcoming-book-on-sql.html

The links in the book are presented here:

http://hodentekmsss.blogspot.com/2013/06/links-in-book-learn-sql-server.html