May 28, 2015 at 11:42 am
I have not found any places to adequately document a report in SSRS. The only place I see is the Description field in the report properties. I'd like to hear from you if you have an inventive way to properly document a report with items such as Creator, Date Created and Description. More importantly, I'd like to include a running list of dated & descriptive updates to the report.
In addition, I'd like to also document the purpose of each dataset used in the report. I could do that in the Stored Proc, but I'd like to do it in the SSRS project. Can you share some ideas of how you do it in your projects. Thanks
May 29, 2015 at 12:58 am
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]
-- Itzik Ben-Gan 2001
May 29, 2015 at 11:41 am
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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply