The way we approach it is by establishing a baseline report. Run the report and manually step through it to confirm accuracy then use this report for a baseline to automatically compare the future runs against. This requires that the server generating the report have a test schema set up where data can be static but the application being tested with the data is updated as it is released. This also permits the automation tool to create it's own data to test with which will not effect the production data in the production schema.
Success is the ability to go from one failure to another with no loss of enthusiasm.
~ Winston Churchill ~
Also do remember the balance sheet is mandated by law hence it has to adhere to prescribed rules. Validation in those terms also becomes important, I'd guess you cannot catch "window dressing" and save the world [img]images/icons/smile.gif[/img] but you can try in other areas.
Thanx for the insight, but like for e.g. we have a report that generates the cash-flow or bueget statement for a project. Now the data in the report that is so generated is culled out from various data sources. So how are we gonna test the dynamism involved in the report ?
Software Test Engineer
If you cannot think about changing yourself, you don't have the right to change the world.
Follow the data. Process map the whole application and then get your data elements in the map. Trace it from end-to-end and count the number of hops each element takes and validate each and every transformation it undergoes.
Prepare Test Data and ensure that the values in the Balance Sheet are similar to the Expected Result. I understand that this is little time consuming but this is the way that you can ensure that the values are correct. Again instead of testing whole of the Balance Sheet at one time I would advice you to breakdown the Balance Sheets into different sections and ensure that the value is pulled out for each field is correct. Managing smaller parts would be simpler and easy to handle and hence design your test data accordingly.
First Differenciate the assest and liabilities Analyse what has tocome under asset and liabilities.
Because the value should not get interchanged. Depend on the value the balance sheet is validated.