i was looking through the threads a couple of days again and someone wanted an inventory of their SSRS server reports.
one poster pointed the OP to this url http://qa.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/69257/
it contains a number of RDL files, one of which is a report for ReportQueries.rdl, this will loop through the RS db and show the commands within the data sets of the reports, I would recommend to download and store them somewhere as there look very useful in seeing whats happening/happened on SSRS.
but the command basically boils down to this
set transaction isolation level read uncommitted
;WITH ReportItems (ItemID, Name, Path, reportXml) AS
(
SELECT ItemID
, Name
, Path
, CAST(CAST([Content] AS VARBINARY(MAX)) AS XML) AS reportXml
FROM Catalog
WHERE (Type = 2)
)
SELECT ItemID
, Name
, Path
, report.commandText.value('.', 'nvarchar(MAX)') AS commandText
FROM reportItems
CROSS APPLY reportXml.nodes(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"; //CommandText/text()') AS report(commandText)
UNION ALL
SELECT ItemID
, Name
, Path
, report.commandText.value('.', 'nvarchar(MAX)') AS commandText
FROM reportItems
CROSS APPLY reportXml.nodes(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition"; //CommandText/text()') AS report(commandText)