Anyone have any good ideas on how to automate the process of testing the contents of reports? Charles R. had one good idea about stripping the contents of the report into a CSV, etc file and doing some DB Queries to compare and was just wondering if anyone else had any ideas.
Thanks In Advance
Life should NOT be a trip to the grave with the intention of arriving safely in an cool and well preserved body, but rather to skid in, chocolate in one hand, beer in the other, body wrecked, totally worn out and screaming WOO HOO what a ride!
You could write a script to call the module that does the data gathering to get a raw feed. Then with that data, run your own formatting script to act as an oracle, to verify that the data is formatted properly (sorting, filtering, text layout.)
You could write a query that gathers the data directly from the database to act as an oracle, to verify that the data is gathered properly.
You could point the report at a different set of data, with all sorts of test scenarios in the data, to ensure it properly handles the data. Some examples might be null fields, type mismatches, duplicate rows, large number of rows, ASCII characters, etc.