4/29/2011

Reading RDL Definitions directly from a ReportServer database LINK

This handy link is quite powerful as it allows you to quickly scan all your reports in Reporting Manager for specific values.  Thanks to David Jennaway for this excellent snipped of code...

- Click here for Link -


SELECT
        CONVERT(varchar(MAX)
      , CONVERT(varbinary(MAX), c.[content]))
      , c.[Path]
      , c.[Name]
FROM [ReportServer].[dbo].[catalog] c
where
      c.[content] IS NOT NULL
      AND CONVERT(varchar(MAX), CONVERT(varbinary(MAX), c.[content])) LIKE '%@User%'

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Thoughts to Ponder