?
Solved

SSRS Reports Documentation

Posted on 2009-05-08
9
Medium Priority
?
905 Views
Last Modified: 2013-12-12
HI , I have a requirement to document all of our existing SSRS reports and the new ones as well.
Can any body please help me or provide me with an example of how do i document the SSRS reports which i develop ? is there any standards or formal approaches to do this ?
0
Comment
Question by:gvamsimba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
9 Comments
 
LVL 29

Expert Comment

by:QPR
ID: 24343266
what do you mean, document the reports?
You want to write up what each report is, what it shows and what parameters it takes?

Or you want to document the code behind the report including the SQL?

Either way, I don't know of any way to programmatically do this. I'm afraid you may have to get busy with MS Word :)
0
 
LVL 27

Expert Comment

by:Chris Luttrell
ID: 24343397
yeah, to document our reports for the end users, we generally have a screen shot of a sample report page(s) with descriptions of the Parameters that the report uses and breif description of what the results mean.  For technical docs we add what stored procedures are behind the report and leave the code to document itself, both the db sp and the rdl files.  I do not know of anything that would do this automagically either.  Good luck, let us know if you find one.
0
 

Author Comment

by:gvamsimba
ID: 24343493
well, i actually If i want to do it in a MS Word doc, what exactly do i have to include in that...does anybody have any example docs or something like that ?
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 29

Expert Comment

by:QPR
ID: 24347419
Really it depends what you want to document.
Who is the documentation aimed at? End users, developers, people who may purchase the reports.
Create yourself a template with some headings and go from there.

Title. Created Date. Author. Category. Description. Purpose. Parameters. Output. User interaction (e.g. paging and sorting)
0
 

Author Comment

by:gvamsimba
ID: 24347593
Thanks QPR

Yes Please, Documentation should be aimed at end users in particular and also to developers if needed.. we can include details like
Title. Created Date. Author. Category. Description. Purpose. Parameters. Output. User interaction (e.g. paging and sorting)

Can you please help me how do i create it..shall i use MS Word or is there a better way of doing it ? and also can you please tell me what information do i have to include in the Report Header and Footer ?
0
 
LVL 29

Accepted Solution

by:
QPR earned 2000 total points
ID: 24347612
To my knowledge there are no rules to this.
Put yourself in the shoes of the user and think what info would be useful to you.
Describe the report to them, tell them what info (parameters) they will need to supply, tell them what columns will feature in the report. That sort of thing.

I don't know of any tool/template out there to start you off. How would the tool know what your report shows etc. Just type up a document (word or other) and just write it as you would a readme file of a help document.
0
 

Author Comment

by:gvamsimba
ID: 24347768
Ok thanks QPR, i will do that in MS Word then...as i am a newbie to SSRS, could you please tell me
what information do i have to include in the Report Header and Footer in general ?
for example if i am developing a  summary report which provides the total number of patients by sex and age band,
what do u think best fits in the header and footer metadata in the above example ?

Many thanks..
0
 
LVL 29

Expert Comment

by:QPR
ID: 24351620
you may need to open a new question this so that all experts can offer help. This question dealt with documenting existing reports
0
 

Author Closing Comment

by:gvamsimba
ID: 31579615
ok thanks
0

Featured Post

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
All of the resources available today make learning a new digital media easier than ever-- if you know where to begin. This is a clear, simple guide to a few of the basic digital art mediums and how to begin learning them on your own.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question