Thanks very much, Jacob.
This is terrific - exactly what I was looking for.
A small note - if you are developing for SQL Server 2008 R2, you will need to modify the XML namespaces at the top of the query.
I have used: 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition'
commented on Sep 30 2011 8:57AM