Home Forums Reporting Services Reporting Services 2008 Development Documenting a Report in SSRS 2008 R2 RE: Documenting a Report in SSRS 2008 R2

  • May 29, 2015 at 12:58 am

    #1801483

    You can get most of what you are looking for by querying <your ReportServer DB>.<schema>.catalog. You can get the RDL/XML by casting the Content column as varbinay then as XML like so:

    SELECT CAST(CAST(CONTENT AS varbinary(max)) AS XML), *

    FROM dbo.[Catalog]

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001