Reminder when Testing Reports

It is essential for the QA to check the consistency between the actual data in the DB and the values given in a report.

We should at least check for the top level data values in the DB by writing a simple query. In some past projects there have been significant differences in the actual DB contents and the values given in the reports.

A simple example is:

SELECT REASON_CODE,SUM(AMOUNT) FROM CC_CREDIT_ADUSTMENTS WHERE CREDIT_DIRECTION="DECR" GROUP BY REASON_CODE
+-----------------+------------------+
| REASON_CODE | SUM(AMOUNT) |
+-----------------+------------------+
| 2000 | 2746.928 |
| 2001 | 3312.494 |
| 2002 | 3427.635 |
+-------------+----------------------+
If the top level query results do not match with the report contents then there seems to be some serious issue and we should take the necessary actions.