--Try this query

;WITH XMLNAMESPACES (

DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition',

'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner' AS rd

)

SELECT

name,

path,

x.value('CommandType[1]', 'VARCHAR(50)') AS CommandType,

x.value('CommandText[1]','VARCHAR(MAX)') AS CommandText,

x.value('DataSourceName[1]','VARCHAR(50)') AS DataSource

FROM (

select name, path,

CAST(CAST(content AS VARBINARY(MAX)) AS XML) AS reportXML

from ReportServer$EVAL.dbo.Catalog --Put your report database name here instead of "ReportServer$EVAL"

where content is not null

and type != 3

) a

CROSS APPLY reportXML.nodes('/Report/DataSets/DataSet/Query') r(x)

ORDER BY name