Post reply

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

  • May 29, 2015 at 11:41 am

    #1801674

    Thank you for that info, Alan. The query does give me a lot of what I'm looking for. The only thing it doesn't offer is a method of documenting the report or dataset with plain text in which I can describe the purpose of the report, which user requested it and an easily readable running description of changes that were requested. For that purpose, I'm looking for a method of creating a running text narrative that can be accessed by current and future developers over time. Unfortunately, the Description field is completely inadequate for my purpose.

    Is anyone out there documenting their reports using the level of detail I'm looking for?

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply