Testing?

[singhd]

Could someone help me identify what could be part of Unit Testing for reports

[Lynn]

Funny, your question reminds me of a client I had recently that asked me to participate in interviewing candidates. I asked one guy a similar question and his response was "if you don't get any error messages then it is ok". Safe to say that is not a good answer.

Any or all of the following items are things that I think should be addressed in testing:
- Comparison of report requirements documentation with the developed report to assess degree to which each stated requirement has been met (or not)
- Data validation: comparing to existing reports with similar metrics; writing comparable SQL directly against the database; dumping output to Excel for computation comparison of summaries and row-level computations; review of generated SQL
- Format validation: precision of numeric values; consistent text formatting; adherance to defined standards within the organization.
- Performance testing: preliminary review of run times; adherance to desired SLA;
- Functionality testing: all supported output formats produced to required specs; various prompt combinations yield proper results; prompt options presented properly; scheduling supported properly if needed; bursting supported properly if needed; etc.