Find SSRS report designs that reference a specific stored procedure:
SELECT
CAST(CAST(content AS VARBINARY(MAX)) AS XML),
Path,
Name,
CreationDate,
ModifiedDate
FROM
dbo.Catalog
where
cast(CAST(CAST(content AS VARBINARY(MAX)) AS XML) as varchar(max)) like '%spRptPMWIP6%'