Sunday, February 19, 2012

Documenting a reporting services site

Does anyone know of a good tool that will help with documenting a reporting services website? I inherited a prebuilt site and I am trying create some documentation about it. I have tried Visio, but it documents down to layers I do not need to go to. I just need the folder heirarchy and the reoprts within each folder.

Thanks for you help!

frank

Sorry - we don't have such a tool in the box. You can use a script to do this pretty easily. Create a VB.Net based script to call the ListChildren API recursively. Run it in rs.exe. You can format the output into a tree pattern to make it presentable.

-Lukasz


This posting is provided "AS IS" with no warranties, and confers no rights.

|||do you know if this is something that is possibly going to be in the "tool box" at a later date?|||

Not right now - we're working on our plans for what's coming in the future. This doesn't look like it will make it for the next release.

-Lukasz


This posting is provided "AS IS" with no warranties, and confers no rights.

|||Give RS Scripter a try.
http://www.sqldbatips.com/samples/code/RSScripter/readme.htm#_installing_rss
Once they're on your local machine, you can go to the command line and do a dir /b /s > list.txt to get a list of files by directory.
The information is also stored in the ReportServer database.

No comments:

Post a Comment