Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Help with writing a spec document for rpt project

Author  Topic 

cidr
Posting Yak Master

207 Posts

Posted - 2009-07-12 : 09:50:57
Hi there,

I've recently been asked to write my first specification document for a project that will contain a suite of reports. As this is my first time, I'd like to ask advice on the best ways to do this. For example, what information should I include, what is the best layout? should I write a spec for each report seperately?

If there is articles or books out there that will help me or even have spec templates that will help, perhaps you could let me know.

This is obviously to plan for my project with time scales etc

Thanks in advance for any help I receive.

yavvie
Starting Member

46 Posts

Posted - 2009-07-27 : 09:35:51
Definitely write specifications for each report. If you are the person who knows the data then dont forget to mention all the filters / parameters you will need there, if you don't know the data very well find someone who understands them and can explain to you what he needs for his work with the data (don't expect those people to know exactly what they need, that is your job to guess) and then give them your ideas to comment.
You need to tell the developers who will have access (so they can implement security), what data you need, how you need to display them, how you want to filter them, what parameters you will need, where should be links to detailed data / to what data.
The approx time to create a simple report with testing is 2 days, the more complex the more time it takes the developer and the tester, so count that it as well. One of our most complex reports took 10 mandays to create, 30 mandays to test and then another 10 mandays to work in the new/changed requirements and fix bugs.
just a thought: we had our specs together with excel charts of each report, where was a simple design and some example data to help us create the report.
Go to Top of Page
   

- Advertisement -