I've recently ran into some issues where some reports were not generating the proper results. We already have a QA department that reviews the reports and then our business owners review them as well; this hasn't prevented the issue.
I'm trying to figure out a decent way to have a test harness to ensure reports are giving me the desired result.
So far, I've thought about having a static snapshot of the database (point-in-time), I would then
- run the report sprocs (stored procedures) against my data with defined parameters
- save off the output
- write testing sprocs that call the reporting sprocs with my define parameters
- Verify the results matched using the EXCEPT keyword.
Can you please offer some suggestions and alternatives?